DSN on the server

[Namo]

(* sorry about my english , i am from Israel)
Hi
when i make a site on my comp that access a DB , it is easy , i can create DSN...
but if i wanna upload my site to a real host on the net.. how can i connect my DB? how can i make a DSN on the server computer? or how can i know what connection string to use?

Thanks
Namo.

[Clunietp]

shalom

you can probably put the DSN in the same directory as your ASP page and call it with your connection string...

I would use a DSN-less connection string and place the database and the page in the same dir (or a path that you can access relative to your page)

DSN-less connection string example, assuming you are using a MS Access DB with ADO:

objConnection.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=MyDB.mdb"

that's it!

lehitraot :)

[Namo]

Toda :)

[Clunietp]

bevakasha