Re: [Sqlrelay-discussion] using sql relay with a specific ODBC driver

[Firstworks/4access <dav...@fi...>]

Everything looks good except, I noticed your connectstring is:

user=;password=;dsn=Tolas;autocommit=yes

Did you just leave out the user and password in this email or are they
really empty in the file?  If they are really empty, that could be the
problem.  Does the database not require a user/password?

It's possible that there is a bug too.  What version of SQL Relay are
you using?  Did you build from source?  I can send you a file with some
extra debug in it that will probably give us enough information to
figure out what's going on, but you'll have to rebuild SQL Relay from
source.  Is that ok?

David Muse
dav...@fi...

On Fri, 2005-07-08 at 15:22 +0200, Jeremie LEGRAND wrote:
> Hello,
> 
>  
> 
>             I would like to know if it is possible to use sqlrelay
> with a specific odbc driver made for one of our servers.
> 
> The situation is :
> 
>  
> 
> - I have an Alpha with OpenVMS on it
> 
> - I have a Redhat server, with a specific ODBC driver to connect to
> the Alpha
> 
> - I have a Debian server, with Apache and PHP
> 
>  
> 
> --> I try to make an ODBC link between RedHat and Debian, in order to
> use databases of the Alpha on PHP (Debian).
> 
>  
> 
> I can't directly connect Debian on the Alpha : the specific ODBC
> driver is only supported on RedHat...
> 
> For information, the ODBC driver is made by Attunity.
> 
>  
> 
>  
> 
>  
> 
> Our ODBC driver himself works. We could use it on PHP pages as well.
> 
>  
> 
> --> We defined our odbc.ini as follows :
> 
> [Tolas]
> 
> Driver = Connect to VMS
> 
> Driver = /usr/local/navroot/lib/navcli.so
> 
>  
> 
>  
> 
> Here is the config file
> 
>  
> 
> --------------------------------------------------------------------------
> 
> <?xml version="1.0"?>
> 
> <instances>
> 
>             <instance id="toto" port="9000"
> unixport="/tmp/sqlrelay.socket" dbase="odbc" connections="1"
> maxconnections="1" maxqueuelength="1" growby="1" ttl="60"
> endofsession="rollback" sessiontimeout="60" runasuser="root"
> runasgroup="root" cursors="5" authtier="listener" handoff="reconnect"
> deniedips="" allowedips="" debug="none">
> 
>                         <users>
> 
>                                    <user user="titi" password="titi"/>
> 
>                         </users>
> 
>                         <connections>
> 
>                                    <connection connectionid="Tolas"
> string="user=;password=;dsn=Tolas;autocommit=yes" metric="1"/>
> 
>                         </connections>
> 
>             </instance>
> 
> </instances>
> 
> --------------------------------------------------------------------------
> 
>  
> 
>  
> 
>  
> 
>  
> 
> The problem is that the configuration seems correct, but when we start
> sqlrelay, we got the following message :
> 
>  
> 
>  
> 
> --------------------------------------------------------------------------
> 
> Starting listener:
> 
>   sqlr-listener -id toto -config /root/toto
> 
>  
> 
> Starting 1 connections to Tolas :
> 
>   sqlr-connection-odbc -id toto -connectionid Tolas -config /root/toto
> 
> Couldn't log into database.
> 
>  
> 
> sqlr-connection-odbc failed to start.
> 
>  
> 
>  
> 
> Thanks to MP3.com for sponsoring:
> 
>         Clustered/Replicated database support.
> 
>         Perl API.
> 
> --------------------------------------------------------------------------
> 
>  
> 
>  
> 
> Thank you for any suggestion.
> 
>