"Provider=SQLOLEDB.1;Data Source=127.0.0.1;UID=superp;Password=superp;" 在SQL中写“ from 数据库名..表名" 即可 请你多添分!太少
这是我写代码(DELPHI6): AdoQuery1.connectionstring := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NewCrmBXN;Data Source=localhost;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MANAGER;Use Encryption for Data=False;Tag with column collation when possible=False'//在这里我用的数据库是newcrmbxnadoquery1.sql.clear; adoquery1.sql.add('select * from pubs.dbo.cutomer'); adoquery1.open;
我在SQL中很少写数据库的,只在连接时指定数据库就行了。 dim conn as new adodb.connection ... conn.connectionstring="Provider=SQLOLEDB.1;Data Source=127.0.0.1;UID=superp;Password=superp;DATABASE=xylservice" conn.open ... dim strsql as string dim rs1 as new adodb.recordset strsql="select * from products" rs1.open strsql,conn,0,0 以上是VB。
那字串连接的就是默认库,不需要加库名,
访问另外一个库上的表则需要用xlyservice.dbo.product
在SQL中写“ from 数据库名..表名"
即可
请你多添分!太少
AdoQuery1.connectionstring := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NewCrmBXN;Data Source=localhost;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MANAGER;Use Encryption for Data=False;Tag with column collation when possible=False'//在这里我用的数据库是newcrmbxnadoquery1.sql.clear;
adoquery1.sql.add('select * from pubs.dbo.cutomer');
adoquery1.open;
dim conn as new adodb.connection
...
conn.connectionstring="Provider=SQLOLEDB.1;Data Source=127.0.0.1;UID=superp;Password=superp;DATABASE=xylservice"
conn.open
...
dim strsql as string
dim rs1 as new adodb.recordset
strsql="select * from products"
rs1.open strsql,conn,0,0
以上是VB。
-----^^^dbo 用sa登陆可省