ODBC connection in new version mysql - Posted (7441 Views)
Junior Member
sikandar
Posts: 135
135
hi all,
I have a challenge that on windows 2003 there was no challenge but now I am trying same setup on 2008 but getting error as now even mysql version is changed from 3.2 to 5 so kindly let me know what will be new connection method or string as getting following error,

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/forums/inc_header.asp, line 121

Thanks in advance.
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Starting Member
robbieh
Posts: 4
4
I'm having similar issues. If I try DSN, I get the following:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

If I try the 'strConnString = "driver={MySQL ODBC 3.51 Driver I get this
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

If I try 'strConnString = “driver={MySQL ODBC 5.1 Driver} I get an IIS 500 error.
I've tried changing the application pool to 32 bit, no luck. I've tried both ODBC drivers as well.
I'm giving up trying to get the Access database working on Windows Server 2008 R2 and want to get MySQL working.
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
Are you using a classic app pool?
You Must enter a message