cannot create a sql server data source

[Former Member]

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.

[former_member183750]

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

[abhilash_kumar]

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

[Former Member]

Hi,

Thank you.

I am using win 7 32 bits.

[abhilash_kumar]

And what driver do you use to connect to the database?

-Abhilash