Background: A and B two database server, WINDOWS 2008 R2 & amp; SQL SERVER 2008 R2, A client C, run DELPHI7 development program, the SERVER A synchronous subscription data from other data sources affairs, SERVER B links and define A SERVER A synonym for all tables in the client connect SERVER B to get the data of the program, C
Problems: the SERVER B can be normal on SQL query a synonym for data, the client access SERVER running DELPHI7 development program C B synonymous with error, error message for "SQL SERVER is not specified mistakes, connection has been disconnected" (error message is not entirely accurate, is roughly described,)
Weird solution: the current solution is on the server all tables to create A view, server B on server A view of synonyms, in this case the client DELPHI7 programs to run C to the data to be normal,
Other situations: the server and the server B is not in the same network segment, the program is running on the server, or on the same network segment of client C cannot obtain synonym table data,
Please everybody many help, find the problem, thank you very much! Points, there are many, the real problem solving can add cent! Thank you again!
CodePudding user response:
Not met this kind of situation, can't help busy, help you top it,CodePudding user response:
Use
CodePudding user response:
Haven't tried this environment