dsn-less question!

[Terry]

I have website to capture registration information. I have to capture
credit card info and my isp tells me that frontpage extensions won't work on
their secured server. I created a page in dreamweaver to post the data and
am using Forms To Go to create the asp script file to make the post and do
the email cofirmations. My problem is I still want to use frontpage to
query the database. I got a dsn from my isp but they have to put the
database in the root/databases folder. FP can't see this folder. I asked
them to create the dsn to point to root/public/databases but they said they
can't.
They told me I would have to use dsn-less and gave me a link which listed
this script:

Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath &
";"

I'm not sure what to modify in this script so that my asp script can post to
it.

Anybody help?

 

[Stefan B Rusynko]

See response to your other identical post

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have website to capture registration information. I have to capture
| credit card info and my isp tells me that frontpage extensions won't work on
| their secured server. I created a page in dreamweaver to post the data and
| am using Forms To Go to create the asp script file to make the post and do
| the email cofirmations. My problem is I still want to use frontpage to
| query the database. I got a dsn from my isp but they have to put the
| database in the root/databases folder. FP can't see this folder. I asked
| them to create the dsn to point to root/public/databases but they said they
| can't.
| They told me I would have to use dsn-less and gave me a link which listed
| this script:
|
| Set MyConn = Server.CreateObject("ADODB.Connection")
| MdbFilePath = Server.MapPath("sample.mdb")
| MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath &
| ";"
|
| I'm not sure what to modify in this script so that my asp script can post to
| it.
|
| Anybody help?
|
|
|
|