SQL Server Error "changed database context"

[Timothy Mallon]

Hello

When I try to connect to SQL server from a Smalltalk ODBC interface, I get
the following error messages back:

'01000: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database
context to ''dbfoo''.' '01000: [Microsoft][ODBC SQL Server Driver][SQL
Server]Changed language setting to ''us_english''.'

'S1010: [Microsoft][ODBC Driver Manager] Function sequence error'

I'm puzzled. I am not making any explicit changes to the database context.
I'm able to make this connection through RDO without any problem.

How can I fix this?

Thanks in advance.

Tim

[Andy Cohen]

It sounds like you may have two separate problems:

First, you're surprised to see these two error messages:

>'01000: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database
context to ''dbfoo''.'
>'01000: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language
setting to ''us_english''.'

These two messages are purely informational, and should be ignored. They
have always been generated by the SQL Server, but your previous tools must
have hidden them from you. It's true that you have not explicitly changed
either the database context or the language setting - these messages are
being emitted to tell you application what its initial database-context and
language settings are.

Secondly, you're getting this error:

>'S1010: [Microsoft][ODBC Driver Manager] Function sequence error'

I don't believe this message is related to the first two. Is it possible
that your Smalltalk application is, indeed, calling functions in an
inappropriate order, perhaps in an attempt to respond to those first two
messages?

Good luck,

Andy Cohen
Tilden Park Software
aco...@tildenpark.com
www.tildenpark.com

[Howard Ackerman]

Timothy Mallon <tma...@brobeck.com> wrote in article
<01bdf20c$cea6a900$b74ba8c0@6lmjf>...

>
> '01000: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database
> context to ''dbfoo''.' '01000: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Changed language setting to ''us_english''.'
>

01000 is a "Driver-specific informational message. (Function returns
SQL_SUCCESS_WITH_INFO)" - from the ODBC Programmer's Reference on a
SQLConnect/SQLBrowseConnect.

The database change/language setting happen automatically on the connect
and are returned by the ODBC driver as informational messages.

Being nothing more than an informational message, your application can
safely ignore them.

> 'S1010: [Microsoft][ODBC Driver Manager] Function sequence error'
>

What are you doing after your login/connect? That is most likely the
culprit causing the S1010 (Generally, the specified hstmt was not in an
appropriate state for the function you are trying to execute).