How to set up OLE DB provider for ODBC driver?

Question

Hi please help me with this. i run windows XP SP2 and i have this vb6 project that throws error when i try to run it

Run-time error '-2147467259(80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

i have tried to look for the drivers from the control panel> administrative tool> Data sources(ODBC) but in vain

please help

thanks

Answer 1

Well there is something wrong with your connection string, could be any number of causes... the best and easiest way to create a new connection string is by using the Data Link Properties tool..go here for an explanation on how to do that



http://social.technet.microsoft.com/wiki/contents/articles/1409.how-to-create-a-sql-connection-string-for-an-application-udl-file.aspx



You first have to create a UDL file (just a blank file with *.UDL extension) its very easy, and you can test the connection string using Data Link Properties tool as well. once you have got it working you simply open the UDL file up in note pad and copy the connection string o your VB application

Answer 2

The error you encountered means that your ODBC Connection is not found...



You have done the right thing, following this step

control panel> administrative tool> Data sources(ODBC)



The next thing is have you created your ODBC?



What type of database are you linking? Access? SQL Server?



---



Did you set up your ODBC connection?



Can i see your connection string?

Answer 3

If you need an ODBC Driver check out these. http://www.easysoft.com/products/data_access/index.html