Database connection without DRW

S

Skc

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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top