0

Hello, im a rookie
i would like to connect to a MSSQL2000 server
Retreive information
post it on the website
then detele it on a condition
please help i have compiled this so far.

<%
'* database server parameters
Dim serverIP '* ip adress
Dim serverPORT '* ip port
Dim serverDB '* catalog/database name
Dim serverLOGIN '* username
Dim serverPASSWORD '* password

'* set your variables here
serverIP = "192.168.100.1"
serverPORT = "1433" '* default port is 1433/TCP
serverDB = "Northwind"
serverLOGIN = "login"
serverPASSWORD = "pass"

'* open connection
Dim con
Set con = Server.CreateObject("ADODB.Connection")
con.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=" & serverIP & "," & serverPORT & ";" & _
"Initial Catalog=" & serverDB & ";" & _
"User ID=" & serverLOGIN & ";" & _
"Password=" & serverPASSWORD & ";" & _
"Connect Timeout=5;Pooling=False"
Call con.Open()
%>
2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by Drew
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.