|
Eccola (č la prima) ma ne ho provate anche altre (te le metto commentate). Sto impazzendo...
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={SQL Server};Server=DAMAR3-OXXX82BW;Database=tirocinio;Uid=admin;Pwd=;"
'str1="Provider = SQLOLEDB; Data Source = DAMAR3-OXXX82BW; Initial Catalog= tirocinio; User Id=; Password=;"
'strcon="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Tirocinio;uid=io;pwd=io;Data Source=DAMAR3-OXXX82BW"
'strcoj="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Tirocinio;Data Source=DAMAR3-OXXX82BW;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DAMAR3-OXXX82BW;Use Encryption for Data=False;Tag with column collation when possible=False"
'strC = "driver={SQL Server};server=DAMAR3-OXXX82BW; database=tirocinio"
'strconn="Provider=MSDASQL.1;Persist Security Info=False;Data Source=tirocinio"
'Conn.Open(str1)
'sql = "SELECT * FROM userid"
' Chiusura del database
conn.Close
set conn = Nothing
|