ASP database connection

xiaoxiao2021-03-06  67

ASP database connection

<%

Set conn = server.createObject ("adoDb.connection")

Conn.open "provider = sqloledb; network library = dbmssocn; data source = 127.0.0.1; initial catalog = testdb; user ID = sa; password =;"

'Conn.open "Data Provider = msdasql.1; driver = SQL Server; Server = localhost; UID = SA; PWD =; Database = TestDB"

'Conn.open "provider = SQLOLEDB.1; PERSIST security info = false; user ID = sa; initial catalog = testdb; server = TEMP;"

IF Err.Number <> 0 or err THEN

Err.clear

Response.write Err.Description

Response.end

%>