Data source name not found and no default driver s - Posted (2863 Views)
Panhandler
Average Member
Panhandler
Posts: 783
783
Not to hijack this thread: http://forum.snitz.com/Forum/topic.asp?TOPIC_ID=70074&whichpage=1

Snitz Forum Setup is giving this dreaded error:
[ODBC Driver Manager] Data source name not found and no default driver specified
System is Win 7 Pro 64 bit
I have been using mysql on localhost under xampp
I've created an empty database called "snitz"
I've turned off Apache and left mysql running
I've started SQL Server (SQLEXPRESS) and its running. Classic ASP is started and running. Setup.asp is producing the data source error.
I have NOT installed any ODBC connector yet.
Which installer would you recommend? Windows (x86, 32-bit), MSI Installer Connector-ODBC or the
Windows (x86, 64-bit), MSI Installer Connector-ODBC


 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Carefree
Advanced Member
Carefree
Posts: 4224
4224
I'd go with the 64-bit installer. If you have issues like Davio did, can always switch.
Posted
Panhandler
Average Member
Panhandler
Posts: 783
783
Originally posted by Carefree
I'd go with the 64-bit installer. If you have issues like Davio did, can always switch.
My thought was that Snitz was designed as a 32 bit software - thus should go with the 32-bit installer. No?
Posted
Carefree
Advanced Member
Carefree
Posts: 4224
4224
Snitz will work with either.
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
My problem was, that the IIS application was running as a 32bit app. And I was using 64bit mysql odbc drivers. There was a setting to turn off running IIS as a 32bit app, and once it started running as a 64bit app, it could access the 64bit mysql odbc drivers.
Running each site as a 32 bit or 64 bit app, is server dependent that you can change, and not anything what Snitz was designed for.
Support Snitz Forums
Posted
Panhandler
Average Member
Panhandler
Posts: 783
783
Well I have a related question. MySql is running. The Admin for MySql is through Apache. But I haven't been running Apache and IIS 7.5 simultaneously.
I leave MySql running and turn Apache off. Then start IIS 7.5

Is it necessary to run Apache with MySql in order to connect Snitz with the MySql database?
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
No, of course it is not.
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Panhandler
Average Member
Panhandler
Posts: 783
783
Well I've NOT been running MySql with IIS 7.5
Nor is IIS configured to run phpMyadmin
phpMyadmin runs under Apache on my localhost

I'm looking in that direction for this problem. Am I on the right track?
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
What problem? MySQL is totally independent of IIS and phpMyAdmin.
Get a graphical tool to administer MySQL. There are some that are free: http://www.databasejournal.com/features/mysql/article.php/3880961/Top-10-MySQL-GUI-Tools.htm

If the problem you are talking about is the driver issue, phpMyAdmin won't solve it.
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Doug G
Support Moderator
Doug G
Posts: 6493
6493
You can use phpmyadmin to administer a mysql database from any web server that can connect to the db. You may have to tweak the phpmyadmin configuration file though. I've used phpmyadmin running on a in-house linux apache web server to work on my hosted mysql database at my hosting company where mysql was running under windows on their servers. None of which has anything to do with Snitz, by the way.
======
Doug G
======
Computer history and help at www.dougscode.com
 
You Must enter a message