Database connection without DRW

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
%>
 
Back
Top