Skip to Content

cannot create a sql server data source

Hi,

I am using windows 7, 32 bits. When I try to create a sql server data source in crystal report data explorer (ODBC node, create new data source), I will get an error message:

odbc system dsn warning

You are logged on with non-administrative privileges. System DSNs could not be created or modified


I logged windows as admin and I run crystal as admin, Also I go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC, right clicked ODBC add everyone in the permission, and give Full Control, it still has no help.


I can add a new sql server data source in the odbc administrator in control panel without any problem, But it will not show in the crystal report data explorer data source list. Actually, if I double click on other data source, like excel, under odbc node in the crystal data explorer, I will get an error: unable to load odbcji.dll. But it is not my concern.



Please help me to fix sql server data source problem. Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 18, 2016 at 04:07 AM

    Hi Peter,

    CR needs a 32-bit ODBC DSN to be able to connect to the database.

    The 32-bit ODBC Admin is here:

    C:/Windows/syswow64/odbcad32.exe


    Since this is a SQL Server database, make sure you have the SQL Server Native Client 11.0 or 10.0 driver installed.

    Also, have you tried connecting via OLEDB?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2016 at 09:32 PM

    Hi Peter

    One thing to keep in mind re SQL drivers:

    For OLE DB use:

    MS SQL 2005 - OLE DB Provider

    MS SQL 2008 - SQL Native 10

    MS SQL 2012 - SQL Native 11

    MS SQL 2013 - SQL Native 11

    MS SQL 2014 - SQL Native 11

    For ODBC use:

    MS SQL 2005 - SQL Native

    MS SQL 2008 - SQL Native 10

    MS SQL 2012 - SQL Native 11

    MS SQL 2013 - SQL Native 11

    MS SQL 2014 - MSODBCSQL11 [ https://www.microsoft.com/download/details.aspx?id=36434 ]

    - Ludek

    Senior Support Engineer Product Support, Global Support Center Canada

    Follow me on Twitter

    Got Enhancement ideas? Use the SAP Idea Place

    Add comment
    10|10000 characters needed characters exceeded