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

--
Cheers,
Jon
Microsoft MVP


"Skc" <(E-Mail Removed)> wrote in message
news:7A14C63F-8213-40CF-8BDA-(E-Mail Removed)...
>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