ODBC Connection for SQL Server

[sac_123]

Hello Everyone,

I am trying to create ODBC connection for SQL Server 2012 and 2016. The drivers I tried is SQL Server and ODBC Driver 7 for SQL Server. while creating connection I am getting attached error. Can anyone please help me to understand why I am getting this error.

I want to access Crystal reports using this connection.

Thanks,

Sujith

[ayman_salem · Accepted solution]

This error has nothing to do with BusinessObjects.

Contact your MS SQL Server administrator to check and establish the connection from the BI client / server to the DB server

[denis_konovalov]

As Ayman said, this error comes from your SQL server, so your DBA need to resolve it for you, or you can try Microsoft SQL knowledge base or forums to get help

[Sriram2009]

Hi Sujith.

From the error screenshot error code, 53 mean the network path was not correct, Could you check your server path. refer to the SAP Note 2709727.

Regards

SS

[mhmohammed]

Did you try to create a 64bit ODBC connection, instead of 32bit? Use the search icon on Windows desktop and type in ODBC, you'll see 2 ODBC options come up, one for 64bit and the other for 32bit, use the 64bit option and then create an ODBC with the same details.

Thanks,
Mahboob Mohammed

[sac_123]

Hi Mahboob,

Thanks for your suggestion, I tried with 64bit as well but getting same error message.

Thanks,

Sujith

[DellSC]

You need to use the latest ODBC driver which, I believe, is 13. You could also try using SQL Server Native Client 11.0, which I've had a lot of success with .

-Dell

[sac_123]

Tried with latest ODBC diver and SQL Server Native Client 11.0, but still same issue I am getting.