none
[Microsoft][ODBC Driver Manager] Data Source name not found and no device driver specified

    Question

  • I get the above error message when running my VB6 sp4 application on a new Win7 workstation (32 bit machine). The app runs fine on a WIn xp sp3 workstation. The app does require a DSN setup in the ODBC section and I setup the SQL connection the same as I do on an XP machine. I also test the connection on the WIN & machine and it "test successfully". After the error above the app returns a runtime error -2147467259 (80004005). I am attaching my connection string:
    Connection string being used by ADO Data Control (part of VB6):
    Provider=MSDASQL.1;Extended Properties="DRIVER=SQL Server;SERVER=CLAIMSSERVER;UID=;APP=Visual Basic;WSID=CLAIMSSERVER;DATABASE=LRAWITS;Trusted_Connection=Yes"
     
    Any help would be appreciated.

     
    Thursday, November 11, 2010 4:57 PM

All replies