Hey there,

I'm really rusty with connecting to a database via ASP "classic". I usually do this in PHP.

I'm building a newsletter archive system. I created the table in MS-SQL on a remote server. When a person clicks a certain month, I want the listing of the articles to appear into an asp page.

Because the tables are on a remote server, I believe I have to use a dsn-less connection.

I wrote the original program in PHP. But my job wants to keep their pages in ASP. To connect via PHP here's what I do... (the "real names" have been changed to protect the innocent.)

$server="servername.hostingcompany.com";
$username="our_user_name";
$password="our_password";
$sqlconnect=mssql_connect($server, $username, $password);

$sqldb=mssql_select_db("databasename",$sqlconnect) ;
$sqlquery="SELECT article_field FROM table;";
$results= mssql_query($sqlquery);

I'm comfortable with creating and reading recordsets in ASP, it's just opening the proper connection.

Could anyone please help?

Thanks
Donna

 set Connect = Server.CreateObject("ADODB.Connection")
 Connect_String = "PROVIDER=SQLOLEDB;Data Source=" & Server_Name & ";Initial Catalog=" & Server_DB & ";USER ID=" & DB_User_ID & ";PASSWORD=" & DB_Password;"
 Connect.Open Connect_String

Whereby you'd have to know the values for Server_Name ($server), DB_User_ID ($username), DB_Password ($password) and Server_DB (which isn't listed there, so you need to get that.

Adam,

Thanks. I have the information but it's to my job's server!

Donna

Oops Adam,

I'm getting an error code: Expected end of statement.

Here's what I typed in:

Connect_String = "PROVIDER=SQLOLEDB;Data Source=" & location.remoteserver.com & ";Initial Catalog=" & ourDBname & ";USER ID=" & ourUserName &";PASSWORD="& abc123;"

The little ^ is pointing exactly after the double-quote at the end of the password.

I'm sure I'm missing something.

Thanks
Donna

Adam,

Yep, it was me.

Thanks. I found out my problem... I wasn't calling my last variable correctly.

Thank you, thank you, thank you.

DonnaZ

Not that I really said much after posting the code, but you're welcome.