PDA

View Full Version : Uploading to web server problems: database connect


pradouk
09-26-2005, 12:20 AM
Hi guys,
Iím very new to connecting websites to a database, in fact this is my first time and im having trouble already.

Iím using dreamweaver MX coding in ASP connecting to an Access database. Initially Iíve built and run the site on my windows XP machine, it uses an DSN connection:

Dim MM_conwincoolthings_STRING
MM_conwincoolthings_STRING = "dsn=wincoolthings;"

It runs like a dream on my PC but now that I want to upload it to my webspace Iím having all sorts of problems. I really donít know how to amend the pages so they work on my webspaceÖ

I think my webspace host wants me to use a DSN less connection as they sent me the physical address:

c:/home/socksymf/html/db.mdb

how do I change switch from DSN to DSN less in dreamweaver and is it a big job?
Can anyone give me some pointers as its all getting a little confusing.


Many thanks

davidj
09-28-2005, 01:31 PM
Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:/home/socksymf/html/db.mdb