| Author |
 Topic  |
|
|
Panhandler
Average Member
USA
783 Posts |
 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
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
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. |
 |
|
|
Panhandler
Average Member
USA
783 Posts |
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
Advanced Member
Philippines
4207 Posts |
Posted - 25 December 2012 : 23:46:17
|
| Snitz will work with either. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
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. |
Support Snitz Forums
|
|
|
|
Panhandler
Average Member
USA
783 Posts |
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?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Panhandler
Average Member
USA
783 Posts |
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
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
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.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Data source name not found and no default driver s
