I can't seem to get it to work at all. I'm using asp and I'm just trying to connect to a MS SQL via IP address. (Not sure if the database is located in a different location). But thats besides the point. My current string is: ConnectionString="Data Source=205.178.###.###,####;Network Library=DBMSSOCN;Initial Catalog=XXXX;User ID=XXXX;Password=XXXX;"

I'm just wanting asp to write a slected table. Is there a place I could get this information?

--- EDIT ----
<%
Dim oConn, oRs, oRsT
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server

db_server = "SOMETHING/SOMETHING"
db_name = "DATABASE_NAME"
db_username = "USERNAMEFORDATABASE"
db_userpassword = "PASSWORDFORDATABASE"

connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr
%>


Thanks Networksolutions, thumbs up on your phone support. (IMG:http://forums.networksolutions.com/style_emoticons/default/smile.gif)

Visit: http://www.connectionstrings.com/

*Bump* Resolution.