新手学习PB怎么连接sqlserver 和access数据库
用下面SQLserver 的DSN对吗
string user_name,pass_word
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Connectstring='DSN=book'"
connect;
SELECT admin.username,
admin.pwd
INTO :user_name,
:pass_word
from admin
where admin.username=sle_1.text;
if sle_1.text="" or sle_2.text="" then
messagebox("错误!","用户名或密码不能为空!",exclamation!,ok!,2)
disconnect;
else
if user_name=sle_1.text and pass_word=sle_2.text then
open(mainwindow)
close(parent)
messagebox("用户名或密码错误","",exclamation!,ok!,2)
disconnect;
end if
end if
请问一下
不用DSN怎么连接
sql server 和access数据库呀