tsql should return results if everything is configured right. You
might need to type
go;
after your SQL statement. Also, I use Version 7.0 with MS SQL Server
2000. I don't know if it will make a difference.
nsfreetds is very version dependent on freetds. Dossy might be able
to get you an older version that worked with that freetds version. I
have butchered it to work with a 6.4 development snapshot and that's
what I use.
Good luck!
- Ian
On 5/25/05, Cory Grimster <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'm having trouble getting nsfreetds running, and I'm hoping that
> someone can spot what I'm doing wrong. I noticed that several people on
> the list have gotten it working at various times, so I assume it's just me.
>
> I'm using nsfreetds 0.4 with FreeTDS 0.6.1.2 (newer versions of FreeTDS
> won't compile on this server) and AOLserver 4.0.10
> running on Mandrake 10.0. I'm trying to connect to Microsoft SQLServer
> Desktop Engine 2000 SP4 running on my Windows XP workstation. I'm
> getting the "could not allocate a handle from database pool "pool4""
> error page when I hit my site.
>
> I can connect to the SQL server with tsql, though it doesn't give me any
> output when I type in SQL commands. Not sure what that's about.
> Authentication works fine, and it rejects me if I don't give it the
> correct credentials. Anyway, I'm assuming that it works for now and am
> trying to get nsfreetds working.
>
> The relevent sections from my config.tcl (copied from the nsfreetds FAQ)
> are as follows:
>
> ns_section ns/db/drivers
> ns_param freetds ${bindir}/nsfreetds.so
>
> ns_section ns/db/pools
> ns_param pool4 "FreeTDS Pool"
>
> ns_section ns/db/pool/pool4
> ns_param maxidle 1000000000
> ns_param maxopen 1000000000
> ns_param connections 5
> ns_param verbose $debug
> ns_param extendedtableinfo true
> ns_param logsqlerrors $debug
>
> ns_param driver freetds
> ns_param datasource fooserver [also tried fooserver:bardb]
> ns_param user sa
> ns_param password bazpassword
>
> ns_section ns/server/${server}/db
> ns_param pools "*"
> ns_param defaultpool pool4
>
> I have the SYBASE environment variable set to /usr/local/etc, which is
> where my interfaces file lives. It looks like this:
>
> fooserver
> query tcp 8.0 192.168.42.107 1433 [I have tried protocol version
> 4.2 instead of 8.0 and it makes no difference]
>
> Hopefully someone can point me in the right direction. I've been
> banging my head against it for a few days now and I'm afraid that I'm
> missing something obvious but am at a loss as to what it might be.
>
> Thanks in advance,
>
> -Cory
>
>
> --
> AOLserver - http://www.aolserver.com/
>
> To Remove yourself from this list, simply send an email to <[EMAIL
> PROTECTED]> with the
> body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
> field of your email blank.
>
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
