Re: Padding using Type 4 Drivers

• Previous message: Jeeji: ""The operation was cancelled at the user's request" error during mass insertions"
• In reply to: Carb Simien [MSFT]: "RE: Padding using Type 4 Drivers"
• Next in thread: Carb Simien [MSFT]: "Re: Padding using Type 4 Drivers"
• Reply: Carb Simien [MSFT]: "Re: Padding using Type 4 Drivers"
• Messages sorted by: [ date ] [ thread ]

Date: 17 Nov 2004 01:38:32 -0800

CarbinoS@online.microsoft.com ("Carb Simien [MSFT]") wrote in message news:<9aT3U$AzEHA.3956@cpmsftngxa10.phx.gbl>...
> --------------------
> Hello,
>
> It is possible that your SQL Server 7 was using a different ANSI_PADDING
> value than what you have set in SQL Server 2000.
>
> Whenever you make a connection to SQL Server, you can specify the ANSI
> settings that you require. If you do not specify these explicitly, then
> your connection will receive a default set of ANSI settings based on the
> configuration in SQL Server. You can use the Security Audit -> Audit Login
> event in SQL Profiler to observe the ANSI settings used when your
> connection is first made. Your Profiler output may look something like
> this:
>
> -- network protocol: TCP/IP
> set quoted_identifier on
> set implicit_transactions off
> set cursor_close_on_commit off
> set ansi_warnings on
> set ansi_padding on
> set ansi_nulls on
> set concat_null_yields_null on
> set language us_english
> set dateformat mdy
> set datefirst 7
>
> These default settings are documented in the SQL Server Books Online under
> the topic "SET"
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
> _set-set_40c4.asp) under the subheading "SQL-92 Settings Statements". You
> can also run DBCC USEROPTIONS from within your connection to see this
> information.
>
> Are you using the Microsoft JDBC driver or a third-party driver?.
>
> Carb Simien, MCSE MCDBA MCAD
> Microsoft Developer Support - Web Data
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

Thanks very much for the information.

We are indeed using a third-party driver as we are not aware of a
Microsoft Type 4 driver which will connect to sql server 7.

We have performed the tests using a weblogic driver and jtds, both
having the same results. The DBA insist that the sql server 7 and sql
server 2000 are configured the same...... but I have my doubts!.

• Previous message: Jeeji: ""The operation was cancelled at the user's request" error during mass insertions"
• In reply to: Carb Simien [MSFT]: "RE: Padding using Type 4 Drivers"
• Next in thread: Carb Simien [MSFT]: "Re: Padding using Type 4 Drivers"
• Reply: Carb Simien [MSFT]: "Re: Padding using Type 4 Drivers"
• Messages sorted by: [ date ] [ thread ]