Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

请教如何用OLE DB连接加密的Access数据库

2 posts in General Discussion (Chinese) Last posting was on 2006-08-30 03:28:42.0Z
tzwin Posted on 2006-08-27 04:01:27.0Z
Sender: 7a04.44f114fd.1804289383@sybase.com
From: tzwin
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: 请教如何用OLE DB连接加密的Access数据库
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44f1168e.7a0c.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 26 Aug 2006 20:50:38 -0700, 10.22.241.42
Lines: 26
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Aug 2006 20:50:40 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Aug 2006 21:01:27 -0700
X-Trace: forums-1-dub 1156651287 10.22.108.75 (26 Aug 2006 21:01:27 -0700)
X-Original-Trace: 26 Aug 2006 21:01:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:106
Article PK: 104151

&#23545;&#20110;&#27809;&#26377;&#21152;&#23494;&#30340;MDB&#25968;
&#25454;&#24211;

SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='d:\test.mdb'"

&#36825;&#26679;&#36830;&#25509;&#26159;&#33021;&#27491;&#24120;
&#24037;&#20316;&#30340;,
&#20294;&#22914;&#23558;&#25968;&#25454;&#24211;&#21475;&#20196;
&#35774;&#32622;&#20026;1234

&#21442;&#29031;ADO&#20013;ConnectionString&#35774;&#32622;&#25913;
&#20026;

SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='d:\test.mdb'
,Jet OLEDB:Database Password='1234'"

&#23601;&#26159;&#19981;&#33021;&#36830;&#25509;

&#35831;&#21508;&#20301;&#26379;&#21451;&#36176;&#25945;&#65292;
&#35813;&#22914;&#20309;&#20462;&#25913;&#65311;


hni Posted on 2006-08-30 03:28:42.0Z
Sender: 3779.44f502f5.1804289383@sybase.com
From: hni
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Re: &#35831;&#25945;&#22914;&#20309;&#29992;OLE DB&#36830;&#25509;&#21152;&#23494;&#30340;Access&#25968;&#25454;&#24211;
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44f50350.377a.1681692777@sybase.com>
References: <44f1168e.7a0c.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 29 Aug 2006 20:17:36 -0700, 10.22.241.42
Lines: 40
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Aug 2006 20:17:37 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Aug 2006 20:28:42 -0700
X-Trace: forums-1-dub 1156908522 10.22.108.75 (29 Aug 2006 20:28:42 -0700)
X-Original-Trace: 29 Aug 2006 20:28:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:107
Article PK: 104152

&#25353;&#36825;&#20010;&#26684;&#24335;&#20889;&#19968;&#19979;
&#35797;&#35797;
// Profile authors
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <***>
SQLCA.LogId = "dba"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='c:\Authors.mdb'"

> &#23545;&#20110;&#27809;&#26377;&#21152;&#23494;&#30340;
> ;MDB&#25968; &#25454;&#24211;
>
> SQLCA.DBMS = "OLE DB"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
> "PROVIDER='Microsoft.Jet.OLEDB.4.0'
> ,DATASOURCE='d:\test.mdb'"
>
> &#36825;&#26679;&#36830;&#25509;&#26159;&#33021;&#27491;
> ;&#24120; &#24037;&#20316;&#30340;,
> &#20294;&#22914;&#23558;&#25968;&#25454;&#24211;&#21475;
> ;&#20196; &#35774;&#32622;&#20026;1234
>
>
&#21442;&#29031;ADO&#20013;ConnectionString&#35774;&#32622;
> ;&#25913; &#20026;
>
> SQLCA.DBMS = "OLE DB"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
> "PROVIDER='Microsoft.Jet.OLEDB.4.0'
> ,DATASOURCE='d:\test.mdb' ,Jet OLEDB:Database
> Password='1234'"
>
> &#23601;&#26159;&#19981;&#33021;&#36830;&#25509;
>
> &#35831;&#21508;&#20301;&#26379;&#21451;&#36176;&#25945;
> ;&#65292; &#35813;&#22914;&#20309;&#20462;&#25913;&#65311;