I have just spent 24 hours trying to get my SNITZ working on my new server.
I am using MySQL 5.1.33 I am using Windows Server 2003 R2 64 Bit I have the 3.51 64bit ODBC Driver I have a USER DSN that works (Connection test OK) I have a SYSTEM DSN that workd (Connection test OK)
The DSN name is called MySNITZ,
strDBType is "mysql"
strConnString = "MySNITZ" '## DSN Does not work.
strConnString = "driver={MySQL ODBC 3.51 Driver};server=localhost;user=*****;password=*****;DATABASE=snitzdb;" '##MySQL w/ MyODBC v3.51 (I have removed the username and password for this post) Does not work.
Error is
The database could not be opened !! Check your config.asp file and set the strConnString so it points to the database. Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
How can I get my SNITZ up and running on this platform?
Is your mysql server running? For starters connect from the mysql command line and make sure you can connect with the credentials you're using in your code. The windows ODBC manager for mysql includes ping and testing functions, make sure the DSN is working. Then if it still doesn't work you can start reviewing code.
Topic Locked
Posted - 06 April 2009 : 11:35:15
