View Single Post
  #3 (permalink)  
Old August 6th, 2004, 02:40 AM
Robin1 Robin1 is offline
Authorized User
Join Date: Aug 2004
Location: , , Singapore.
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts

dim conn
set conn=server.createObject("Adodb.connection")
conn.connectionString="(Your DB driver for me:)Driver={Mysql odbc 3.51 Driver}; Server=LocalHost; (other ip address also can)DataBase=(the DB u want to connect to for me:)myTestDB; UID="User name"; (leave it blank as anomynous)PWD="your password"; "
conn.Mode=adModeRead (or sth.else)
conn.OPEN (it is open after this)

many other properties and attributes to think of,but above code sufficient for u to establish a connection.

better to try on ur own Database (mySQL recommanded) and read books!

Reply With Quote