 | |
BCP.EXE fails in 90 where it succeeded in 80
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
BCP.EXE fails in 90 where it succeeded in 80 -
06-12-2008
, 12:19 PM
#2
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#3
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#4
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#5
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#6
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#7
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#8
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#9
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
#10
| |||
| |||
|
|
I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the temporary table, the application launches BCP.EXE to move the data to the file system). The command line is of the form: bcp "##temptablename...." out "c:\path\tempfilename.bin" -n -S server -q -a 65535 -T In the 8.0 version of the utility there is no problem, the BCP out operation succeeds. But in the 9.0 version I get a series of errors: SQLState = 28000, NativeError = 18456 Error = [Microsoft][SQL Native Client][SQL Server]Login failed for user 'username'. SQLState = IM006, NativeError = 0 Error = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQLState = 42000, NativeError = 4060 Error = [Microsoft][SQL Native Client][SQL Server]Cannot open database "##temptablename..." requested by the login. The login failed. SQLState = IM006, NativeError = 0 Error = [Microsoft][SQL Native Client]Packet size change not supported by server, default used That last error goes away if I take out the "-a 65535" command line option (although the documentation shows this still as a valid option). Any and all help on this issue would be most appreciated! -- TB |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.