Hi,
I am posting this as even though Symposium is used here, nearly no one has a clue how it works when it comes to connecting via Sybase to it. I am then using this ODBC in Crystal Reports to make reports (because I am pulling data from both Remedy and Symposium on the same report).
It was working on my old pc but I just received a new pc as mine was not powerful enough. On the old pc, I could easily connect via ODBC to Sybase, but on this one it does not work and gives me the error :
[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.
It is actually a heavily documented error message, but I could not get it to work here. Most people are using DSEDIT but instead here, we had made our own sql.ini files, one for the 2 servers to which we connect. I did try DSEDIT and this is what it looks like :
Attributes Values
Server Entry Version 1
Server Name ICCM_PREVIEW
Server Service SQL SERVER (I cannot change this?)
Server Status 4 Unknown (I cannot change this)
Server Address TCP- ***.***.***.***,5000
TCP- ***.***.***.***,5000
I can ping the servers and they respond properly. This does not appear to have modified my SQL.INI file.
Our ini files appear like so (we did not use DSEDIT here):
[ICCM_PREVIEW]
$BASE$01=NLNWLINK,ICCM_Server
$BASE$00=NLWNSCK,***.***.***.***,5000
query=$BASE$00;$BASE$01;
[ICCM_PRINT]
$BASE$01=NLNWLINK,ICCM_Server
$BASE$00=NLWNSCK,***.***.***.***,5000
query=$BASE$00;$BASE$01;
The Symposium server has not changed, so I am really stumped... could anyone offer insight?
If someone requires it, I can post my ODBC connection information tommorow morning, but it looks the same as this, I have a server name, a database name and my interface files point to the ini files we made.
Thanks in advance,
Phil
I am posting this as even though Symposium is used here, nearly no one has a clue how it works when it comes to connecting via Sybase to it. I am then using this ODBC in Crystal Reports to make reports (because I am pulling data from both Remedy and Symposium on the same report).
It was working on my old pc but I just received a new pc as mine was not powerful enough. On the old pc, I could easily connect via ODBC to Sybase, but on this one it does not work and gives me the error :
[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.
It is actually a heavily documented error message, but I could not get it to work here. Most people are using DSEDIT but instead here, we had made our own sql.ini files, one for the 2 servers to which we connect. I did try DSEDIT and this is what it looks like :
Attributes Values
Server Entry Version 1
Server Name ICCM_PREVIEW
Server Service SQL SERVER (I cannot change this?)
Server Status 4 Unknown (I cannot change this)
Server Address TCP- ***.***.***.***,5000
TCP- ***.***.***.***,5000
I can ping the servers and they respond properly. This does not appear to have modified my SQL.INI file.
Our ini files appear like so (we did not use DSEDIT here):
[ICCM_PREVIEW]
$BASE$01=NLNWLINK,ICCM_Server
$BASE$00=NLWNSCK,***.***.***.***,5000
query=$BASE$00;$BASE$01;
[ICCM_PRINT]
$BASE$01=NLNWLINK,ICCM_Server
$BASE$00=NLWNSCK,***.***.***.***,5000
query=$BASE$00;$BASE$01;
The Symposium server has not changed, so I am really stumped... could anyone offer insight?
If someone requires it, I can post my ODBC connection information tommorow morning, but it looks the same as this, I have a server name, a database name and my interface files point to the ini files we made.
Thanks in advance,
Phil