bcp: dsn specified an unsupported driverInformatica Source Qualifier not working from Windows ODBC data...
Could a US political party gain complete control over the government by removing checks & balances?
Are cabin dividers used to "hide" the flex of the airplane?
What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?
Re-submission of rejected manuscript without informing co-authors
Hosting Wordpress in a EC2 Load Balanced Instance
Symmetry in quantum mechanics
Domain expired, GoDaddy holds it and is asking more money
"listening to me about as much as you're listening to this pole here"
What's the difference between repeating elections every few years and repeating a referendum after a few years?
Prime joint compound before latex paint?
What does it exactly mean if a random variable follows a distribution
How would photo IDs work for shapeshifters?
What are the advantages and disadvantages of running one shots compared to campaigns?
aging parents with no investments
"My colleague's body is amazing"
What does "enim et" mean?
Where to refill my bottle in India?
What is the offset in a seaplane's hull?
Add an angle to a sphere
Is there a way to make member function NOT callable from constructor?
What do you call words made from common English words?
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
Why is the design of haulage companies so “special”?
Is there a name of the flying bionic bird?
bcp: dsn specified an unsupported driver
Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx fileZero Rows return on querying DMV sys.dm_os_performance_countersConnecting to SQL Server 2014 with sqlcmdHow do I guarantee using Microsoft ODBC Driver 13 for SQL Server in a linked server?Use last inserted ID in another tableLinked Server ODBC statement missing delimiters on reserved identifierbcp command Incorrect syntax near '�'. Character is actually: “ä”Cosmos DB ODBC driver installation problemExporting to Excel from SQL Server - BCP Using a Stored Procedure Headers not shownODBC Driver for Salesforce: Access Linked Server Object in SSMS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
A straight-forward call to bcp works on linux and not on windows.
Ubuntu
~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
Starting copy...
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 78 Average : (12.8 rows per sec.)
~$ cat foo.csv
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64)
Jul 5 2017 23:41:17
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
~$ /opt/mssql-tools/bin/bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 17.3.0000.1
Windows
C:> bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
The DSN specified an unsupported driver.
C:> bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 15.0.1000.34
Both ODBC configurations are using the native "ODBC Driver 17 for SQL Server" drivers. Both are reaching out to the same IP address and port. On both, I can use ODBC/DSN for other non-bulk queries, so it is not a network thing. On windows, bcp works fine when not using -D, as in -S ipaddr,port notation.
- I cannot find a newer version of
bcpfor windows, currently listed here as 15.0: https://docs.microsoft.com/en-us/sql/tools/bcp-utility. - I have tried configuring both a 32-bit and 64-bit ODBC connections using the same connection parameters. (This shouldn't matter, though, since the same DSN is working for regular ODBC operations, just not with
bcp.) - I cannot use
-T(network restrictions).
When I try a similar connection with sqlcmd:
C:> sqlcmd -d mydb -D -S mydsn -U myser -P '...'
Sqlcmd: Warning: '-D' is an obsolete option and is ignored
and removing the -D fails (server not found).
Windows is win10, 64bit, build 1809.
What am I missing?
sql-server windows odbc bcp
asked 2 hours ago
r2evansr2evans
1063
add a comment |
A straight-forward call to bcp works on linux and not on windows.
Ubuntu
~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
Starting copy...
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 78 Average : (12.8 rows per sec.)
~$ cat foo.csv
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64)
Jul 5 2017 23:41:17
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
~$ /opt/mssql-tools/bin/bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 17.3.0000.1
Windows
C:> bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
The DSN specified an unsupported driver.
C:> bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 15.0.1000.34
Both ODBC configurations are using the native "ODBC Driver 17 for SQL Server" drivers. Both are reaching out to the same IP address and port. On both, I can use ODBC/DSN for other non-bulk queries, so it is not a network thing. On windows, bcp works fine when not using -D, as in -S ipaddr,port notation.
- I cannot find a newer version of
bcpfor windows, currently listed here as 15.0: https://docs.microsoft.com/en-us/sql/tools/bcp-utility. - I have tried configuring both a 32-bit and 64-bit ODBC connections using the same connection parameters. (This shouldn't matter, though, since the same DSN is working for regular ODBC operations, just not with
bcp.) - I cannot use
-T(network restrictions).
When I try a similar connection with sqlcmd:
C:> sqlcmd -d mydb -D -S mydsn -U myser -P '...'
Sqlcmd: Warning: '-D' is an obsolete option and is ignored
and removing the -D fails (server not found).
Windows is win10, 64bit, build 1809.
What am I missing?
sql-server windows odbc bcp
asked 2 hours ago
r2evansr2evans
1063
add a comment |
A straight-forward call to bcp works on linux and not on windows.
Ubuntu
~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
Starting copy...
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 78 Average : (12.8 rows per sec.)
~$ cat foo.csv
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64)
Jul 5 2017 23:41:17
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
~$ /opt/mssql-tools/bin/bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 17.3.0000.1
Windows
C:> bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
The DSN specified an unsupported driver.
C:> bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 15.0.1000.34
Both ODBC configurations are using the native "ODBC Driver 17 for SQL Server" drivers. Both are reaching out to the same IP address and port. On both, I can use ODBC/DSN for other non-bulk queries, so it is not a network thing. On windows, bcp works fine when not using -D, as in -S ipaddr,port notation.
- I cannot find a newer version of
bcpfor windows, currently listed here as 15.0: https://docs.microsoft.com/en-us/sql/tools/bcp-utility. - I have tried configuring both a 32-bit and 64-bit ODBC connections using the same connection parameters. (This shouldn't matter, though, since the same DSN is working for regular ODBC operations, just not with
bcp.) - I cannot use
-T(network restrictions).
When I try a similar connection with sqlcmd:
C:> sqlcmd -d mydb -D -S mydsn -U myser -P '...'
Sqlcmd: Warning: '-D' is an obsolete option and is ignored
and removing the -D fails (server not found).
Windows is win10, 64bit, build 1809.
What am I missing?
sql-server windows odbc bcp
asked 2 hours ago
r2evansr2evans
1063
A straight-forward call to bcp works on linux and not on windows.
Ubuntu
~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
Starting copy...
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 78 Average : (12.8 rows per sec.)
~$ cat foo.csv
Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64)
Jul 5 2017 23:41:17
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
~$ /opt/mssql-tools/bin/bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 17.3.0000.1
Windows
C:> bcp "select @@version as v" queryout foo.csv
-D -S mydsn -c -U myuser -t, -r 'n' -P '...'
The DSN specified an unsupported driver.
C:> bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 15.0.1000.34
Both ODBC configurations are using the native "ODBC Driver 17 for SQL Server" drivers. Both are reaching out to the same IP address and port. On both, I can use ODBC/DSN for other non-bulk queries, so it is not a network thing. On windows, bcp works fine when not using -D, as in -S ipaddr,port notation.
- I cannot find a newer version of
bcpfor windows, currently listed here as 15.0: https://docs.microsoft.com/en-us/sql/tools/bcp-utility. - I have tried configuring both a 32-bit and 64-bit ODBC connections using the same connection parameters. (This shouldn't matter, though, since the same DSN is working for regular ODBC operations, just not with
bcp.) - I cannot use
-T(network restrictions).
When I try a similar connection with sqlcmd:
C:> sqlcmd -d mydb -D -S mydsn -U myser -P '...'
Sqlcmd: Warning: '-D' is an obsolete option and is ignored
and removing the -D fails (server not found).
Windows is win10, 64bit, build 1809.
What am I missing?
sql-server windows odbc bcp
sql-server windows odbc bcp
asked 2 hours ago
r2evansr2evans
1063
asked 2 hours ago
r2evansr2evans
1063
edited 2 hours ago
r2evans
asked 2 hours ago
r2evansr2evans
1063
asked 2 hours ago
r2evansr2evans
1063
asked 2 hours ago
r2evansr2evans
1063
1063
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234247%2fbcp-dsn-specified-an-unsupported-driver%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234247%2fbcp-dsn-specified-an-unsupported-driver%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
