freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Wes Gamble <weyus AT att.net>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Having trouble doing a BULK INSERT
- Date: Mon, 06 Nov 2006 17:26:27 -0600
James,
Interesting. Is OSQL == Query Analyzer? I assume so.
Looks like the odd option out on the Linux box is "CONCAT_NULL_YIELDS_NULL" (value of 256) - which sounds promising.
Can I modify these options for just my session or are they database wide?
Here is some preliminary data:
When you connect with an ODBC client, Microsoft servers automaticallyI get the same values.
set certain connection options. Try these commands on your Windows box:
$ osql -E -S yourserver -Q"select @@options" (I get 5176)
$ isql -E -S yourserver -Q"select @@options" (I get 0)
Then try:I also get 5432 - I get locale of "en-US" and charset of "ISO-8859-1" however
$ printf "select @@options\ngo\n" | tsql -Smpquant -U$U -P$P
locale is "C"
locale charset is "646"
1> 2>
5432
$ printf "select @@options\ngo\n" | bsqldb -Smpquant -U$U -P$PSame
-----------
0
1 rows affected
$ printf "select @@options\ngo\n" | sqsh -Smpquant -U$U -P$PI do not have sqsh on my box.
-----------
5432
The unixODBC isql also returns 5432.Same.
WG
-
[freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
- Re: [freetds] Having trouble doing a BULK INSERT, Wes Gamble, 11/06/2006
- <Possible follow-up(s)>
-
Re: [freetds] Having trouble doing a BULK INSERT,
Lowden, James K, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
- Re: [freetds] Having trouble doing a BULK INSERT, Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Lowden, James K, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Konrad J Hambrick, 11/06/2006
- Re: [freetds] Having trouble doing a BULK INSERT, Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Konrad J Hambrick, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Lowden, James K, 11/07/2006
- Re: [freetds] Having trouble doing a BULK INSERT, Wes Gamble, 11/07/2006
- Re: [freetds] Having trouble doing a BULK INSERT, Wes Gamble, 11/07/2006
-
Re: [freetds] Having trouble doing a BULK INSERT,
Wes Gamble, 11/06/2006
Archive powered by MHonArc 2.6.24.