The connection string of ASP connection database is provider=microsoft.jet.oledb.4.0; The Data source= path, which uses OLE DB connectivity, may be a problem in OLE DB connectivity.
Later, the search network was resolved. The reason for your own 64-bit Windows 7 system is that, in the default 64-bit environment, the IIS application pool does not have 32-bit applications enabled, we just need to enable it. Open IIS 7, navigate to Application pools, and then select a program pool to connect to the database using OLE DB, and then set the 32-bit application to true.
Using myodbc with asp.net in IIS7 on Vista x64
That ' s a heck of a title, but it's a problem I hit recently. I have a bunch of asp.net sites that use MySQL as their datastore, but I hadn ' t tried the "on IIS7 yet." It took a while to get them to work in all (I had to set permissions on Web.config and the other website files Y could be read by both the Users group and the IIS_IUSRS group), but then I am left with a error about my MySQL connect Ion. "ERROR [IM002] [Microsoft][odbc Driver Manager] Data source name not found and no default Driver specified" –another very General error This basically means "something is wrong with your ODBC driver, somewhere."
After some searching, I learned two things. The ' is ' if ' re running 64-bit can ' t use the standard ODBC Data Source Administrator in Administrative Too LS with MySQL. You ' ve got to go to C:\Windows\SysWOW64\odbcad32.exe and set up your DSN, if that ' s your thing. The other thing are that the MYODBC driver are 32-bit only. So to use it in all, you need to make sure you ' re calling it from 32-bit apps only. That means your ' ve got to tweak the application Pool you ' re using to run all its asp.net applications as 32-bit. To doing this, go to Administrative Tools > Internet information Services (IIS) Manager (or just hit the Windows key and T Ype "IIS"). Then go to "Application Pools" and select whichever application pool your ASP.net the app uses (or create a new one just for Y Our MySQL apps. Click "Advanced Settings ..." and set "Enable 32-bit applications". Now the AppPool would use the 32-bit. NET CLR to run your app, and it'll be able to and the Your MYODBC (driver A DSN orNot).
