[freetds] Having trouble doing a BULK INSERT
Wes Gamble
weyus at att.net
Mon Nov 6 18:26:27 EST 2006
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 automatically
>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)
>
>
>
I get the same values.
>Then try:
>
>$ printf "select @@options\ngo\n" | tsql -Smpquant -U$U -P$P
>locale is "C"
>locale charset is "646"
>1> 2>
>5432
>
>
I also get 5432 - I get locale of "en-US" and charset of "ISO-8859-1"
however
>$ printf "select @@options\ngo\n" | bsqldb -Smpquant -U$U -P$P
>
>-----------
> 0
>1 rows affected
>
>
Same
>$ printf "select @@options\ngo\n" | sqsh -Smpquant -U$U -P$P
>
> -----------
> 5432
>
>
>
I do not have sqsh on my box.
>The unixODBC isql also returns 5432.
>
>
>
Same.
WG
More information about the FreeTDS
mailing list