ORA-01019 under Win 8.1 / Server 2012 R2, ODBC ExcelODBC connection to SQL Server through firewallAccess to SQL 2008 Server with ODBCHow do I get this SQL Server ODBC Connection working?Native SQL Server connection vs ODBC?Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 errorOracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection ProblemsCan I run Excel 2010 on a server?Excel users get error message when opening files located on Windows serverHow can I delete this ODBC?Windows 2003 R2 Missing mapped drives under ODBC Administrator
How is it possible that Gollum speaks Westron?
How do photons get into the eyes?
If Boris Johnson were prosecuted and convicted of lying about Brexit, can that be used to cancel Brexit?
Why is the relationship between frequency and pitch exponential?
Did thousands of women die every year due to illegal abortions before Roe v. Wade?
Bent spoke design wheels — feasible?
Will TSA allow me to carry a Continuous Positive Airway Pressure (CPAP)/sleep apnea device?
Credit card offering 0.5 miles for every cent rounded up. Too good to be true?
What can plausibly explain many of my very long and low-tech bridges?
What is the right way to float a home lab?
How were concentration and extermination camp guards recruited?
Sharing one invocation list between multiple events on the same object in C#
In this example, which path would a monster affected by the Dissonant Whispers spell take?
Count down from 0 to 5 seconds and repeat
Can Green-Flame Blade be cast twice with the Hunter ranger's Horde Breaker ability?
Did Darth Vader wear the same suit for 20+ years?
How can Iron Man's suit withstand this?
Incremental Ranges!
What happened to all the nuclear material being smuggled after the fall of the USSR?
How do I write "Show, Don't Tell" as an Asperger
Short story written from alien perspective with this line: "It's too bright to look at, so they don't"
What risks are there when you clear your cookies instead of logging off?
Who operates delivery flights for commercial airlines?
Is there any word or phrase for negative bearing?
ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel
ODBC connection to SQL Server through firewallAccess to SQL 2008 Server with ODBCHow do I get this SQL Server ODBC Connection working?Native SQL Server connection vs ODBC?Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 errorOracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection ProblemsCan I run Excel 2010 on a server?Excel users get error message when opening files located on Windows serverHow can I delete this ODBC?Windows 2003 R2 Missing mapped drives under ODBC Administrator
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1.
We are having the same issue under Windows Server 2012 R2. We have tried several Oracle instant client versions and providers, but all of them gives us ORA-01019.
But everything is working as fine as it can under Win 7 and 2k8 R2 with Office 2010 32bit and both Office 2013 32bit.
Enviromental variables are properly set.
What could we do?
thanks Ewert
windows oracle odbc microsoft-excel
asked Jul 10 '14 at 11:39
EwertEwert
54
add a comment |
We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1.
We are having the same issue under Windows Server 2012 R2. We have tried several Oracle instant client versions and providers, but all of them gives us ORA-01019.
But everything is working as fine as it can under Win 7 and 2k8 R2 with Office 2010 32bit and both Office 2013 32bit.
Enviromental variables are properly set.
What could we do?
thanks Ewert
windows oracle odbc microsoft-excel
asked Jul 10 '14 at 11:39
EwertEwert
54
add a comment |
We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1.
We are having the same issue under Windows Server 2012 R2. We have tried several Oracle instant client versions and providers, but all of them gives us ORA-01019.
But everything is working as fine as it can under Win 7 and 2k8 R2 with Office 2010 32bit and both Office 2013 32bit.
Enviromental variables are properly set.
What could we do?
thanks Ewert
windows oracle odbc microsoft-excel
asked Jul 10 '14 at 11:39
EwertEwert
54
We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1.
We are having the same issue under Windows Server 2012 R2. We have tried several Oracle instant client versions and providers, but all of them gives us ORA-01019.
But everything is working as fine as it can under Win 7 and 2k8 R2 with Office 2010 32bit and both Office 2013 32bit.
Enviromental variables are properly set.
What could we do?
thanks Ewert
windows oracle odbc microsoft-excel
windows oracle odbc microsoft-excel
asked Jul 10 '14 at 11:39
EwertEwert
54
asked Jul 10 '14 at 11:39
EwertEwert
54
asked Jul 10 '14 at 11:39
EwertEwert
54
asked Jul 10 '14 at 11:39
EwertEwert
54
asked Jul 10 '14 at 11:39
EwertEwert
54
54
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
No idea about the root cause, I'm just proposing a very ugly workaround: intermediary database with dblink. So, just an empty stub database with a dblink to the old database.
Install some very basic database (perhaps free, like Oracle XE) and CREATE PUBLIC DATABASE LINK my_old_db there. Use the version that is compatible with your Win8, no idea, but perhaps Oracle 11.2 would do. The database would not hold any data, it just acts as a passthrough. Oracle 11.2 can dblink to Oracle 9.2.
Gather every useful table/view/whatnot name in the schema that you previously connected to using SELECT * FROM user_objects; and for each define: CREATE PUBLIC SYNONYM my_table AS my_table@my_old_db. This way if you connect to the passthrough database, and you can perform your selects and see the data of the old database.
If Excel is also querying other schemas, it might be best to slightly change the macros and where you have had SELECT a, b, c FROM sue.her_table you could put SELECT a, b, c FROM sue.her_table@my_old_db . This is because defining synonyms in multiple schemas would be much more complicated and error-prone.
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f611549%2fora-01019-under-win-8-1-server-2012-r2-odbc-excel%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
No idea about the root cause, I'm just proposing a very ugly workaround: intermediary database with dblink. So, just an empty stub database with a dblink to the old database.
Install some very basic database (perhaps free, like Oracle XE) and CREATE PUBLIC DATABASE LINK my_old_db there. Use the version that is compatible with your Win8, no idea, but perhaps Oracle 11.2 would do. The database would not hold any data, it just acts as a passthrough. Oracle 11.2 can dblink to Oracle 9.2.
Gather every useful table/view/whatnot name in the schema that you previously connected to using SELECT * FROM user_objects; and for each define: CREATE PUBLIC SYNONYM my_table AS my_table@my_old_db. This way if you connect to the passthrough database, and you can perform your selects and see the data of the old database.
If Excel is also querying other schemas, it might be best to slightly change the macros and where you have had SELECT a, b, c FROM sue.her_table you could put SELECT a, b, c FROM sue.her_table@my_old_db . This is because defining synonyms in multiple schemas would be much more complicated and error-prone.
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
add a comment |
No idea about the root cause, I'm just proposing a very ugly workaround: intermediary database with dblink. So, just an empty stub database with a dblink to the old database.
Install some very basic database (perhaps free, like Oracle XE) and CREATE PUBLIC DATABASE LINK my_old_db there. Use the version that is compatible with your Win8, no idea, but perhaps Oracle 11.2 would do. The database would not hold any data, it just acts as a passthrough. Oracle 11.2 can dblink to Oracle 9.2.
Gather every useful table/view/whatnot name in the schema that you previously connected to using SELECT * FROM user_objects; and for each define: CREATE PUBLIC SYNONYM my_table AS my_table@my_old_db. This way if you connect to the passthrough database, and you can perform your selects and see the data of the old database.
If Excel is also querying other schemas, it might be best to slightly change the macros and where you have had SELECT a, b, c FROM sue.her_table you could put SELECT a, b, c FROM sue.her_table@my_old_db . This is because defining synonyms in multiple schemas would be much more complicated and error-prone.
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
add a comment |
No idea about the root cause, I'm just proposing a very ugly workaround: intermediary database with dblink. So, just an empty stub database with a dblink to the old database.
Install some very basic database (perhaps free, like Oracle XE) and CREATE PUBLIC DATABASE LINK my_old_db there. Use the version that is compatible with your Win8, no idea, but perhaps Oracle 11.2 would do. The database would not hold any data, it just acts as a passthrough. Oracle 11.2 can dblink to Oracle 9.2.
Gather every useful table/view/whatnot name in the schema that you previously connected to using SELECT * FROM user_objects; and for each define: CREATE PUBLIC SYNONYM my_table AS my_table@my_old_db. This way if you connect to the passthrough database, and you can perform your selects and see the data of the old database.
If Excel is also querying other schemas, it might be best to slightly change the macros and where you have had SELECT a, b, c FROM sue.her_table you could put SELECT a, b, c FROM sue.her_table@my_old_db . This is because defining synonyms in multiple schemas would be much more complicated and error-prone.
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
No idea about the root cause, I'm just proposing a very ugly workaround: intermediary database with dblink. So, just an empty stub database with a dblink to the old database.
Install some very basic database (perhaps free, like Oracle XE) and CREATE PUBLIC DATABASE LINK my_old_db there. Use the version that is compatible with your Win8, no idea, but perhaps Oracle 11.2 would do. The database would not hold any data, it just acts as a passthrough. Oracle 11.2 can dblink to Oracle 9.2.
Gather every useful table/view/whatnot name in the schema that you previously connected to using SELECT * FROM user_objects; and for each define: CREATE PUBLIC SYNONYM my_table AS my_table@my_old_db. This way if you connect to the passthrough database, and you can perform your selects and see the data of the old database.
If Excel is also querying other schemas, it might be best to slightly change the macros and where you have had SELECT a, b, c FROM sue.her_table you could put SELECT a, b, c FROM sue.her_table@my_old_db . This is because defining synonyms in multiple schemas would be much more complicated and error-prone.
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
answered Jul 14 '14 at 21:55
kubanczykkubanczyk
10.8k42946
10.8k42946
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f611549%2fora-01019-under-win-8-1-server-2012-r2-odbc-excel%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
