I have a VPN where I started two ASA 9.0.2.3951 database with the same SERVER NAME, using ODBC, but when trying to connect in the database, is presenting the following message:
How do I resolve this situation? In TCPIP I informed (specifically for each connection) Host = 192.168.2.100: 2640 Host = 192.168.3.100: 2640 Connecting via Sybase Central does not make the connection smooth. Anyone who can help me, I thank you. asked 13 Jul '17, 22:30 Walmir Taques |
Show us exactly how you started the server(s) and database(s), and exactly how you (tried to) connect.
Adding DOBROADCAST=NONE to the connection string sometimes solves weird network connection problems... also include HOST=[ipaddress].
Command Line Started in IP 192.168.2.200 "C:\Program Files (x86)\Sybase\SQL Anywhere 9\win32\dbsrv9.exe" -ch 2096M -n DBTEST -x TCPIP{port=2651} "D:\TEST\2016\DBTEST.DB"
Started in IP 192.168.3.200 "C:\Program Files (x86)\Sybase\SQL Anywhere 9\win32\dbsrv9.exe" -ch 2096M -n DBTEST -x TCPIP{port=2640} "D:\TEST\2017\DBTEST.DB"
Do you really need to use the same server name?
@JBSchueler At the moment the stores have several stations connected in this Server name, changing the server name would be very laborious, but if you can not do it, I will have to change.
Please show us the exact connection string that failed, as requested.
Will you be able to change the connection string used by the failing station?
Please show us the exact message text.
"Duplicate Database name" is not likely what appeared.
Yes, I can change.
I added it in ODBC DOBROADCAST = NONE, but it did not work.
ODBC Image https://drive.google.com/open?id=0BxTS6FYDkr9qbGx0YnFTQ0lyYzg
By not work, do you mean you get the same error as before or a different one? If different, do you have HOST= in the TCPIP box i.e., HOST=IP:PORT;DOBROADCAST=NONE
I would expect an error HOST= is not supplied. In testing, the error is (Ctrl+C on the message window):
Connection failed: Connection error: Error in TCPIP port options
And what client version do you use? Is this SA 9.0.2, too, or a newer version?