| T O P I C R E V I E W |
| Panhandler |
Posted - 25 December 2012 : 11:05:44
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
|
| 9 L A T E S T R E P L I E S (Newest First) |
| Doug G |
Posted - 31 December 2012 : 18:51:11
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.
|
| ruirib |
Posted - 30 December 2012 : 13:09:33
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. |
| Panhandler |
Posted - 30 December 2012 : 10:09:02
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?
|
| ruirib |
Posted - 27 December 2012 : 17:42:19
No, of course it is not. |
| Panhandler |
Posted - 27 December 2012 : 10:27:36
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?
|
| Davio |
Posted - 26 December 2012 : 14:30:55
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. |
| Carefree |
Posted - 25 December 2012 : 23:46:17
Snitz will work with either. |
| Panhandler |
Posted - 25 December 2012 : 20:47:41
quote:
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?
|
| Carefree |
Posted - 25 December 2012 : 11:46:49
I'd go with the 64-bit installer. If you have issues like Davio did, can always switch. |
