連接的時候出現資料庫錯誤,錯誤內容如下:
SQLSTATE=28000 Microsoft OLE DB Provider for SQL Server 無效的授權說明
各位大俠幫幫忙!!!!
uj5u.com熱心網友回復：
不明白，幫頂uj5u.com熱心網友回復：
請問你那里有pbmss100.dll么？如果有的話，幫忙發到郵箱[email protected],萬分感謝！！！uj5u.com熱心網友回復：
你也用DBMS MSS MS SQL SERVER 6.X直接鏈接算了，我就缺pbmss100.dll。uj5u.com熱心網友回復：
連接引數如下integer li_FileNum
if FileExists("Xzdxpt.ini")=false then
li_FileNum = FileOpen("Xzdxpt.ini", lineMode!, Write!, LockWrite!, Replace!)
FileWrite(li_FileNum,"[Database]")
FileWrite(li_FileNum,"DATASOURCE=")
FileWrite(li_FileNum,"Database=")
FileWrite(li_FileNum,"LogPass=")
FileWrite(li_FileNum,"LogId=")
FileWrite(li_FileNum,"[User Info]")
FileWrite(li_FileNum,"uid=")
FileWrite(li_FileNum,"[SYSTEMINI]")
FileWrite(li_FileNum,"DSSJ=")
FileWrite(li_FileNum,"BirthDay=")
FileWrite(li_FileNum,"Default=")
FileClose(li_FileNum)
SetProfileString("Xzdxpt.ini","Database","DATASOURCE","UNITECH-05")
SetProfileString("Xzdxpt.ini","Database","Database","xzdxpt")
SetProfileString("Xzdxpt.ini", "Database", "LogPass","sa")
SetProfileString("Xzdxpt.ini","Database","LogId","sa")
SetProfileString("Xzdxpt.ini", "User Info", "uid","admin")
SetProfileString("Xzdxpt.ini", "SYSTEMINI", "DSSJ","08:30")
SetProfileString("Xzdxpt.ini", "SYSTEMINI", "Birthday","祝您生日快樂!")
SetProfileString("Xzdxpt.ini", "SYSTEMINI", "Default","祝節日快樂!")
end if
SQLCA.DBMS = "OLE DB"
SQLCA.Database = ProfileString("Xzdxpt.ini","Database","Database","")
SQLCA.LogPass = ProfileString("Xzdxpt.ini","Database","LogPass","")
SQLCA.LogPass = ProfileString("Xzdxpt.ini","Database","LogId","")
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='UNITECH-05',PROVIDERSTRING='Database=xzdxpt'"
connect using sqlca;
if sqlca.sqlcode<>0 then
messagebox("資料庫錯誤",sqlca.sqlerrtext)
else
open(w_login)
end if
uj5u.com熱心網友回復：
你試試不用ini檔案來連接試試﹐就是DB ProFile那里拷貝連接代碼﹐寫上connect;還有﹐pb10連接數據庫不用pbmss100.dll的﹐本人用pb10.5﹐就沒有發現要這個pbmss105.dll的
uj5u.com熱心網友回復：
錯誤已解決,是SQLCA.LogPass = ProfileString( "Xzdxpt.ini ", "Database ", "LogId ", " ")這句出了問題............
uj5u.com熱心網友回復：
謝謝大家的參與轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/117843.html
標籤：數據庫相關
上一篇：PB ASA與ODBC配置問題