BCP via Linux Centos 7, cannot connect to Azure SQL
0
votes
1
answer
494
views
I installed sqlcmd, bcp and odbc 17 for microsoft.
then I connected to Azure SQL with SQLCMD - it worked OK
then I tried to import some data with BCP and i got an error
I use:
bcp schema.table_name in "path to csv file" -S example.database.windows.net -U user_name -P "password" -d schema -c -t ','
SQLState = 28000, NativeError = 18456
Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'user_name'.
SQLState = 01S00, NativeError = 0
Warning = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute
My passwords contaains ] % ; , is it could be a problem?
**Update:**
The issue is that when I use SQLCMD unixODBC uses {} to escape password and it works OK, but when BCP uses unixODBC password is not escaped.
**SQL CMD**
[ODBC][1530961370.439037][SQLDriverConnectW.c]
Entry:
Connection = 0x1b56e20
Window Hdl = (nil)
Str In = [DRIVER={ODBC Driver 17 for SQL Server};SERVER={example.database.windows.net};UID={user_name};PWD={password};WSID={ADCSrv...][length = 145 (SQL_NTS)]
Str Out = (nil)
Str Out Max = 0
Str Out Ptr = (nil)
Completion = 0
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
**BCP**
[ODBC][1530962482.429621][SQLDriverConnect.c]
Entry:
Connection = 0xcb4ef0
Window Hdl = (nil)
Str In = [DRIVER={ODBC Driver 17 for SQL Server};server=example.database.windows.net;UID=user_name;PWD=password][length = 109 (SQL_NTS)]
Str Out = 0x7fff5397ce70
Str Out Max = 2048
Str Out Ptr = (nil)
Completion = 0
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
How to fix that? I think about creating a DNS
Asked by Vadzim Nemchenko
(88 rep)
Jul 7, 2018, 11:02 AM
Last activity: Jul 8, 2018, 08:30 AM
Last activity: Jul 8, 2018, 08:30 AM