Management System running problems developed by Delphi and SQL Sever

Source: Internet
Author: User
Tags mssqlserver
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.