Re: Need DSN less help - Matthew Stuart - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Need DSN less help

From	Sent On	Attachments
Matthew Stuart	05 Feb 2004 05:50
Gilbert Wu	05 Feb 2004 07:05
Matthew Stuart	05 Feb 2004 07:07
vpen...@hoovers.com	05 Feb 2004 07:23

Subject:	Re: Need DSN less help
From:	Matthew Stuart (mr...@btinternet.com)
Date:	02/05/2004 07:07:14 AM
List:	com.mysql.lists.mysql

The ISP do have the driver installed and they also know what they are talking about. The problem is they won't talk to me because I am not the reseller (ie their customer). The reseller I have used knows nothing about MySQL - he knows everything else but MySQL.

Mat

On Thursday, February 5, 2004, at 02:34 PM, ghun...@comcast.net wrote:

Matt,

Are you sure that they have the MySQL driver installed on their webserver? Since you say that they have no experience with MySQL, they probably do not, and that would be your problem.

Regards,

Gary H.

I am having problems with making a connection between my website and the MySQL db on a different server. I have tried both hand coding and using the MyOLEDB application for MySQL. What am I doing wrong? If you think this looks a little strange, it is because it is a dreamweaver connection file.

This is an error that I get when I try to browser the site: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /csi/index.asp, line 8

This is the code on index.asp, line 8: Recordset.ActiveConnection = MM_connection_STRING

and here is the code from the connection file: <% ' FileName="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" Dim MM_connection_STRING MM_connection_STRING = "Driver={ mySQL };" & _ " Server =servername.com;" & _ " Port =3306;" & _ " Option =131072;" & _ "Stmt=;" & _

"Database=databasename_db;" & _ "Uid=database_user;" & _ "Pwd=database_pass" %>

Can somebody please tell me what is wrong with this? My ISP is a reseller who has no experience of MySQL and because he is the customer (not me) they will only talk to him. Besides that they are quite useless when it comes to dreamweaver.

Thanks