Hello, i installed Sybase, sql anywhere12 for first time am trying to open Demo DB from Sybase Central 6.1.0 every time when i choose Start And Connect To A Database On This Computer. it give me error could not connect to the Database,the ODBC driver manager could not find the data source note that the Demo12 sql anywhere db is started successfully in system try icon " Windows 7 86bits"
Can you click "Show Details" on the Sybase Central error dialog. This will provide more details that would help in resolving this issue.
Please contfirm that the error you are seeing is "The ODBC Driver manager could not find the data source." and the "Show Details" reports:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified SQLCODE=0 SQLSTATE=IM002
If this is the error, the problem is that Sybase Central is unable to locate the ODBC driver. It is either not installed or the entries in the registry are missing. The solution is to install the driver if not currently installed and/or re-register the driver.
It is possible that Sybase Central and the installed ODBC driver are not the same bitness. You can check the bitness of Sybase Central (scjview.exe) in Windows Task Manager which marks 32 bit processes with " *32". Make sure that you register the ODBC driver that is the same bitness as Sybase Central.
To register the driver, execute the following:
for 32-bit on 64-bit systems:
for 64-bit on 32-bit systems:
Ha, nice try:)
You are the best
answered 22 Oct '13, 08:03