<%
dim Conn
dim Connstr
set conn = server.createobject("adodb.connection")
'-----------------SQL SERVER 7.0数据库ADO连接------------
'connstr="Driver={SQL Server};Server=(local);UID=cwecn;PWD=cwecn2002;Database=ndata"
'-----------------SQL SERVER 7.0数据库OLE连接------------
connstr="Provider=SQLOLEDB.1;User ID=cwecn;Initial Catalog=ndata;Data Source=(local);password=cwecn2002"
Public Sub DataCon(DbName As String)
Dim MSdatabase As String
Set Con = New ADODB.Connection
On Error GoTo OpenErr
MSdatabase = App.Path & "\" & DbName
Con.CursorLocation = adUseClient
Con.Provider = "Microsoft.Jet.OLEDB.4.0"
Con.Open MSdatabase
Exit Sub
OpenErr:
MsgBox "Error Opening " & MSdatabase & vbNewLine & Err.Description, vbCritical, "Open Database Error"
Unload Form1
End Sub