I'm trying to get a "web application" to interface with our sql database
across the network. I get a login error when click "check"
Here is my code. I have talked to the database guy and he says that the
username, password, and server are correct. My question is are the
containters "username" "password" set somewhere or are they specific for the
asp syntax and if so am I using them right. A website I was looking at used
UID= and PWD= so I'm a little confused. If I'm being horrendously confusing
let me know and I'll try and reword the question.
<%
set conn = Server.CreateObject("ADODB.Connection")strConn="Provider=SQLOLEDB;username=MYUSERNAME;passwd=MYPASSWORD;server=xxx. xxx.xxx.xxx;database=MYDATABASE" conn.ConnectionTimeout = 15 conn.CommandTimeout = 10 conn.ConnectionString = strConn conn.Open if conn.errors.count = 0 then response.write "Connected OK" end if conn.Close %> Thanks Chris Hohimer Sandia National Laboratories CSU821 ORG9623 --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
