Hi,
I'm testing ODBC connection using VB.NET 2008.
Fisrt I have created, with ODBC manager, an User ODBC connection named 'XXX' that works fine (all test passed).
In my program I set the ConnectionString so: myODBC.Connectionstring="ODBC=XXX;"
when I try to open the connection VB goes in error :
SQL Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Scriptline:
SQL State:IM002
I'm confused what is the mistake?
Thanks
additional information copied from non-solution below
At last I looked in the system registry (HKEY_CURRENT_USER\Software\ODBC\ODBC.Ini\XXX)
and the data are valid the name of the ODBC is the right one , I did the test with both a System DNS , but I have same result.
I'm working on PC where is installed XPPro 32bit.
The DNS appears under User DNS
Help me