Connectivity Options

[jacksouix]

We are making some changes as we upgrade from SQL Server 6.5 to 2000. We use DSN for connectivity (VB Front end) and need to set Use ANSI Quoted Identifiers and ANSI Nulls, Paddings and Warnings to off....

MS says the client is set to 'on' by default...which is true. Does anyone have a way through SQL to change these options to "off" on the client side?

I'll Hang up and listen
Rod

 

[tlbroadbent]

The SQL commands are:

Set Ansi_warnings Off
Set Quoted_identifer Off
Set Ansi_nulls Off
Set Ansi_padding Off

You should be able to modify the DSN to NOT set the options On. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.