construction — Tue, 27 Jun 2006 12:16:10 +0000

Hello.....

U can refer to http://www.w3schools.com/ site, the ADO section.
I hope this would be of help to u for database connection.

---------------------------------------------------------------------------------------------
SBalan Group
http://www.sbalanprojects.com/

Neutron2k — Thu, 08 Jun 2006 11:58:09 +0000

Connecting to an access database on a remote server can prove difficult at the best of times. There are a number of security measures built into IIS that prevent things like flatfile database being used across servers in an attempt to stop hackers.

I'm not actually sure if its even possible to access an ms access database across servers without using an ODBC connection. a DNS-less connection def. won't do it - altough I can't say for sure as i've never tried. Just a gut feeling.

adjroth — Tue, 06 Jun 2006 06:07:08 +0000

here's something to get you started with database connections with ASP. i wrote this in about a minute, so it may have an error or 2. you can find database related code at http://www.aspin.com/

DIM OCONN, FILEPATH, rsProducts

Const adOpenStatic = 3

SET OCONN = Server.CreateObject("ADODB.Connection")
SET rsProducts = Server.CreateObject("ADODB.RecordSet")

filePath = "db/products.mdb"
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(filePath)' & ";Jet OLEDB:Database Password="

rsProducts.open "SELECT * From products ORDER BY PRICE ASC",OCONN,adOpenStatic

rsProducts.movefirst

for i = 1 to 10
if rsProducts.eof then exit for

rsProducts.Fields("DESCRIPTION") 'Access field data
rsProducts.movenext
next

rsProducts.close
OCONN=nothing