hi
im a totally new user of asp 3.0 and i have the problem in connecting the data base with asp. could anybody help me for solving the problem. i studied the book but could not fully understand the concept. could u plz show me some example code.
thanking in anticipation

shoaib

hi

  follow this link

http://www.aspfaqs.com/aspfaqs

there you find all the information with ASP, Database and errors...

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!
cheers

Hi Shoaib,

Any connection to database should have the following structure.

Connection object.
Open Connection (with help of connection string) Connection strings
Recordset Object (if results are to be processed)
Open recordset with help of SQL statement and Connection Object.
Check if recordset in not empty.
Then Loop through the Recordset
   Display/Process records.
   Move to Next Record.
End of LOOP
Close Recordset
Close connection
set Recordset and connection objects to nothing.

Connecting to a Database

Or google with this link - Connecting to database

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection