I've managed to solve my earlier problem of connecting to a database using a connection string, but now I want to do it using a DSN (my web hosting service insists on DSNs).

This is the code:

Set objHCDynamicConn = Server.CreateObject("ADODB.Connection") 'line 15
objHCDynamicConn.Open "DSN=DB1","","password"

and this is the error:

Error Type:
Server object, ASP 0177 (0x800700C1)
800700c1
/uigpresql/development/dbtest.asp, line 15

I have checked the DSN setup and it is OK.

My setup is:
Win 2000 Pro
IIS 5
Frontpage 2002
Latest Jet Service Pack installed
MDAC 2.5 or 2.6 - not sure

I'm going nuts over this - it all worked absolutely fine under Win 98!

Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk

__________________
-------------------
System 3 2000 Limited
www.system3-2000.co.uk (but very out-of-date!)

You have not mentioned which database you are using. I am assuming SQL server.

It has to be like this.

objHCDynamicConn.Open "DSN=DB1;UID=<username>;PWD=<password>;DATABASE=<d bname>"

Thank you for your reply.

It's actually Access at the moment but I shall keep the SQL details you posted because one of the main reasons for installing Win 2000 Pro is because I have to migrate the database to SQL Server.

Do you have the correct syntax for Access please?

Thank you
Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk

For access, it is similar.

objHCDynamicConn.Open "DSN=DB1;UID=<username>;PWD=<password>"

If username and password are not set, you can simply use

objHCDynamicConn.Open "DSN=DB1"

Thank you for your help, I really am grateful.

I seem to have got everything working OK now.

Pat



-------------------
System 3 2000 Limited
www.system3-2000.co.uk