I have created a dsn-less connection to my database with this string


Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\Inetpub\wwwroot\sitefolder\databasename.mdb;Persist Security Info=False

Now, if I select "use driver on this machine" it works fine but if i select "use driver on application server" (which i presume i would need to do for a remote server) it doesn't work, it gives me an error saying the path is invalid (which it isn't).

Any ideas??

p.s IIS is running on another machine which I am connected to via a local network.

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

I might be wrong but you can set up on your machine using the local.

When you publish live to the server for others to access, you would change the connection file to reflect where the site is located on that server...

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

thanks vince

so there is never any need to select "use driver on application server" because when you upload your files they are on "this" machine anyway????

while on the subject what would people recommend the JET drivers or the ODBC drivers?


Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

HI

Isn't this dsn dsn-less thing annoying!!

Finally got the dsn-less connection setup with the JET drivers, all connections test ok but when I open a page in my browser I am getting BOF EOF errors that I was not getting using the DSN.

So changed drivers from JET using this connection string

"Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\databasefolder\database.mdb"

Now everything seems to be working as it was before with DSN.

So what's the deal with JET Vs Access Drivers??

Which is better??

Why the BOF, EOF with JET and not with Access???

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

I always get the same problems with the Jet drivers Dave.

Stuck to using the ODBC drivers for now until I learn something better. They work, thats enough for me. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards,
Dave

UD4 | Flash 5 | SQL | Access | ASP/VBScript | XP-Pro

cheers Dave

will do the same<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome