Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
05-18-2012, 09:53 AM #1
- Join Date
- May 2012
- Thanked 0 Times in 0 Posts
Data source name not found and no default driver specified
i need help regarding on that error...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/csdpanel/common/index.asp, line 254
Write here the line 254
My pleasure of any advise.
05-18-2012, 05:58 PM #2
OLEDB connection is different from ADODB connection.
you call out an ADODB but I presume use an OLE DB connection string... idk, this
is not a connection string I recognize, but I almost strictly do ADO (and it is not an ADO connection string)server=localhost;db=platform_12;driver=MySQL;uid=root;pwd=admin
05-18-2012, 09:58 PM #3
Yes, that is a valid connection string, according to
But it's a really really old driver. It's from the days of MySQL version 2.3 or so (roughly 13 or 14 years ago).
You'd be much better off installing the MyODBC 5.1 driver, especially if you are working with MySQL version 5 or later.
(Prothman's examples don't show the 5.1 driver, but the connection string is the same except for the name of the driver itself.)
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.