database connectivity

Results 1 to 3 of 3

Thread: database connectivity

  1. #1
    Join Date
    Dec 1969

    Default database connectivity

    Dear Friends,<BR>I have a problem with the database connectivity from ASP to MySQL. Does any one knows how to open the connection object with MySQL database.<BR><BR>Please reply asap.<BR><BR>Achin Kalra<BR>

  2. #2
    Join Date
    Dec 1969

    Default one post would have been sufficient

    myODBC is what you&#039;re looking for, available from the mySQL site.<BR><BR>j

  3. #3
    Join Date
    Dec 1969

    Default RE: database connectivity

    Use Following change database name .<BR>set con = server.createobject("ADODB.CONNECTION")<BR> set rs = server.createobject("ADODB.RECORDSET")<BR> with con<BR> .Provider = "SQLOLEDB"<BR> .connectionstring = "User ID=sa;Password=; Data Source=server; initial catalog=databaseName" <BR> .open<BR> end with<BR>sql="Select * from tablename "<BR> (sql),con

Posting Permissions

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