SQL Server
|
|
• ODBC
|
|
|
"Driver={SQL Server};Server=sql01.intervision.co.il;Database=DB_NAME;Uid=USER_NAME;Pwd=PASSWORD;"
|
|
• OLE DB, OleDbConnection (.NET)
|
|
|
"Provider=sqloledb;Data Source=sql01.intervision.co.il;Initial Catalog=DB_NAME;User Id=USER_NAME;Password=PASSWORD;"
|
ACCESS
|
|
• ODBC
|
|
|
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=USER_NAME;Pwd=PASSWORD;"
|
|
• OLE DB, OleDbConnection (.NET)
|
|
|
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=USER_NAME;Password=PASSWORD;"
|
