3.4w+
社区成员
请问大虾：如何在pb8.0中使用ole db接口连接SQL Server中的除master之外的数据库？不用Data Link file，只用代码！！
在pb的ole microsoft oledb中我可以用data link file连接sql server中的所有数据库，但是不用datalink file就只能连接master数据库。请问如何用代码实现？
...全文
请发表友善的回复…
发表回复
linda_gao 2001-12-17
- 打赏
- 举报
in database painter ,
you can setup it in Extended properties of connection tab page :
database=pubs
in your script:
you should setup it in dbparm
SQLCA.DBParm = "PROVIDER=PROVIDER='SQLOLEDB',DATASOURCE='cnpb_qadb',PROVIDERSTRING='database=pubs'"
you can setup it in Extended properties of connection tab page :
database=pubs
in your script:
you should setup it in dbparm
SQLCA.DBParm = "PROVIDER=PROVIDER='SQLOLEDB',DATASOURCE='cnpb_qadb',PROVIDERSTRING='database=pubs'"