Take the 2-minute tour ×

while connecting .net to sybase server... got this error message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

it was working sometime back. system DSN with same detatils work and data connection through vs.net also work.

i am using vs.net 2005

Any suggestions?

share|improve this question
add comment

2 Answers

If you're working with an x64 server, keep in mind that there are different ODBC settings for x86 and x64 applications. The "Data Sources (ODBC)" tool in the Administrative Tools list takes you to the x64 version. To view/edit the x86 ODBC settings, you'll need to run that version of the tool manually:

%windir%\SysWOW64\odbcad32.exe (%windir% is usually C:\Windows)

When your app runs as x64, it will use the x64 data sources, and when it runs as x86, it will use those data sources instead.

share|improve this answer
I tried this here, and it keeps crashing my ODBC Administrator, any ideas? –  Codejoy May 27 '12 at 22:55
what i need to change in the settings for a 32 bit app ? –  Peru Aug 8 '12 at 9:57
add comment

follow these steps

  1. Start Registry Editor by typing regedit in Run window

  2. Select the following key in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

  3. On the Security menu, click Permissions.

  4. Grant Full Permission for the account which is being used for making connection .

  5. Quit Registry Editor.

share|improve this answer
add comment

Your Answer

