Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Help Please: MySQL Connection problem
 New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

watchinthegame
Starting Member

Australia
2 Posts

Posted - 21 June 2016 :  15:42:19  Show Profile  Reply with Quote
Hi,
Problems just running Snitz locally (localhost)
The error message doesn't make sense as the database exists..
in the config.asp file I opened the database and read the records from a table successfully in the lines following the creation of the connection String. But using the same connector at the pre coded spot in config.asp Fails... weirdness

Using this connection string:
driver={MySQL ODBC 5.1 Driver};option=16387;server=localhost;user=root;password=xxx;DATABASE=rfh_db_dev;

I get this error:
There has been an error !!

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

Click here to retry.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 June 2016 :  19:04:57  Show Profile  Send ruirib a Yahoo! Message
And you were able to read using the same connection string, from an ASP app? Have you changed config.asp?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 22 June 2016 :  01:49:17  Show Profile
It's not clear if your setup ever worked, or if this is a new implementation or copy from another server. Some things to check:
is the mysql odbc driver installed on your server?
Does the installed ODBC driver version match your connection string? The current version of the driver is 5.3

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20580 Posts

Posted - 22 June 2016 :  04:19:14  Show Profile  Visit HuwR's Homepage
could you perhaps show us the relevant lines from your config.asp file so we can check it is correct
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07