tsql Error 100 (severity 11): unrecognized msgno

Perl_to_SQL_Server <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi,

New to FreeTDS, I've got my first successfull query from the Linux tsql command-
line, WOO-HOO !!!

Now before the rewarding:

1>

prompt, I've got what seems a benign:

Error 100 (severity 11): unrecognized msgno

I'll research the threads some more but THANKS if someone can already hint 
towards the right direction..

Recommendations for improving the FreeTDS installation documentation, which 
assumes (user exposure to all Unix/Linux things) a slight tad too much:

1) For a good while all my tsql connections attempts were unsucssessful. I was 
actually modifying the wrong freetds.conf, the one from extracting the fresh 
freeTDS download.. it's probably obvious for regular Unix/Linux installers that 
it's:

etc/freetds.conf 

not:

freetds-0.91/freetds.conf

that tsql reads, but nonetheless an easy possible pitfall for less seasonned 
users.. I only discovered about etc/freetds.conf after issuing a find -
name "freetds.conf" 

2) since there was mention of root user to be able to 'make install' in the 
default /usr/local directory, somehow I related that to the -U of a:

tsql -S egOurServer -U user

as would be user on my Linux box, like if tsql needed some 'su' permissions for 
the client to proceed or something.. I didn't get at first that it was actually 
the authentication for SQL Server already.. I thought that this piece would 
come later. So I had ended-up removing the -U option actually and was satisfied 
not to get the prompt anymore! There too it becomes really obvious once you've 
got all things working and well rounded, but an easy pitfall before that.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.