cannot put adojavas.inc/What's Up With This!! 1

[mindeye]

Hello,

While trying to connect to a database I keep getting the error "cannot put adojavas.inc"...I am new to this and I guess I am doomed to run into every obstacle out there. Any help would be appreciated. I get this error when I am trying to put in a DSN name and I lock up when I try to connect with a connection string. I don't understand connection strings that well but this is what I am using...strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & " c:\Inepub\

http://wwwroot\_data\secure.mdb"

Any help would be most appreciated.

Thanks,
Roger

 

[schase]

One thing at a time.

is this hosting off of your computer or a web host?

at anyrate, in place of
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & " c:\Inepub\

http://wwwroot\_data\secure.mdb"

put

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../_data/secure.mdb&quot

the ../ backs you out a directory each time. do if your files are in a folder called html or htdocs, you'd back out one then go into the _data.

Most webhosts have something like this for a setup

yourdomain
yourdomain/html (or htdocs)
yourdomain/logs
yourdomain/private

inside the html folder is where all your files go. Most databases go into one called private - or database. It's for added security.

Take out the line referencing the adovbs.inc.

get the connection working - then we'll put the adovbs back in. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[mindeye]

I was trying to do something crazy. My remote site and local site were one in the same. Once I created a local site which was different the problem went away. Thanks for your help on the Conn String. I save that advice to my hardrive. You are the most helpful person I've ever delt w/, thanks a million.

Regards,
Roger

 

[schase]

glad to help. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart