Sa login when using ADODataSet control always fail to log in to sa, how all not line, but can use Windows login, then don't run the program, on the interface with ADODataSet, ADOConnection can connect,
Question: in Windows 7 pro, sqlserver2008, delphi7 runtime with sa logs in, ADODataSet control always fail to log in to sa,
Can log in with the Windows identity, and the program can run normally, at run time using the sas log use ADOQuery can log in, use ADODataSet how all not line, when editing ADODataSet can login, don't know is what reason, seek expert answers, thank you.
CodePudding user response:
This problem is complicated, I met, through the system parameter is set to solve with MSSQL,May (driver) compatible with system and MSSQL,
It is recommended to use a machine, installation, and write down the steps and parameter Settings,
Complete, normal operation,
According to the steps to install the other machine again,
CodePudding user response:
Install.net patch testCodePudding user response:
Virtual machine test, it is best not to use ghost version of the system,CodePudding user response:
ADO string, SQL 2008 is differentCodePudding user response:
ADO string, has different SQL 2008,But it is still backward compatibility,
CodePudding user response:
After the SQL 2008 to 2000, including some of the more complex SQL statements, will be some slight differences.Can't connect, ever try try other users don't have to SA?
Windows 7 permission problems sometimes let you inadvertently said.
CodePudding user response:
You'd better put ADO sockets, drying out,CodePudding user response:
Try to install SQLNIC2008CodePudding user response:
Windows 7 and win2008 can continue to install SQL2000, as stable there would be no problem! Baidu has specific installed! Is simple is to run X86 SETUPSQL under \ SETUP. EXE then SP4 patch is also run X86 \ SETUPCodePudding user response:
Thank you,Windows 7 pro running environment, sqlserver2008. In Windows 7 pro bottoms delphi7
Other users can login, always quote user login failed,
Sa a user login with the following string (this use ADODataSet, always fail to log in to sa,)
The ConnectionString:='Provider=SQLOLEDB. 1; Persist Security Info=False; The User
ID='+ YhName +'; Initial Catalog='+ DBaseName +'; The Data
The Source='+ ServerName +'; PassWord='+ PassWord;
When Windows login with the following string (this can log in, the program can run normally)
The ConnectionString:='Provider=SQLOLEDB. 1; Persist Security Info=true; Initial
The Catalog='+ DBaseName +'; Data Source='+ ServerName +'; Integrated Security=SSPI ';
CodePudding user response:
May I have your ServerName, whether is the server name (computer), can name list?CodePudding user response:
Problem solved,Windows 7 pro tracking found in running environment, sqlserver2008, delphi7, ADOConnection. The ConnectionString
After connecting the password='password' this sentence is lost, in the above applies, the Windows xp does not exist the problem,
When open the data table with ADODataSet ADOConnection to reconnect, at this point, the ADOConnection. The ConnectionString string has
No password="password" this sentence, so the failure of sa login error,
I am such a solution:
ADOConnection in the ADOConnection ADOConnectionBeforeConnect events. The ConnectionString assignment, it is in other
Place to ADOConnection. The ConnectionString assignment, thus solved the problem, thank you,
The connection string is:
The Provider=SQLOLEDB. 1; Persist Security Info=False; User ID=sa; Initial Catalog=shops; Data Source=127.0.0.1;
PassWord=qqw123
CodePudding user response:
Settled, it is good, but also the results drying out sharing, praise a,CodePudding user response:
The building Lord mental commendable, ~