HELP!

[NE0]

I'm trying to connect to a remote (Access) Database via ASP and I've got tons of examples but I cant seem to make them work. What I have is a Coldfusion server which will post to a ASP page and the ASP page will do an DNS-LESS connection to the remote database and upload three fixed veriables based on the one veriable that was sent from the CF page.

I've got the CF to ASP working and updating to a local database but I really need to get to the remote database.

if you can help or just let me know that its not possable I would love to hear from you..

Thanks
Ernie Pena

 

[link9]

if you have it working locally, then all you should have to do is change the ip address and possibly the username and password, depending on whether or not they are the same on the remote box --

 

[NE0]

here is the connection string that is working for me;

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("pain.mdb&quot & ";"

but the problem is that its to the local host but I need to be able to access this same database on the remote server.

the string is a DSN-LESS connection string but their is no place for a user name password or evern an ip address to the server I'm tring yo connect to.