Searching an ODBC Database in ASP WEB

[Anon]

Hi,

I am enquiring on how you can searchin an ODBC database which I created using Access 2000 through the Internet using ASP or PHP. Does any one know - or does anyone know of a site which is GOOD help on it?

Ta.

[mithril]

Jared,

There's a great introductory tutorial on searching MS Access db's using PHP on this site. The link is:

http://phpbuilder.com/columns/siddarth20000228.php3

With ASP, can't help you. However, I doubt it matters..... once you've experienced PHP's capabilities, I doubt you'll have any great desire to use ASP anymore. It is after all part of the Dark Side of The Source🙂 HTH,

Cheers,

Geoff A. Virgo

[marwan]

although your question lacks precision,
I think u\'re inquiring on how to connect
and get data from an access DB.
for it, you\'re going to use ActiveX Data Objects (ADO) wich is included in all IIS 3+ versions, and the VBScript code is the following:

1- create a db connection object
cet conn = server.createObject(\"adodb.connection\")

2- open the connection
conn.open(\"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=your .mdb file path\"

3- get data from a table
//create a recordset object
set rs = server.createObject(\"adodb.recdset\")

// execute a SELECT sql statement

sql = \"SELECT * FROM someTable\"
rs.open sql, conn

// reading returned data
response.write(rs(\"field1\"))
response.write(rs(\"field2\"))
...

4- don\'t forget to destroy your server objects

conn.close
set conn = nothing
rs.close
set rs = nothing