The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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
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
Posted
I'd go with the 64-bit installer. If you have issues like Davio did, can always switch.
Posted
Originally posted by CarefreeMy thought was that Snitz was designed as a 32 bit software - thus should go with the 32-bit installer. No?
I'd go with the 64-bit installer. If you have issues like Davio did, can always switch.
Posted
Snitz will work with either.
Posted
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.
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.
Posted
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?
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
No, of course it is not.
Posted
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?
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
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.
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.
Posted
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.