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"

asked 25 Sep '11, 07:47

enghussein's gravatar image

enghussein
15112
accept rate: 0%

edited 15 Mar '13, 22:08

Mark%20Culp's gravatar image

Mark Culp
22.5k9129264

Do you have an ODBC source (DSN) for the demo db? If you have it, try testing it with the button on the front page

(26 Sep '11, 05:20) Martin

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:

regsvr32 "%sqlany12%\bin32\dbodbc12.dll"

for 32-bit on 64-bit systems:

"%WINDIR%\SysWOW64\regsvr32.exe" "%sqlany12%\bin32\dbodbc12.dll"

for 64-bit:

regsvr32 "%sqlany12%\bin64\dbodbc12.dll"

for 64-bit on 32-bit systems:

Ha, nice try:)
permanent link

answered 27 Sep '11, 09:19

Chris%20Keating's gravatar image

Chris Keating
2.5k1445
accept rate: 23%

edited 27 Sep '11, 09:28

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646

hello thank you for your answer, yes as you said i found that the ODBC driver not probably installed, when i tried to register it again, it didnt success, when i open the key value in the regedit it give me " cannot be opened ,access is denied" i dont know why!!

but i made rename to the dll file and i tried to register it with different name, and it work now

  • but why i have to chose the ODBC driver while i select data base running on this computer! thank you for your help
(27 Sep '11, 10:28) enghussein

You are the best

permanent link

answered 22 Oct '13, 08:03

Karan's gravatar image

Karan
1
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×405
×124
×124
×90

question asked: 25 Sep '11, 07:47

question was seen: 4,188 times

last updated: 22 Oct '13, 08:03