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 Free
On 2005.05.25, Cory Grimster <[EMAIL PROTECTED]> wrote:
> 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 ma
Try newest FreeTDS 0.63 with my modified nsfreetds driver.
http://cvs.sourceforge.net/viewcvs.py/naviserver/modules/nsfreetds/
It does not support interfaces anymore, use freetds.conf and describe
datasource there.
nsd.tcl
ns_section "ns/db/pool/cbill"
ns_paramdriver
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 old
Actually the example freetds.conf file uses "tds version = 8.0" for
Microsoft SQL Server 2000. But I understand that version 4.2 is the
most stable and I'll use that while I'm trying to get it running.
At any rate, changing the protocol version to 4.2 in the interfaces file
hasn't changed my sit
Humm
What is the difference between naviserver and aolserver... ?
/Xavier
Le 25 mai 05 à 20:25, Vlad Seryakov a écrit :
Try newest FreeTDS 0.63 with my modified nsfreetds driver.
http://cvs.sourceforge.net/viewcvs.py/naviserver/modules/nsfreetds/
It does not support interfaces anymore, u
It is a fork, see ChangeLog for more info, no website or any formal info
at this point yet.
Xavier Beaudouin wrote:
Humm
What is the difference between naviserver and aolserver... ?
/Xavier
Le 25 mai 05 à 20:25, Vlad Seryakov a écrit :
Try newest FreeTDS 0.63 with my modified nsfreetds
I've tried FreeTDS 0.63 with Vlad's modified version of nsfreetds and am
still getting a database configuration error page, this time telling me
that ACS "could not determine the RDBMS type associated with pool "pool4".".
FreeTDS itself is configured correctly; after following Ian's advice
(thank
Do you have any errors at the server startup associated with nsfreetds?
Also, every time i open nsdb with freetds, i issue "use database" to
open appropriate
SQL server database to use.
Cory Grimster wrote:
I've tried FreeTDS 0.63 with Vlad's modified version of nsfreetds and am
still getting a
Vlad,
I installed 0.63 and compiled and installed your module.
It seems to work fine, but has a glitch I ran into as well which is
that it doesn't return error codes when something went wrong with the
query itself. For example, with my hack I get this
SQL:
SELECT cast('foo' as int)
Result
ndsfreetds.so seems to load fine:
Notice: Db_DriverInit(freetds): Loaded FreeTDS Driver v0.5, freetds v0.63
It looks like the server is able to connect to the database, but
something goes wrong after that:
Notice: dbdrv: opening database 'freetds:fooserver'
Notice: Db_Msg_Handler(osaka): Chang
Why msg_level > 10, why 10, and not 0?
Ian Harding wrote:
Vlad,
I installed 0.63 and compiled and installed your module.
It seems to work fine, but has a glitch I ran into as well which is
that it doesn't return error codes when something went wrong with the
query itself. For example, with my
Who is logging this message, i could not find it in FReeTDS and AS?
Is this your application?
Notice: Database API: couldn't determine RDBMS type of database pool
"pool4".
Cory Grimster wrote:
ndsfreetds.so seems to load fine:
Notice: Db_DriverInit(freetds): Loaded FreeTDS Driver v0.5, freetds
I think this is from ACS or OpenACS which try to figure out what what
database is being used and call ns_oracle, ns_postgres, etc. instead
of ns_db.
Vlad Seryakov wrote:
Who is logging this message, i could not find it in FReeTDS and AS?
Is this your application?
Notice: Database API: couldn't d
>10 indicates a critical error.
On 5/25/05, Vlad Seryakov <[EMAIL PROTECTED]> wrote:
> Why msg_level > 10, why 10, and not 0?
>
> Ian Harding wrote:
> > Vlad,
> >
> > I installed 0.63 and compiled and installed your module.
> >
> > It seems to work fine, but has a glitch I ran into as well which i
Sorry, that was not really right.
"The severity level of an error message provides an indication of the
type of problem that Microsoft(r) SQL Server™ 2000 has encountered.
Severity level 10 messages are informational and indicate problems
caused by mistakes in the information you have entered.
Thank you, i was experimenting yesterday and i think i got it working
right, but with 0.64+ version.
With versions 0.63+ DB_Cancel should call
tds_process_simple_query to clear pending results, tds_freeall_resulst
does not do this.
Ian Harding wrote:
Sorry, that was not really right.
"The sever
That's right. I found the line in the ACS bootstrapper that checks out
all your database pools, and it is throwing the error.
I tried to access the freetds database using the ns_db API and it works
:) The ACS problems are another issue entirely. nsfreetds itself is
working.
Thanks very much t
It seems to work great. I will test it a bit more and see if it fixes
my other problem, which has to do with Sybase and connection timeouts.
The first attempt at a query after connection timeout crashes
AOLServer. I can live with that, but hope it goes away! We are
leaving Sybase this summer an
Just out of curiosity, what is the advantage of using nsfreetds for Sybase
over the "real" sybase driver?
Cheers,
Bas.
--
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 messa
"real" sybase driver is external driver working via db proxy, much
slower and spawns separate process for every new DB connection.
Bas Scheffers wrote:
Just out of curiosity, what is the advantage of using nsfreetds for Sybase
over the "real" sybase driver?
Cheers,
Bas.
--
AOLserver - http://
And drawbacks? Like compatibility, reliability?
Vlad Seryakov said:
> "real" sybase driver is external driver working via db proxy, much
> slower and spawns separate process for every new DB connection.
>
> Bas Scheffers wrote:
>> Just out of curiosity, what is the advantage of using nsfreetds for
We used to run native sybase driver using proxy a while ago then
switched to nsfreetds. It used to run fine, but it did not support MS
SQL servers, so nsfreetds was the only choice. Now we've been using
nsfreetds for several years with MS SQL 2000.
Bas Scheffers wrote:
And drawbacks? Like compat
Vlad,
I am crosssposting to freetds.
I use a Sybase server that times out connections after a certain
amount of time. Whenever this happens, the nsfreetds handle becomes
useless as you can see in the TDS dump. The sequence of events was,
issue query, break connection, issue query, issue query.
OK, I got nsfreetds to do what I want it to do, but with a seeming
clumsy hack. I honestly don't have any idea what I am doing.
MSSQL Server, using TDS 7.0 works great when a database connection
goes dead. Sybase, using TDS 4.2 does not. It merrily goes on trying
to talk to the server over the
I know this is a late followup, but I was just reading up on
sybase/aolserver connectivity and came across this thread.
Are you saying that you are trying to run ACS/OpenACS on Sybase/MSSQL ?
Classic ACS only runs on Oracle 8 and OpenACS only runs on Postgresql
7.x or Oracle 8/9 (exact vers
I don't think anyone said anything about ACS nsfreetds is an
AOLServer module.
On 8/25/05, Mark Aufflick <[EMAIL PROTECTED]> wrote:
> I know this is a late followup, but I was just reading up on
> sybase/aolserver connectivity and came across this thread.
>
> Are you saying that you are tryi
One more thing I just ran into
I have a sybase function that I call with CALL keyword. It does a few
updates, and returns. After each update within the function, freetds
client receives a TDS_DONEINPROC_RESULT token. The way nsfreetds is
written right now, the system seems to wait forever a
tds to build against FreeTDS 0.53, which is
the latest stable FreeTDS release.
nsfreetds-0.2 can be gotten from:
http://panoptic.com/wiki/aolserver/nsfreetds
Or, directly from:
http://ftp.panoptic.com/pub/nsfreetds-v0_2.tar.gz
If you were using the 0.1-pre driver, I strongly urge you to
u
as well as fixed nsfreetds to build against FreeTDS 0.53, which is
the latest stable FreeTDS release.
nsfreetds-0.2 can be gotten from:
http://panoptic.com/wiki/aolserver/nsfreetds
Or, directly from:
http://ftp.panoptic.com/pub/nsfreetds-v0_2.tar.gz
If you were using the 0.1-pre driver,
On 2002.06.04, Ian Harding <[EMAIL PROTECTED]> wrote:
> I have played with it and will start using it in production as soon as
> our Sybase gets upgraded (this summer).
Cool, let me know how it goes!
Otherwise, how have things been? Haven't heard from you in ages!
-- Dossy
--
Dossy Shiobara
both x86 Linux
and SPARC Solaris 2.6, connecting to Sybase 11 running on SPARC
Solaris 2.6, and Microsoft SQL Server 7 and 2000 running on both
WinNT 4.0 and Win2000.
The home for nsfreetds is at:
http://panoptic.com/wiki/aolserver/nsfreetds
nsfreetds-0.1pre is available at:
ftp
32 matches
Mail list logo