When connecting to a database error, error content is as follows:
SQLSTATE=28000 Microsoft OLE DB Provider for SQL Server invalid authorization description
Each master help!!!!!!!!!!

CodePudding user response:

Don't understand, help

CodePudding user response:

A: can you tell me where you have pbmss100. DLL? If any, help send mail to [email protected], thank you very much!!!!!!

CodePudding user response:

You also use the DBMS MSS MS SQL SERVER 6. X linked directly to calculate, I lack the pbmss100 DLL,

CodePudding user response:

Connection parameters are
The integer li_FileNum
If FileExists (" Xzdxpt. Ini ")=false then
Li_FileNum=FileOpen (" Xzdxpt. Ini, "lineMode! The Write! , LockWrite! The Replace!
FileWrite (li_FileNum, "[Database]")
FileWrite (li_FileNum, "DATASOURCE=")
FileWrite (li_FileNum, "Database=")
FileWrite (li_FileNum, "LogPass=")
FileWrite (li_FileNum, "LogId=")
FileWrite (li_FileNum, "[the 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")
SYSTEMINI SetProfileString (" Xzdxpt ini ", ""," DSSJ ", "08:30)
SYSTEMINI SetProfileString (" Xzdxpt ini ", ""," Birthday ", "happy Birthday to you!" )
SYSTEMINI SetProfileString (" Xzdxpt ini ", ""," Default ", "I wish a happy holiday!" )
End the if
The SQLCA. DBMS="OLE DB"
The SQLCA. Database=ProfileString (" Xzdxpt. Ini ", "Database", "Database", "")
The SQLCA. LogPass=ProfileString (" Xzdxpt. Ini ", "Database", "LogPass", "")
The SQLCA. LogPass=ProfileString (" Xzdxpt. Ini ", "Database", "LogId", "")
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='UNITECH - 05', PROVIDERSTRING='Database=XZDXPT'"
Connect using the sqlca;
If the sqlca. Sqlcode<> 0 then
Messagebox (" database error ", the sqlca sqlerrtext)
The else
Open (w_login)
end if

CodePudding user response:

You try not ini file to connect to try, even DB ProFile there copy connection code, write the connect;
And, pb10 connect to the database without pbmss100. DLL, I use pb10.5, was not found to the pbmss105. DLL

CodePudding user response:

Error has been solved, is the SQLCA LogPass=ProfileString (" Xzdxpt. Ini ", "Database", "LogId", "")
This sentence is wrong...

CodePudding user response:

Thank you for your participation