on 04-18-2016 2:09 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.