ERROR : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

.net visual-studio-2005 odbc datasource
Amrita picture Amrita · Nov 12, 2008 · Viewed 191.3k times · Source

While connecting .net to sybase server I got this error message:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This has worked properly before. System DSN with same details work and data connection through vs.net also work.

I am using vs.net 2005.

Any suggestions?

Answer

SqlRyan picture SqlRyan · Feb 17, 2011

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.

Related questions

Cannot find Dumpbin.exe

I do not see dumpbin.exe on my system. I have Visual Studio 2005 on my system. When I type dumpbin on the command line, it says unrecognizable command. Does it come with Visual Studio by default, or do I have …

Read More
How do I programmatically get the GUID of an application in .net2.0

I need to access the assembly of my project in C# .NET2.0. I can see the GUID in the 'Assembly Information' dialog in under project properties, and at the moment I have just copied it to a const in the …

Read More
Panel.Dock Fill ignoring other Panel.Dock setting

If you create a panel on a form and set it to Dock=Top and drop another panel and set its Dock=Fill, it may fill the entire form, ignoring the first panel. Changing the tab order does nothing.

Read More