relationship between set ansi_defaults and set implicit_transactio

BOL States the following in the SET ANSI_DEFAULTS section:
SQL Server ODBC driver automatically set ANSI_DEFAULTS to ON when
connecting. The driver then set CURSOR_CLOSE_ON_COMMIT and
IMPLICIT_TRANSACTIONS to OFF.
BOL States the following in the SET IMPLICIT_TRANSACTIONS:
When SET ANSI_DEFAULTS is ON, SET IMPLICIT_TRANSACTIONS is enabled.
What does SET IMPLICIT_TRANSACTIONS is enabled mean? If it means SET
IMPLICIT_TRANSACTIONS is ON, is this conflicting with the statment in the SE
T
ANSI_DEFAULTS section. Or the setting ANSI_DEFAULTS affects the setting
IMPLICIT_TRANSACTIONS differently based on the source (driver or sql
statement).ANSI_DEFAULT is just a grouping of other SET options, a way to turn on a num
ber of SET options with
one command. Seems like ODBC first turn on ANSI_DEFAULT and then turn off IM
PLICIT_TRANSACTIONS.
This is doable, "turn on all which are in ANSI_DEFAULT but I don't want IMPL
ICIT_TRANSACTIOPNS so I
turn that off explicitly":
DBCC USEROPTIONS
SET ANSI_DEFAULTS ON
GO
DBCC USEROPTIONS
SET IMPLICIT_TRANSACTIONS OFF
GO
DBCC USEROPTIONS
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:AF6843DA-18C9-4980-A25E-55D9FAE003E6@.microsoft.com...
> BOL States the following in the SET ANSI_DEFAULTS section:
> SQL Server ODBC driver automatically set ANSI_DEFAULTS to ON when
> connecting. The driver then set CURSOR_CLOSE_ON_COMMIT and
> IMPLICIT_TRANSACTIONS to OFF.
>
> BOL States the following in the SET IMPLICIT_TRANSACTIONS:
> When SET ANSI_DEFAULTS is ON, SET IMPLICIT_TRANSACTIONS is enabled.
>
> What does SET IMPLICIT_TRANSACTIONS is enabled mean? If it means SET
> IMPLICIT_TRANSACTIONS is ON, is this conflicting with the statment in the
SET
> ANSI_DEFAULTS section. Or the setting ANSI_DEFAULTS affects the setting
> IMPLICIT_TRANSACTIONS differently based on the source (driver or sql
> statement).

reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
David

reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
Davidsql

Reinstall ODBC Components

I'm getting the following error on my XP machine:
The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
components to ensure proper operation.
I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
components?
Thank youReinstall MDAC. Reinstalling SQL Server 7 won't update MDAC
as XP is on a higher version. You can also check your
current MDAC installation with component checker
You can find the MDAC downloads and component checker at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Wed, 10 Nov 2004 16:24:01 -0800, "Michelle"
<Michelle@.discussions.microsoft.com> wrote:

>I'm getting the following error on my XP machine:
>The ODBC resource DLL c:\windows\system32\odbcint.dll is a different versio
n
>than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
>components to ensure proper operation.
>I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
>components?
>Thank you

Reinstall ODBC Components

I'm getting the following error on my XP machine:
The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
components to ensure proper operation.
I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
components?
Thank you
Reinstall MDAC. Reinstalling SQL Server 7 won't update MDAC
as XP is on a higher version. You can also check your
current MDAC installation with component checker
You can find the MDAC downloads and component checker at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Wed, 10 Nov 2004 16:24:01 -0800, "Michelle"
<Michelle@.discussions.microsoft.com> wrote:

>I'm getting the following error on my XP machine:
>The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
>than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
>components to ensure proper operation.
>I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
>components?
>Thank you