View Full Version : سوال: کانکشن استرینگ برای اکسس تحت شبکه
moferferi
سه شنبه 12 آبان 1388, 10:01 صبح
من
اینا میزنم ولی ایراد میگیره
DBcon = new OleDbConnection(@"Provider=microsoft.jet.oledb.4.0;data source =\192.168.1.12\dbtel\Directory.mdb");
Mohagheghi
سه شنبه 12 آبان 1388, 10: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();
اميدوارم كه مفيد واقع شده باشه
يا علي
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.