Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cannot create a sql server data source


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.

Not what you were looking for? View more on this topic or Ask a question