Greetings-
I've recently been graphing all sorts of funs tuff with MRTG.
Anyway, my MRTG stuff runs under linux. I'm wanting to graph some table growth so I decided to use the OpenLink ODBC drivers to connect to my database. But, alas, i cannot get it to work.
I downloaded the ODBC SDK, and am using the testodbc program.
I continually receive this error message when connecting:
promot> ./odbctest "DSN=OL"
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
OpenLink: RPC: Unable to receive
[OpenLink][ODBC]RPC: Unable to receive, SQLSTATE=08004
[OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004
So, i think something in my DSN setup is wrong, but i cannot figure out what. My .odbc.ini looks like this:
[ODBC Data Sources]
OL = OpenLink Generic ODBC Driver
[OL]
Driver = /usr/local/lib/oplodbc.so.1
Description = Sample OpenLink DSN
Host = hostname
ServerType = Progress 91C
FetchBufferSize = 50
UserName = username
Password = password
Database = database
Options = -S 28001 -N TCP -H hostname
ConnectOptions = -S 28001 -N TCP -H hostname
Port = 28001
Protocol = TCP
Trace = 1
TraceFile = ./odbctrace.out
[Default]
Driver = /usr/local/lib/oplodbc.so.1
--------------------------------
(I edited the actual hosts/db names)
And my .odbcinst.ini looks like this:
[ODBC Drivers]
OpenLink Generic ODBC Driver = Installed
[OpenLink Generic ODBC Driver]
Driver = /usr/local/lib/oplodbc.so.1
Setup = /usr/local/lib/oplodbc.so.1
I've spent a few hours on this, and am starting to get frusterated.
Anyone have any ideas?
Pertinent information:
The server is progress 91c under Win2k.
I'm using the progress supplied oibrkr32.exe (not SQL92 server)
(I would use the SQL92 server if I could, but i haven't even initialized the datasource correctly yet)
The client is linux, using the OL SDK drivers.
Any info, is appreciated.
I've recently been graphing all sorts of funs tuff with MRTG.
Anyway, my MRTG stuff runs under linux. I'm wanting to graph some table growth so I decided to use the OpenLink ODBC drivers to connect to my database. But, alas, i cannot get it to work.
I downloaded the ODBC SDK, and am using the testodbc program.
I continually receive this error message when connecting:
promot> ./odbctest "DSN=OL"
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
OpenLink: RPC: Unable to receive
[OpenLink][ODBC]RPC: Unable to receive, SQLSTATE=08004
[OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004
So, i think something in my DSN setup is wrong, but i cannot figure out what. My .odbc.ini looks like this:
[ODBC Data Sources]
OL = OpenLink Generic ODBC Driver
[OL]
Driver = /usr/local/lib/oplodbc.so.1
Description = Sample OpenLink DSN
Host = hostname
ServerType = Progress 91C
FetchBufferSize = 50
UserName = username
Password = password
Database = database
Options = -S 28001 -N TCP -H hostname
ConnectOptions = -S 28001 -N TCP -H hostname
Port = 28001
Protocol = TCP
Trace = 1
TraceFile = ./odbctrace.out
[Default]
Driver = /usr/local/lib/oplodbc.so.1
--------------------------------
(I edited the actual hosts/db names)
And my .odbcinst.ini looks like this:
[ODBC Drivers]
OpenLink Generic ODBC Driver = Installed
[OpenLink Generic ODBC Driver]
Driver = /usr/local/lib/oplodbc.so.1
Setup = /usr/local/lib/oplodbc.so.1
I've spent a few hours on this, and am starting to get frusterated.
Anyone have any ideas?
Pertinent information:
The server is progress 91c under Win2k.
I'm using the progress supplied oibrkr32.exe (not SQL92 server)
(I would use the SQL92 server if I could, but i haven't even initialized the datasource correctly yet)
The client is linux, using the OL SDK drivers.
Any info, is appreciated.