Management System running problems developed by Delphi and SQL Sever: Delphi/Windows SDK/API
Http://www.delphi2007.net/DelphiDB/html/delphi_20061216215656261.html
This is not because SQL Sever databases must be enabled first for the .exe file of the management system that uses Delphi. If SQL is not installed on other hosts, what can I do to run the management system properly on other hosts without reporting the error that the database cannot be connected, please advise
I use BDE.
At first, we seem to have to start SQL.
That doesn't work. SQL server must be installed and run ..
The client does not need to install the sqlserver system. You only need the following files:
Dbnetlib. dll, dbmssocn. dll, dbnmpntw. dll, ntwdblib. dll
Where can I find these files? How can I find it? Trouble master advice, younger brother just learn this software, a lot of things will not be used, if the master has these files, trouble to pass in my mailbox, xmlt238@yahoo.com.cn, thank you very much !!!
Has been to xmlt238@yahoo.com.cn, please check
Thank you.
Two methods:
1. You can install the sqlservr client on the client.
2. You can modify the key value of the registry file \ Software \ Microsoft \ MSSQLServer \ Client \ connectto.
Add a data alias, dbmssocn, IP address, and 1433.
Install the database engine on the client, such as mdac_type.exe (2.7 or 2.8)
And so on: How can I run it on a host that someone else has not installed an operating system.
Of course, you have to install it.ProgramIt is best to use an installation and production tool to package and even the database.
BDE may be difficult to set. If you use ADO, you only need to set the connection string and package the MDAC.
We recommend a program named "installation and production of fat cats" for packaging, which is easy to use.
Thank you for your advice.
2. You can modify the key value of the registry file \ Software \ Microsoft \ MSSQLServer \ Client \ connectto.
Add a data alias, dbmssocn, IP address, and 1433.
I modified: sky, dbmssocn, 192.168.1.2, 1433
What are the IP addresses based on? Is the dbmssocn configuration incorrect? Can I set it like this?
I have completed the setup file, but must I set the ODBC data source and append the database in SQL Server to run my system?
What should I do? Thank you for your advice.
The IP address is the address of your database server.
Sky is your database alias. It should be the same as that in ADO when you call the program.
After setup, you can write a small program to test it.
Be sure to install the database. If you want to modify the program, do not connect to the data, or install a desktop version of SQL
Where can I download desktop SQL statements? I cannot find
Two methods:
2. You can modify the key value of the registry file \ Software \ Microsoft \ MSSQLServer \ Client \ connectto.
Add a data alias, dbmssocn, IP address, and 1433.
Is it impossible for you to successfully debug In the second method? We have been doing this all the time.