JET4.0连接字符串的问题,在线等... ( 积分: 100 )

C

ccqzly

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-03-18

• #1

请问我用VB是用jet4.0连接带密码的ACCESS数据库的连接字符串是怎么写的.另外连接SQLSERVER数据库的连接字符串又是怎么样的?

 

C

ccqzly

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-03-18

• #2

请问我用VB是用jet4.0连接带密码的ACCESS数据库的连接字符串是怎么写的.另外连接SQLSERVER数据库的连接字符串又是怎么样的?

 

W

wzl1027

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-03-18

• #3

Access
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/Documents and Settings/Administrator/桌面/DocOffice.mdb;Persist Security Info=False;Jet OLEDBatabase Password=psd
SQL Server2000
Provider=SQLOLEDB.1;Password=ttt;Persist Security Info=True;User ID=sa;Initial Catalog=CarMgr;Data Source=freebird

 

笑

笑江横

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-03-18

• #4

'Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=D:/lch/Data.mdb;
Persist Security Info=False;
Jet OLEDBatabase Password=12345';

 

J

jindgu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-03-18

• #5

同意楼上的说法

 

C

ccqzly

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2005-05-16

• #6

接受答案了.