how should i write my connection?
in my IIS (local) im using DSN, but its not work on the internet (im
uploading my site to some free asp hosting).
in IIS i use
rs.open sql, "DSN=dsnName"


andra.

Hi Andra

Have you asked your new hosts to create a DSN for you?  You might want to
have a look into using a DSNless connection:
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm

Cheers
Darrell

-----Original Message-----
From: Samsul Arifin [mailto:samsul@i...]
Sent: 19 August 2002 09:32
To: Access ASP
Subject: [access_asp] how should i write my connection


how should i write my connection?
in my IIS (local) im using DSN, but its not work on the internet (im
uploading my site to some free asp hosting).
in IIS i use
rs.open sql, "DSN=dsnName"


andra.

provided you are using a Microsoft Access database:

set connectionname = server.createobject("adodb.connection")
connectionname.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
&server.mappath("database.mdb")



-----Original Message-----
From: Samsul Arifin [mailto:samsul@i...]
Sent: Monday, August 19, 2002 3:32 AM
To: Access ASP
Subject: [access_asp] how should i write my connection


how should i write my connection?
in my IIS (local) im using DSN, but its not work on the internet (im
uploading my site to some free asp hosting).
in IIS i use
rs.open sql, "DSN=dsnName"


andra.




---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002