Win7 ASP Connection Database "The provider was not found." This program may not be installed properly "problem _win server

Source: Internet
Author: User
Tags driver manager dsn odbc mysql connect ole
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).

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.