connecting to remote MS SQL database

[sfrasier]

Hello,

i must access a remote MS SQL DB for a major project. All I have is this:

set conn1 = Server.CreateObject("ADODB Connection
conn1.Open "DSN=dsn_name;UID=uid;PWD=pwd;"

and the IP address.

How do i access this with CF without CF Administrator - just with straight code?

How do I make a test copy of it to use until product is ready for delivery?

THANKS!!!!!