topic Re: Error while using native SQL to connect to MS SQL in Application Development and Automation Discussions

Error while using native SQL to connect to MS SQL

Former Member — Thu, 23 Aug 2007 10:12:43 GMT

Hello everyone.

I am getting a dump executing native sql commands to connect to sql server 2000 database .

The code that is causing the dump is

EXEC SQL.

CONNECT TO 'MSSQL3'

ENDEXEC.

The dump shows the below error

"Error setting up a secondary database connection"

Kindly help me resolve this issue

Re: Error while using native SQL to connect to MS SQL

Former Member — Thu, 23 Aug 2007 10:14:45 GMT

Hi,

1. Check with your basis administrator for connection. See more information in Error.

2. Check note applicable if any on service.sap.com , you will get in error description.

Reward if useful!

Re: Error while using native SQL to connect to MS SQL

Former Member — Thu, 23 Aug 2007 10:16:06 GMT

Hi!

Please refer to OSS Note: 178949

Regards

Tamá

Re: Error while using native SQL to connect to MS SQL

Former Member — Fri, 24 Aug 2007 10:57:05 GMT

Hi All

As explained earlier

I am trying to connect to MS SQL System from ABAP . I have tested and it is successful in network where both SAP and ms sql are installed on Windows Platform, but incase of system, where SAP is installed in unix server the connection fails. Request you to kindly guide on this scenario.

I have referred to SAP Note 178949 - MSSQL: Database MultiConnect with EXEC SQL to resolve this issue but it is for a scenario where SAP is on windows platform and not on unix platform.need to do this scenario in system that has SAP running on unix platform.

The error I get while trying to connect to ms sql is as below

connection to database system not possible using identifier "mssql" .

mssql is the name of the connection I have maintained in DBCO transaction.

Has anyone worked on such a scenario?

Kindly guide me resolve this issue.