Re: isql connects, tsql does not

[email protected] Mon, 23 Jan 2012 10:55:19 -0500

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

On Thu, Jan 19, 2012 at 03:02:24PM -0500, [email protected] wrote:

> . You would not see the changing-database message if you weren't allowed to log in.  

My mistake.  tsql produces the message 

	Default database being set to <foo>
	
*before* sending the login packet.  It does that in case the server rejects the login because the user is not authorized to use the database.   (It may or may not do that, depending on a flag in the login packet.)  

I'll change the text of that message to make it clearer.  

The server does send a message, #5701 to be precise, and that message won't arrive until after the login is accepted.  But the message you saw came from tsql.  

HTH.

--jkl