Try something similar to this: ConStr = "Provider=MSDASQL;DRIVER=MYSQL ODBC 3.51 DRIVER;SERVER=ABC;DATABASE=MYDATABASE;UID=root"
Gilbert Wu [EMAIL PROTECTED] http://www.sabrefund.com Sabre Fund Management Limited Windsor House 55 St James's Street London SW1A 1LA Tel +44 20 7316 2820 Fax +44 20 7316 0180 Regulated by the FSA NOTICE: This e-mail and any attachment is confidential and may also be privileged. It is intended for the named recipient only. If you have received it in error, please contact the sender immediately by telephoning +44(0)207 316 2800. Any dissemination, distribution, copying or use of this communication without the permission of the sender is prohibited. There are risks in communicating by e-mail. E-mail may be susceptible to data corruption, delay, interception and unauthorised amendment and we do not accept liability for any such corruption, delay, interception or amendment or their consequences. Anyone who communicates with us by e-mail is taken to accept the risks in so doing. Furthermore the contents of an attachment to this e-mail may contain software viruses which could damage your computer system or data. While we have taken reasonable precautions to prevent the inclusion of viruses in e-mails and attachments, neither we nor the sender can accept any liability for any loss or damage sustained as a result of software viruses. You are strongly advised to carry out your own virus checking before opening any attachments. -----Original Message----- From: Matthew Stuart [mailto:[EMAIL PROTECTED] Sent: 05 February 2004 13:50 To: MySQL email support Subject: Need DSN less help 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 Mat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]