PDA

View Full Version : سوال: کانکشن استرینگ برای اکسس تحت شبکه



moferferi
سه شنبه 12 آبان 1388, 09:01 صبح
من
اینا میزنم ولی ایراد میگیره

DBcon = new OleDbConnection(@"Provider=microsoft.jet.oledb.4.0;data source =\192.168.1.12\dbtel\Directory.mdb");

Mohagheghi
سه شنبه 12 آبان 1388, 09:49 صبح
انواع Connection String براي اكسس:


ODBC DSN

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Dsn=DsnName";
conn.Open();



// ODBC -- Standard Security

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
"Driver={Microsoft Access Driver (*.mdb)};" +
"Dbq=c:\myPath\myDb.mdb;" +
"Uid=Admin;Pwd=;";
conn.Open();




// ODBC -- Workgroup (System Database)

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
"Driver={Microsoft Access Driver (*.mdb)};" +
"Dbq=c:\myPath\myDb.mdb;" +
"SystemDb=c:\myPath\myDb.mdw;";
conn.Open();





// ODBC -- Exclusive Use

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
"Driver={Microsoft Access Driver (*.mdb)};" +
"Dbq=c:\myPath\myDb.mdb;" +
"Exclusive=1;";
"Uid=Admin;Pwd=;";
conn.Open();




// OleDb with MS Jet -- Standard Security

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\mypath\myDb.mdb;" +
"User id=admin;" +
"Password=";
conn.Open();





// OleDb with MS Jet -- Workgroup (System Database)

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\mypath\myDb.mdb;" +
"System Database=c:\mypath\myDb.mdw;";
conn.Open();





// OleDb with MS Jet -- With Password
using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\mypath\myDb.mdb;" +
"Database Password=Secret;"
conn.Open();


اميدوارم كه مفيد واقع شده باشه

يا علي