[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForDat

Could you please explain this error, and a work around?
Thank you.
Mike
Hi
Maybe http://support.microsoft.com/default...b;en-us;246598 will
solve this. What/where is this happening? If you have a specific query that
fails you may want to post it along with DDL and example data.
Other things to try:
Check the SQL Server log and Windows Event log to see if other message
appear when you get this error.
Check you have a recent and complete version of MDAC.
John
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:953DFD7E-06DE-4187-B0EE-0160697BB8E3@.microsoft.com...
> Could you please explain this error, and a work around?
> Thank you.
> --
> Mike

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForDat

Could you please explain this error, and a work around?
Thank you.
--
MikeHi
Maybe http://support.microsoft.com/default.aspx?scid=kb;en-us;246598 will
solve this. What/where is this happening? If you have a specific query that
fails you may want to post it along with DDL and example data.
Other things to try:
Check the SQL Server log and Windows Event log to see if other message
appear when you get this error.
Check you have a recent and complete version of MDAC.
John
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:953DFD7E-06DE-4187-B0EE-0160697BB8E3@.microsoft.com...
> Could you please explain this error, and a work around?
> Thank you.
> --
> Mike

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForDat

Could you please explain this error, and a work around?
Thank you.
--
MikeHi
Maybe http://support.microsoft.com/defaul...kb;en-us;246598 will
solve this. What/where is this happening? If you have a specific query that
fails you may want to post it along with DDL and example data.
Other things to try:
Check the SQL Server log and Windows Event log to see if other message
appear when you get this error.
Check you have a recent and complete version of MDAC.
John
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:953DFD7E-06DE-4187-B0EE-0160697BB8E3@.microsoft.com...
> Could you please explain this error, and a work around?
> Thank you.
> --
> Mike

@@Trancount Error

Take a look a the sql code below. Can anyone explain why @.@.trancount increased to 2 after the 2nd print statement?

SETANSI_DEFAULTSON

GO

PRINT@.@.TRANCOUNT

GO

BEGINTRANSACTION

PRINT@.@.TRANCOUNT

GO

Here is the output I got

0

2

With the ANSI_DEFAULTS you also enable IMPLICIT_TRANSACTIONS. So executing a BEGIN TRAN actually starts a second transaction because your implicit transaction is 'open' although it only returns 1 for @.@.TRANCOUNT when you actually issue a query.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

@@servername

If anybody can explain why for one of my SQL Server2000 servers the statement select @.@.servername returns NULL instead of name?
ThanksThe BOL is incomplete about this subject. Try this microsoft article (http://support.microsoft.com/default.aspx?scid=kb;en-us;303774)

Good luck
Hope this helped|||I'd use:EXECUTE sp_addserver 'desiredServerName', 'LOCAL'-PatP