Re: [Sqlrelay-discussion] Accessing SQL Server 2000 database using SQL Relay

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

What version of SQL Relay are you using?  0.36.4 should have printed out
some more debug right after "incrementing session count".

It's possible that the connection daemons didn't get started up
properly.  Either they shut down or hung at startup.  They should have
printed out an error at startup if there was a problem though.

Do a ps -efa | grep sqlr-connection and see if they're running.

If they're not running, the most common cause of a problem with the
sqlr-connection daemons getting logged in is having the wrong tds
version set in your freetds.conf file.  I don't remember offhand what
version you have to use with SQL Server 2000.  I believe that valid
versions are 4.2, 5.0, 7.0 and 8.0 though.  You may want to try each of
them.

If you do all that and still have a problem, send me the output of the
sqlr-start command and of "ps -efa | grep sqlr" and I'll see if I can
spot the problem.

Dave
dav...@fi...


On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote:
>  
> 
> 
> -- 
> 
> ___________________________________________________
> Play 100s of games for FREE! http://games.mail.com/
> 
> email message attachment
> On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote:
> > Hi,
> > 
> > I am having problem to run queries to access SQL Server 2000 database using SQL Relay. 
> > --------------------------------------
> > I first started the SQL Relay as follows:
> > 
> > sqlr-start -id MyID
> > 
> > It worked fine. But when i tried to run the queries as follow:
> > 
> > sqlrsh -id MyID
> > 
> > SQLRShell - Version 0.22
> >         Connected to: localhost:4000 as ele2006
> > 
> >         type help; for a help.
> > 
> > 0> select * from editorial_tempmaster;
> > Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475
> > 
> > ----------------------------
> > No result was shown.The /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 contains:
> > 
> > 11/11/2005 16:39:10 IST listener [9475] : getting authentication...
> > 
> > 11/11/2005 16:39:10 IST listener [9475] :       listener-based authentication succeeded
> > 
> > 11/11/2005 16:39:10 IST listener [9475] : incrementing session count...
> > 
> > 11/11/2005 16:39:10 IST listener [9475] :       2
> > 
> > ------------------
> > 
> > Please help me!!
> > 
> > --
> > Deepak Mangal
> > 
> >