Pb in SQL server database connection, and then double-click to run when the system connect to the database is normal, but when I was in the registry run automatically connect database, sqlcode sqltext==- 1 'incorrect login' should excuse me I how to work out "?????? thank you

CodePudding user response:

There are several possibilities:
1. The 'users' database operation, not set well
2. To access the database mode selection 'SQL Server and Windows, give it a try...

CodePudding user response:

As if can't solve the problem, whether still have what way?? It is best to myself to try first

CodePudding user response:

Since the run time, confirm whether the network has been normal connection,

CodePudding user response:

Give you a piece of code:
String ls_ini, ls_section
//* * * * * the database parameter Settings, connect to the database (sqlca)
Ls_ini='njxmq_his. Ini'
Ls_section='njxmqhisdatabase'
SQLCA. DBMS=ProfileString (ls_ini ls_section, "DBMS", "")
The SQLCA. Database=ProfileString (ls_ini ls_section, "Database", "")
The SQLCA. LogID=ProfileString (ls_ini ls_section, "LogID", "")
SQLCA. LogPass=ProfileString (ls_ini ls_section, "LogPassword", "")
The SQLCA. ServerName=ProfileString (ls_ini ls_section, "ServerName", "")
The SQLCA. UserID=ProfileString (ls_ini ls_section, "UserID", "")
SQLCA. DBPass=ProfileString (ls_ini ls_section, "DatabasePassword", "")
The SQLCA. Lock=ProfileString (ls_ini ls_section, "Lock", "")
The SQLCA. The AutoCommit=False
Connect Using the sqlca;
If the sqlca. Sqlcode & lt;> 0 then
MessageBox (" unable to connect database management system ", the sqlca. Sqlerrtext)
The halt
End the if

At the same time give you 'njxmq_his. Ini file content
[njxmqhisdatabase]
SQL Server DBMS=MSS (Msoft) 6. X
The Database=njxmqhis_sql
UserId=
DatabasePassword=
ServerName=.
LogId=sa
The Lock=
Prompt=0
LogPassword=PPPPPP
Including the Database=njxmqhis_sql definition to connect Database
LogId=sa is connect to the database ID
LogPassword=PPPPPP ID=SA is the corresponding password
ServerName=. Is the name of the database in the computer, '. 'represents the native

CodePudding user response:

Well, the LS positive solution,