Provider is not specified.

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/70279?pagenum=1
04 November 2025, 18:36

Topic

Shaggy
Provider is not specified.
29 August 2012, 10:29


I'm in the midst of one of my most hated of tasks; seting up a new computer with all the settings, etc. I need and IIS is throwing an error I've never sen before: Provider is not specified and there is no designated default provider.
Does anybody know what this means and, more importantly, how to fix it? Google has been naff all help, just giving me a load of computer jargon that's way over my head. I have my laptop here as well and, as best I can tell, everything related to the MySQL driver is the same on both machines.

 

Replies ...

ruirib
29 August 2012, 10:40


What connection string are you using? Have you installed and downloaded providers for MySQL?
Shaggy
29 August 2012, 10:43


Yep. Like I said, as far as I can see, the drivers are set up the same on both my laptop (where all is well) and the new machine. The only difference is the laptop is using driver version 5.1.6 and the other machine is using version 5.1.11.
ruirib
29 August 2012, 10:48


What OS version are you using? Davio had issues using 64 bit drivers in a 64 bit OS, so he had to resort to 32 bit drivers.
See if this helps:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=70074&whichpage=1
Shaggy
29 August 2012, 10:49


It's Vista.
ruirib
29 August 2012, 10:50


You need to better than that, Shaggy smile. 32 or 64 bits?
Shaggy
29 August 2012, 10:54


I don't know what that means! dissapprove Remember: my knowledge of computers is zero wink
I had a look at Davio's topic and I'm lost on the first step he tried to fix it!
ruirib
29 August 2012, 10:56


Yes, of course smile.
Shaggy
29 August 2012, 10:59


Is there anyway I can find out whether its 32 or 64 bits?
Edit: Got it (I think)! 64 bit operating system.
ruirib
29 August 2012, 11:01


Try Control Panel -> System.
Shaggy
29 August 2012, 11:02


Got it just before you posted thanks to Google. It's a 64 bit operating system. My laptop is 32 bit.
Is that the difference? How would that effect the MySQL driver?
ruirib
29 August 2012, 11:04


Did you install 32 bit or 64 bit drivers?
Shaggy
29 August 2012, 11:08


Given my ignorance of the different types of OS (I still don't know what the difference between the two is), I uninstalled what I'd previously installed and ran mysql-connector-odbc-5.1.11-winx64.msi to be sure I had the right one. I'm still getting the same error, though.
ruirib
29 August 2012, 11:11


Those were the drivers Davio had issues with. I suggest you remove them and install the 32 bit drivers instead. Those are (...)-win32.msi ones and see if it solves your problem.
Shaggy
29 August 2012, 11:26


OK, that's done. No change.
ruirib
29 August 2012, 11:40


You probably need to configure your app pool to support 32 bit applications. You will need to do that in IIS Manager. Select the web site, choose Basic Settings, identify the app pool. Then click in Application Pools, right click the one you want, choose Advanced Settings and set Enable 32 bit applications to True.
Shaggy
29 August 2012, 11:43


Huzzah! bigsmile That did the job. Many thanks, Rui smile
ruirib
29 August 2012, 11:49


Great, you're welcome smile.
Davio
29 August 2012, 12:13


Now go research what the difference is between a 32bit and 64bit OS. (and don't say 32. lol) tongue
Carefree
29 August 2012, 17:06


It's not the number of drills in a computer toolkit, either.
© 2000-2021 Snitz™ Communications