Uploading Access Database and ASP Pages

[dinahdoey]

Hi,

I'm hoping someone can help me edit my connections to asp pages to connect to my database so that it will work when it's uploaded. At the moment it all works fine on my local server but as I'm new to all of this, I've no idea how to link my uploaded database to my uploaded asp files using the dsn on my webhost (they don't provide scripting advice and I've tried a few changes but can't find anything that will work!) I'm also starting to froth at the mouth...!

I've jotted down a few of the codes that are currently contained in my webpages which I believe might be the ones that need editing to make it all work online:

My current connection is called remotebook.asp and contains the code

Code: Select all

Dim MM_remotebook_STRING
MM_remotebook_STRING = "dsn=booklist"

(My database is called booklist.mdb

My web asp pages contain the code:

Code: Select all

<!--#include file"../../Connections/remotebook.asp"

and also

Code: Select all

Set rsanatomy = Server.CreateObject("ADODB.Recordset")
rsanatomy.ActiveConnection=MM_remotebook_String

The current location of the file dsn on the web host server is d:\users\accoladebouk\database.dsn

and finally :razz: my uploaded database is located at

d:\users\accoladebouk\public_html\Database\booklis t.mdb

I've tried so many different combinations of code - the ones that have been suggested to me usually end up with an error message not liking the ../../Connections/remotebook.asp - but if I take out the ../../it says it cannot find "Connections/remotebook.asp. I've also noticed that this seems to upset the recordset behaviour and throws back an error message to do with the MM-String business!!

Please can somebody help me to sort out this publishing problem - I just tried and had to set up my connections all over again!! AGGGGGGHHHHHHHHHHHHHHHHHHHHHHHH!!!

Many thanks!

[Smokie]

Code: Select all

MM_remotebook_STRING = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=d:/users/accoladebouk/public_html/Database/booklist.mdb"

[Rob]

the above connection string should work!

[dinahdoey]

Cheers guys - once I'd applied the code and changed the <!--#include file code to a virtual one without the ../../ the code you suggested works! Brilliant - I think you're superheros!!

[benbacardi]

after a while of being a member of this forum, you start to release that the guys here are superheros in their own little ways!