dsnless connection to MySQL db

Results 1 to 2 of 2

Thread: dsnless connection to MySQL db

  1. #1
    Join Date
    Dec 1969

    Default dsnless connection to MySQL db

    I&#039;m currently running my website on an NT server with an access db and use the following dsnless connection with no problems:<BR><BR>set objConn=server.createobject("ADODB.connection")<BR >strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data_<B R>&nbsp;&nbsp;&nbsp;&nbsp;Source="data.mdb;User Id=admin;Password=;"<BR>objConn.Open strConn<BR><BR>I now have the opportunity to play with a Cobalt RAQ4i server running Linux with MySQL installed. I would like to avoid using a dsn, but everytime I try to connect to the db I receive an OBJECT REQUIRED error.<BR><BR>Thanks for any help<BR>bcoomes@sc.rr.com

  2. #2
    Join Date
    Dec 1969

    Default RE: dsnless connection to MySQL db

    Why would we care about your Access connection details when you&#039;re having problems with MySql?<BR><BR>Do you have a provider for MySql? Have you installed ODBC drivers for MySql? <BR><BR>Try creating a connection w/ InterDev, then check out the connection string in global.asa. (you can then get rid of this connection)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts