Is the MyODBC driver installed on the Webserver? Without it, you will still encounter this error message.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 9:05:51 AM, Gilbert Wu <[EMAIL PROTECTED]> wrote regarding RE: Need DSN less help: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]