We are facing an ODBC issue when trying to run our VB application on Windows 7 Enterprise ( 64 bit OS) machine which uses MS Access and SQL Server as database
The connection string which we use in our application is coming looks like : ConnectionSystem=PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\ database.mdb.
The error message which we face is “[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified”
The application works fine when we install the application on Windows XP machine.
To resolve this issue we tried to change the connection string to “ConnectionSystem =Dsn=Microsoft Data Access; DBQ=c:\ database.mdb.” even tired using Microsoft.Jet.OLEDB.4.0 but didn’t work.
Can any one suggest on it
ANSWER 1:uninstall manually - did the following (shows issues with some of the directions)
i see the setup files installed but have not see the snac.
any other ideas? do i need to reload the c drive with a new copy of the operating system and try again?
thanks!
Note : Provide your comments by clicking beloe options! Thanks ! :)
The connection string which we use in our application is coming looks like : ConnectionSystem=PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\ database.mdb.
The error message which we face is “[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified”
The application works fine when we install the application on Windows XP machine.
To resolve this issue we tried to change the connection string to “ConnectionSystem =Dsn=Microsoft Data Access; DBQ=c:\ database.mdb.” even tired using Microsoft.Jet.OLEDB.4.0 but didn’t work.
Can any one suggest on it
ANSWER 1:uninstall manually - did the following (shows issues with some of the directions)
- it said to delete the local security groups. but i never could figure out how to do. the article it mensions didnt (at least to me) show how to delete. so i just went on
- looked and stopped one sql service
- made sure sql server support files were installed
- attempted to run the arpwrapper.exe but got the error - registry enumeration failed.
- so went to the if you have problems section (that's where you go if you get the registry enumeration error)
- went through the guids listed in the registry under unistall. there was never one for snac. but did run the start command for each sql server one i found.
- checked back on add/remove and there were no sql programs listed as installed.
- it then says to remove the snac in add/remove - but it's not there - that is the problem.
i see the setup files installed but have not see the snac.
any other ideas? do i need to reload the c drive with a new copy of the operating system and try again?
thanks!
Note : Provide your comments by clicking beloe options! Thanks ! :)
0 comments:
கருத்துரையிடுக