Hello, I have one question for DB Mirror connection How do I make a connection through ODBC to a mirror DB? In isql, I have been able to setup the two machines, and I was able to succesfully connect, but I do not know how to configure the OBDC for mirrored DBs (even if I know how to do it for a single one) I am using odbc for asa9 and asa12. Thanks in advance. |
(That's just an attempt to answer the underlying question - see the flow of comments beneath the question:) In a v12 HA setup, the clients will usually have to specify two host names in the HOST connection parameter. To do so, use a comma-separated list of host names (and ports, if necessaray). Cf. the sample connection string from the tutorial:
@Gizeh333 - if this solved your problem - can you accept Volkers' answer (by clicking on the tick under the thumbs down symbol on the left) - that way future users with the same problem will know what to do! Thanks
(12 Jun '12, 06:10)
Justin Willey
|
Have you worked through the High Availability Tutorial in the documentation yet? If so, how far did you get in this tutorial? Did you get to step 13? If you received any errors during this tutorial, what were they? What commands did you already try?
I have the higth Avalability finished and I not recived any error. I can connect to isql, and sybase Central correctly but I don't Know how configure the ODBC for my aplication connection.
Thanks
Okay, so that should mean that you made it successfully through Step 13, which was connecting to the HA system by specifying the 'alternative name' for the server (which in version 12.0.x is set up as part of the
CREATE MIRROR SERVER
statement):dbisql -c "UID=DBA;PWD=sql;SERVER=mirror_demo_primary;HOST=localhost:6871,localhost:6872"
The "-c" is the Connection Parameter information that can also go into an ODBC DSN. You can use the
dbdsn
utility to specify the exact same "-c" connection information to create your ODBC DSN if you do not want to translate the values in the Microsoft ODBC Manager GUI.If you are working with 32-bit applications versus 64-bit applications on a 64-bit Microsoft Windows operating system, be aware of which bitness of the ODBC driver you are trying to access. (See: http://www.sybase.com/detail?id=1091419 for more details).
Thanks for you answer, but I already have tried that. Here is my ODBC Contiguration:
USer ID:dba Password:xxxx
Action: connect to a runing database on another computer
Host: pc1:6871;pc2:6872
Port:
Server_name= primary_server
With this configuration, I am having this error
"Connection Failed: Connection error: The HOST and LINKS options cannot both be specified"
Thanks in advance.
What's the full connection string?
It seems that besides the given parameter, there is also a setting for LINKS=...
Best thing is to use dbdsn -gu or -gs (for user or system dsn) followed by your ODBC dsn and then post what you see.
As Volker said, there is likely going to be a LINKS= parameter in there.
Sorry, I can pass you the information of the command, as the error I get when I try to save the settings. But a I see no option to configure the links, you can only configure the host.
Please, tell me as you can configure the ODBC connection for a system scaled and replicated.(DB mirror) Thanks
As you seem to use the GUI dialog to connect to the database, have a look at the "Network" tab. The "TCP/IP options" there are those that are used for the "LINKS" connection parameter. It seems there are some values set, otherwise you should not get the connection error "The HOST and LINKS options cannot both be specified".
You were right.I have corrected.
Now the full connection string is: UID=dba;PWD=xxx;ServerName=server_s1;INT=NO;ENC=NONE; Host='host0:6871;host1:6872'
Now the error I get when doing a test connection is "Connection Failed: Connection error:Error in TCPIP port options"
Thanks
Try
i.e. no quotes, and separate the hosts by a comma - cf. the docs.
thanks!! So much trouble for a comma!!