Sample Header Ad - 728x90

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