Database connection without DRW

[Guest]

I have been using FP2000 for quite some years now, using Access2000 as a
backend database.

The database is in a Fpdb folder with a DSN called Database1.

Can you tell me how I can write a manual SQL string to connect to the
database and display fields without using DRW.

THanks,

skc

 

[Jon Spivey]

Hi,

It's usually better to lose the DSN and hit the database directly which you
can do like this
<%
set oConn=createobject("adodb.connection")
oConn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("/fpdb/database.mdb")
%>
If you want to stick with the DSN you can do
<%
set oConn=createobject("adodb.connection")
oConn.open "dsn=Database1"
%>