Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies replies
    11
  • Answers answers
    2
  • Subscribers subscribers
    12
  • Views views
    1331
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can not connect to MS SQL Server

Andre4

I am trying to connect with MS SQL Server using acuSql but I get:
SQLCODE -1
SQLSTATE 08001

01 servername pic x(30) value "(LocalDb)\MSSQLLocalDB".

01 userid         pic x(20) value "PCANDRE\andre".


EXEC SQL CONNECT TO :servername as C1
USER :userid USING :passwd

also tried withoud userid.

Configuration: ACUSQL_RUNTIME_DLL asqlsrvr.dll

However this works: sqlcmd -S (LocalDb)\MSSQLLocalDB

Parents Reply Children
  • 0 in reply to 

    did you compile using -pk

    and

    Windows:

    The new runtime DLL is named asqlsrvr.dll. You can use this DLL in two ways:

    • Rename the DLL to esqllib.dll for the runtime to use this DLL when attempting to execute any AcuSQL commands.
    • Give the DLL a name of your choice, and set the configuration variable ACUSQL_RUNTIME_DLL to the name you have chosen. Keep the name as asqlsrvr.dll and setting ACUSQL_RUNTIME_DLL to asqlsrvr.dll.

    SW Engineering(QA)  

    Although I am an OpenText employee, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

  • 0   in reply to 

    What does a trace show? - portal.microfocus.com/.../KM000005044

    ---

    Martin Turner

    Senior Technical Support Engineer

    Rocket Software

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.