Skip to Content

Connection String Format

Hie Guys,

I have a connection string to a SQL Server Database. I am trying to use the connection string to create a new ODBC Connection. After I enter the connection string, I'm prompted to enter the database name, user name and password.


However, I'm getting an error message - "Failed to open the connection" when I'm done creating the connection. I think I'm not getting the correct format for the connection string in Crystal Reports. Could you help me get this issue resolved? I've attached the connection string below. Thanks.

DRIVER = SQL Server; SERVER = prodsql; DATABASE = Entops; UID = abc; PASSWORD = abc123

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 08, 2014 at 10:56 AM

    Hi Jeevan,

    With SQL Server, it is recommended to use the SQL Server Native Client 10.0 driver.

    Please install that and try with this string:

    Driver={SQL Server Native Client 10.0};Server=prodsql;

    Database=Entops;Uid=abc;Pwd=abc123;

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2014 at 05:24 PM

    To add to what Abhilash replied.

    MS SQL Server 2008 does not work with the MDAC version of the Native drivers, you must install the MS SQL Server Client. You'll see the driver name is "MS SQL Server Native client 10". This is the one you need to use. Alternatively, use ODBC, it seems to resolve all issues, but the client must be installed.


    For OLE DB then use:

    MS SQL 2005 - OLE DB Provider

    MS SQL 2008 - SQL Native 10

    MS SQL 2013 - SQL Native 11

    For ODBC then use:

    MS SQL 2005 - SQL Native

    MS SQL 2008 - SQL Native 10

    MS SQL 2013 - SQL Native 11

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.