Ok, ive just finished my site, and ive managed to make a database connection and get it to work on my desktop server. Its time to upload the site to my domain... what the hell do i do with the database? and do i have to modify the connection now its on a real server? Thanks in advance.

Firstly, what is your database? Access, SQL Serverr, MySQL - give us a clue. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

its MS Access 97

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
its MS Access 97
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

More info please, can your ISP make you a DSN on the server ?
Have you thought about talking to your ISP about folder permissions ?
example, if your Dbase is in folder root/data and someone could browse the folder...then he/she can also download your entire dbase / website, which we don't want.

If the ISP can setup a DSN for you then use that in your connection files and just up them, if not then you need to find the exact path to your Dbase, by uploading and running a empty page with only one ASP code in it... Server.MapPath The returned adress is the path to your uploaded page, if it returns for example D:\webs\creepingdeath\ then you know your site is hosted on the server's D drive, in the folder webs where the user accounts are stored... this would make the path to use in the connection file something like D:\webs\creepingdeath\dbase\yourdbase.mdb

or you can follow this technote: www.macromedia.com/support/ultradev/ts/documents/mappath_in_connection_strin.htm

Have fun...
So let it be written...So let it be done...I'm sent here by the chosen one...
I'm Creeping Death.
Cliff 'm all before they Cliff you !

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services

Bedankt!! (thanx), I have the same problem too <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> well, actually :... (

Upload the database to the to the webspace. Some hosts specify that it should go in a particular directory so check with them about the specifics.

Don't bother with DSN's use an OLE DB connection string, it's just as easy to set up, provides a faster connection to the database and doesn't require the host to do anything or mucking about in contol panels. See tutorial link below with a whole section on setting up an OLE DB connection string.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

erm yeah. ive followed some advice but i still cant get it to work. Im prolly more of a novice compared to you guys. Can i just upload the database into my main folder (where all the rest of my pages are)? Hmmm. all these tutorials ive seen just tell me how to get it working all on my PC whichive already done. There arent any tutorials on how to actually get it working in the real world on proper servers. poo.

Don't bother with DSN's use an OLE DB connection string, it's just as easy to set up, provides a faster connection to the database and doesn't require the host to do anything or mucking about in contol panels. See tutorial link below with a whole section on setting up an OLE DB connection string.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Use your FTP program to set up a Directory (folder) in your webspace and call it "database". Upload the *.mdb file into this. The connection string path will be what you see in the remote folder path information of your FTP program, something like:

d:/html/users/yourdomain.com/database/YourDatabase.mdb

(leave off the preceding / eg. /d:/html....)

However your host may specify where you need to put the database, so you will need to check with them, they shoud also be able to give you the required path info.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

if it still doesn't work then look here:
www.macromedia.com/support/ultradev/database/connecting_to_isp/

or browse through these sections:
search.atomz.com/search/?sp-m=1&sp-a=sp1001395b&sp-q=deploy+isp&sp-k=Dreamweaver+UltraDev+Support&sp-k=Dreamweaver+Support&sp-k=General+Support&z3=&z4=&z5=&z6=&z7=&z8=&z9=&z10=&z11=&z12=&z13=&z14=&z15=&z16=&z17=&z18=&z19=&sp-p=any

If those two don't help browse here:
www.macromedia.com/support/ultradev/technotes.html
I recommend browsing here anyway, alot of usefull info there <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services