Tutte le connessioni ai database

Tutte le connessioni ai diversi tipi di database.

Di seguito riportiamo alcuni esempi per comporre stringhe di connessione a diversi tipi di database:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydatabase.mdb"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:\mydatabase.mdb"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "FILEDSN=ADSN"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname","username","password"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=c:\mydatabase.mdb" 
Conn.Open DSNtest
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/databases/mydatabase.mdb")
Conn.Open DSNtest
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=mydatabase "
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=mydatabase"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=mydatabase"
Conn.open DSNtest
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\databases\mydatabase.dbc"
Conn.Open ConnStr
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.cursorlocation=adUseClient   
' requires use of adovbs.inc; numeric value is 3
Conn.open "DSN=test;UID=name;PWD=pass"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.cursorlocation=adUseClient   
' requires use of adovbs.inc; numeric value is 3
DSNTest="Provider=MSDAORA.1;Password=pass;User ID=name;Data Source=data.world"
Conn.open DSNtest
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "Driver={mySQL}; Server=nomeserver; Database=nomedatabase; Uid=admin; Pwd=password;"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "Provider=MySQLProv; Data Source=nomeserver; User Id=admin; Password=password;"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "Data Source=nomeserver; Database=nomedatabase; User ID=admin; Password=password;"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=c:\percorso\foglio.xls;"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\percorso\foglio.xls; Extended Properties=""Excel 8.0;HDR=Yes;"""
%>

immagini, cerca lavoro, pele, van basten, maradona, formula1, php, meteo, cap, radio, asp, incidenti, filmato, ferrari, macchine sportive, foto, filmati, comici, auto, video