How to force the use of ODBC-version 2.x in C# applicationHow do I calculate someone's age in C#?What is the difference between String and string in C#?Cast int to enum in C#How do you give a C# Auto-Property a default value?How do I enumerate an enum in C#?What are the correct version numbers for C#?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?Error while connecting to oracle database in windows server 2012Oracle ODBC Connection failedAccess DB ODBC Call Failed
If clocks themselves are based on light signals, wouldn't we expect the measured speed of light to always be the same constant?
Why is there a large performance impact when looping over an array over 240 elements?
Why did Gandalf use a sword against the Balrog?
If "more guns less crime", how do gun advocates explain that the EU has less crime than the US?
Why are Gatwick's runways too close together?
How to remove threat that antivirus program indicates has to be manually deleted?
Loading military units into ships optimally, using backtracking
Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?
ParseJSON using SSJS
First amendment and employment: Can a police department terminate an officer for speech?
How to reduce Sinas Chinam
Why command hierarchy, if the chain of command is standing next to each other?
Can the ground attached to neutral fool a receptacle tester?
Is it legal for a company to enter an agreement not to hire employees from another company?
The cat ate your input again!
A Word/Phrase for the Process of Classifying Something as a Sin
Plotting octahedron inside the sphere and sphere inside the cube
How to remove ambiguity: "... lives in the city of H, the capital of the province of NS, WHERE the unemployment rate is ..."?
Can anybody explain why using multicolumn changes the width of the four-column tabular environment?
Voltage across a resistor
Submitting a new paper just after another was accepted by the same journal
TEMPO: play a (mp3) sound in animated GIF/PDF/SVG
Can a PC use the Levitate spell to avoid movement speed reduction from exhaustion?
How to assign many blockers at the same time?
How to force the use of ODBC-version 2.x in C# application
How do I calculate someone's age in C#?What is the difference between String and string in C#?Cast int to enum in C#How do you give a C# Auto-Property a default value?How do I enumerate an enum in C#?What are the correct version numbers for C#?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?Error while connecting to oracle database in windows server 2012Oracle ODBC Connection failedAccess DB ODBC Call Failed
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Odbc-driver is version 2.x, but in Visual Studio, Version 3.x is used.
Need to somehow force application to use Version 2.x
Right now, there is an error: "The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."
- but finds no way to tell the application to use an other version
Trying to communicate with a Honeywell System.
They are not known for sharing data - but there is a ODBC-driver, written by someone about 15 years ago.
When running on a Windows 2003 server, and compiled (on that same server) in Visual Studio 2005, the application works.
Same application running on other server: Don't work.
Application compiled (x86) on any other machine: Don't work, not on old server, not on new one.
Finds not properties or methods on the System.Data.Odbc.OdbcConnection, to set version of ODBC to use.
At the moment, you get no "error" running the application:
It connects to the dsn, and user is authenticated.
(Changing the username or password gives an error)
- but no data is fetched.
Doing a trace for the calls to the ODBS driver gives:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr). (0)
....
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [HY096] [Honeywell][ODBC Driver]Info type out of range (1043)
....
DIAG [HYC00] [Honeywell][ODBC Driver]Driver not capable (1010)
So, since there is no newer driver to use - I need my application to use ODBC 2.x - but it still uses ODBC 3.x.
c# odbc honeywell
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
add a comment |
Odbc-driver is version 2.x, but in Visual Studio, Version 3.x is used.
Need to somehow force application to use Version 2.x
Right now, there is an error: "The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."
- but finds no way to tell the application to use an other version
Trying to communicate with a Honeywell System.
They are not known for sharing data - but there is a ODBC-driver, written by someone about 15 years ago.
When running on a Windows 2003 server, and compiled (on that same server) in Visual Studio 2005, the application works.
Same application running on other server: Don't work.
Application compiled (x86) on any other machine: Don't work, not on old server, not on new one.
Finds not properties or methods on the System.Data.Odbc.OdbcConnection, to set version of ODBC to use.
At the moment, you get no "error" running the application:
It connects to the dsn, and user is authenticated.
(Changing the username or password gives an error)
- but no data is fetched.
Doing a trace for the calls to the ODBS driver gives:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr). (0)
....
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [HY096] [Honeywell][ODBC Driver]Info type out of range (1043)
....
DIAG [HYC00] [Honeywell][ODBC Driver]Driver not capable (1010)
So, since there is no newer driver to use - I need my application to use ODBC 2.x - but it still uses ODBC 3.x.
c# odbc honeywell
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08
add a comment |
Odbc-driver is version 2.x, but in Visual Studio, Version 3.x is used.
Need to somehow force application to use Version 2.x
Right now, there is an error: "The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."
- but finds no way to tell the application to use an other version
Trying to communicate with a Honeywell System.
They are not known for sharing data - but there is a ODBC-driver, written by someone about 15 years ago.
When running on a Windows 2003 server, and compiled (on that same server) in Visual Studio 2005, the application works.
Same application running on other server: Don't work.
Application compiled (x86) on any other machine: Don't work, not on old server, not on new one.
Finds not properties or methods on the System.Data.Odbc.OdbcConnection, to set version of ODBC to use.
At the moment, you get no "error" running the application:
It connects to the dsn, and user is authenticated.
(Changing the username or password gives an error)
- but no data is fetched.
Doing a trace for the calls to the ODBS driver gives:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr). (0)
....
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [HY096] [Honeywell][ODBC Driver]Info type out of range (1043)
....
DIAG [HYC00] [Honeywell][ODBC Driver]Driver not capable (1010)
So, since there is no newer driver to use - I need my application to use ODBC 2.x - but it still uses ODBC 3.x.
c# odbc honeywell
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
Odbc-driver is version 2.x, but in Visual Studio, Version 3.x is used.
Need to somehow force application to use Version 2.x
Right now, there is an error: "The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)."
- but finds no way to tell the application to use an other version
Trying to communicate with a Honeywell System.
They are not known for sharing data - but there is a ODBC-driver, written by someone about 15 years ago.
When running on a Windows 2003 server, and compiled (on that same server) in Visual Studio 2005, the application works.
Same application running on other server: Don't work.
Application compiled (x86) on any other machine: Don't work, not on old server, not on new one.
Finds not properties or methods on the System.Data.Odbc.OdbcConnection, to set version of ODBC to use.
At the moment, you get no "error" running the application:
It connects to the dsn, and user is authenticated.
(Changing the username or password gives an error)
- but no data is fetched.
Doing a trace for the calls to the ODBS driver gives:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested
(see SQLSetEnvAttr). (0)
....
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (0)
DIAG [HY096] [Honeywell][ODBC Driver]Info type out of range (1043)
....
DIAG [HYC00] [Honeywell][ODBC Driver]Driver not capable (1010)
So, since there is no newer driver to use - I need my application to use ODBC 2.x - but it still uses ODBC 3.x.
c# odbc honeywell
c# odbc honeywell
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
edited Mar 27 at 19:10
TallTed
7,1162 gold badges15 silver badges29 bronze badges
7,1162 gold badges15 silver badges29 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
asked Mar 27 at 9:01
Martin KlarqvistMartin Klarqvist
62 bronze badges
62 bronze badges
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08
add a comment |
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08
add a comment |
1 Answer
1
active
oldest
votes
When you tell VS C# to connect to an ODBC Data Source, it invisibly bridges to ODBC using the Microsoft ADO.NET Provider for ODBC, which wants everything to be as up-to-date as it is.
Your best bet in this situation is to switch to a different ADO.NET Provider that understands you can't always have a new ODBC driver, and will do its best to translate the newer C# ADO.NET API calls to the older ODBC API calls when necessary. My employer offers a couple of options, one being the Enterprise Edition Data Access for ODBC Data Sources, and the other being the Virtuoso Universal Server Enterprise Edition (functioning as a Virtual DBMS), both of which are available for immediate download, with a free temporary license provided for your testing and evaluation.
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f55373262%2fhow-to-force-the-use-of-odbc-version-2-x-in-c-sharp-application%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
When you tell VS C# to connect to an ODBC Data Source, it invisibly bridges to ODBC using the Microsoft ADO.NET Provider for ODBC, which wants everything to be as up-to-date as it is.
Your best bet in this situation is to switch to a different ADO.NET Provider that understands you can't always have a new ODBC driver, and will do its best to translate the newer C# ADO.NET API calls to the older ODBC API calls when necessary. My employer offers a couple of options, one being the Enterprise Edition Data Access for ODBC Data Sources, and the other being the Virtuoso Universal Server Enterprise Edition (functioning as a Virtual DBMS), both of which are available for immediate download, with a free temporary license provided for your testing and evaluation.
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
add a comment |
When you tell VS C# to connect to an ODBC Data Source, it invisibly bridges to ODBC using the Microsoft ADO.NET Provider for ODBC, which wants everything to be as up-to-date as it is.
Your best bet in this situation is to switch to a different ADO.NET Provider that understands you can't always have a new ODBC driver, and will do its best to translate the newer C# ADO.NET API calls to the older ODBC API calls when necessary. My employer offers a couple of options, one being the Enterprise Edition Data Access for ODBC Data Sources, and the other being the Virtuoso Universal Server Enterprise Edition (functioning as a Virtual DBMS), both of which are available for immediate download, with a free temporary license provided for your testing and evaluation.
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
add a comment |
When you tell VS C# to connect to an ODBC Data Source, it invisibly bridges to ODBC using the Microsoft ADO.NET Provider for ODBC, which wants everything to be as up-to-date as it is.
Your best bet in this situation is to switch to a different ADO.NET Provider that understands you can't always have a new ODBC driver, and will do its best to translate the newer C# ADO.NET API calls to the older ODBC API calls when necessary. My employer offers a couple of options, one being the Enterprise Edition Data Access for ODBC Data Sources, and the other being the Virtuoso Universal Server Enterprise Edition (functioning as a Virtual DBMS), both of which are available for immediate download, with a free temporary license provided for your testing and evaluation.
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
When you tell VS C# to connect to an ODBC Data Source, it invisibly bridges to ODBC using the Microsoft ADO.NET Provider for ODBC, which wants everything to be as up-to-date as it is.
Your best bet in this situation is to switch to a different ADO.NET Provider that understands you can't always have a new ODBC driver, and will do its best to translate the newer C# ADO.NET API calls to the older ODBC API calls when necessary. My employer offers a couple of options, one being the Enterprise Edition Data Access for ODBC Data Sources, and the other being the Virtuoso Universal Server Enterprise Edition (functioning as a Virtual DBMS), both of which are available for immediate download, with a free temporary license provided for your testing and evaluation.
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
answered Mar 27 at 19:07
TallTedTallTed
7,1162 gold badges15 silver badges29 bronze badges
7,1162 gold badges15 silver badges29 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f55373262%2fhow-to-force-the-use-of-odbc-version-2-x-in-c-sharp-application%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
You can set the ODBC datasource in Control Panel : Administrative Tools : ODBC Data Source
– jdweng
Mar 27 at 9:08