Firstly, I am considering my answer to show you another better way for connection with MySQL Database, it’s much easier and less nu-expected Exception(s).You need to do some steps: Download Connector/J and add it to your class path(if you are using an IDE there is add the .jar to the library, or there is many … Read more
None of these did it for me. I did find the answer on MSDN. There were hints to it though. The architecture in the error is referring to 32 vs 64 bits. My solution was to find out which my app is running under (Access) which 2010 is 32b. I found this by looking in … Read more
That error is nearly always caused by a bad connection string when an ADODB.connection object has its .open() method called. For example, take the following code: Note how the connection string includes a driver identifier, in this example that is SQL Server. Somewhere in your application you’ll have an adodb.connection.open() method being called with a connection string, you need to find … Read more
According to ADO: ActiveX Data Objects, a book by Jason T. Roff, published by O’Reilly Media in 2001 (excellent diagram here), he says precisely what MOZILLA said. (directly from page 7 of that book) ODBC provides access only to relational databases OLE DB provides the following features Access to data regardless of its format or location Full … Read more
Very simple! On server: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQL Delete the USER data source name and define it as a SYSTEM data source name. Go to -> Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC): – User … Read more
I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I’m getting an error message that says : A problem was encountered while trying to log into or create the production database. Details: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified … Read more