sql server connect: Hi,

How do I disable in sql server ----- ansi quote identifiers in sql server.
ansi nulls, padding, warnings.

I set up an ODBC connection If I turn these off --- doesn't work , It works
it tehy are checked.

Any ideas?

Thanks

Set up what kind of ODBC connection - where did you set this
up? If it's a DSN, you can turn them on in the ODBC
Administrator applet. When you configure the DSN, it's on
the screen after you select the authentication method.
It's generally better to manage the settings you need from
the client side. A client connection settings for these
override the server settings.
If you wanted to change them at the server level, you can
use sp_configure to change the user options. If you change
the settings at the server level, it will only take affect
for new logins.

-Sue


On Mon, 2 Apr 2007 17:33:53 -0400, "mecn"
[quoted text, click to view]