My computer installed two SQL Server database, one is SQL2000, one is SQL2008R2
Separately in different instance name,
When I use the DELPHI SQL database connection, the connection string inside as if no instance name
Could you tell me how to use different instances of different database connection? Can provide the connection string reference?
Thank you very much!

CodePudding user response:

Theoretically login server can use the computer name, instance name, namely the Delphi server name used in the connection string, but a lot of set wrong also don't go up, is very demanding, you can try a search online tutorial,
I can't verify, no double database,

CodePudding user response:

In addition
1. Use the select @ @ ServerName can see the current database server name
In the table 2. The SELECT * FROM Sys. SysServers can see all of the current server name
I wish you good luck

CodePudding user response:

You can solve the port, a 1433, a 3333
IP address add a comma behind plus the port number

CodePudding user response:

Your problem, have to look at is connection MSSQL data directly, or through DataSnap connection,
We do not advocate a system, install two MSSQL system, for the operating system, it is a database service program, to distinguish, only through a port, to do,
Because a MSSQL database, it can be installed more than one database (documents), through which users can access different database, and MSSQL2008, decentralization, with come in handy,

If it is DataSnap, have to be on the server even the MSSQL, connect the, the client can only connect the,

Control if you use a socket, there are two places that can be the difference, one is the MSSQL server name (sometimes is not the same as the high and low version, the installation, you can don't named), two ports,