ODBC or OLEDB to Oracle - Resources?

[Paul H. Tarver]

I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe



Interestingly I'm using EMS's Oracle Manager software and it connects fine
and returns queried data perfectly well. But no joy trying to connect
directly with ODBC.



I'm going to try uninstalling my Oracle ODBC drivers and install the latest
version of the drivers to see if that changes anything and if that fails I
need to investigate using OLEDB. However, I have not been working OLEDB and
am not sure how to proceed with that option.



So here's my question: Does anyone have any advice about connecting with
ODBC to Oracle or do you have any resources you can point me to regarding
using OLEDB to connect to Oracle.



Thanks in advance!



Paul





--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/01a901d3dcdd$91758e80$b460ab80$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Ted Roche]

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

I have been tripped up, more than once, in not ensuring I am using all
32-bit components and the 32-bit ODBC Administrator when trying to
connect from VFP.
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CACW6n4tJhHNVHzLsqF0qBtkAGtPGyp-JaJomDQ4umOAWtE93+***@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Richard Kaye]

In case you haven't found it, connectionstrings.com is a good resource.

--

rk

-----Original Message-----
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@DM5PR10MB1244.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Paul H. Tarver]

Great site. I've used them a lot in the past to work out connection strings!
Thanks!

Paul


-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Richard
Kaye
Sent: Thursday, April 26, 2018 7:18 AM
To: ***@leafe.com
Subject: RE: ODBC or OLEDB to Oracle - Resources?

In case you haven't found it, connectionstrings.com is a good resource.

--

rk

-----Original Message-----
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/033b01d3dd78$a1e611e0$e5b235a0$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Paul H. Tarver]

I verified I was using the 32-bit version and since I had this working on
this same computer for a previous client, I was pre-disposed to "ass-u-me"
everything was working. However, after manually uninstalling the ODBC
drivers and re-installing the drivers I downloaded yesterday, everything
started working magically. I can only guess that the previous ODBC driver
installation had become corrupted for some reason.

Back in the ODBC game for now. But still interested in the OLE options that
might be available to me since I've not worked with that before.

Paul

-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, April 26, 2018 6:13 AM
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

I have been tripped up, more than once, in not ensuring I am using all
32-bit components and the 32-bit ODBC Administrator when trying to
connect from VFP.
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/033c01d3dd78$a1ef87c0$e5ce9740$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Richard Kaye]

I thought OLEDB was a proprietary Microsoft technology and they stopped pushing that a while ago?

--

rk

-----Original Message-----
From: ProfoxTech <profoxtech-***@leafe.com> On Behalf Of Paul H. Tarver
Sent: Thursday, April 26, 2018 12:07 PM
To: ***@leafe.com
Subject: RE: ODBC or OLEDB to Oracle - Resources?

I verified I was using the 32-bit version and since I had this working on
this same computer for a previous client, I was pre-disposed to "ass-u-me"
everything was working. However, after manually uninstalling the ODBC
drivers and re-installing the drivers I downloaded yesterday, everything
started working magically. I can only guess that the previous ODBC driver
installation had become corrupted for some reason.

Back in the ODBC game for now. But still interested in the OLE options that
might be available to me since I've not worked with that before.

Paul

-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, April 26, 2018 6:13 AM
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

I have been tripped up, more than once, in not ensuring I am using all
32-bit components and the 32-bit ODBC Administrator when trying to
connect from VFP.
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@DM5PR10MB1244.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Paul H. Tarver]

Could be. I found some stuff about using OLE to connect to Access, Foxpro,
etc files, but I didn't have a lot of time to research.

My client mentioned that they had used OLE previously to connect to their
Oracle database, so I thought I'd throw out a request and see if anyone else
had worked with that connection method. It may not even be possible, but
even learning that would save me a lot of trouble! :)

Paul


-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Richard
Kaye
Sent: Thursday, April 26, 2018 12:27 PM
To: ***@leafe.com
Subject: RE: ODBC or OLEDB to Oracle - Resources?

I thought OLEDB was a proprietary Microsoft technology and they stopped
pushing that a while ago?

--

rk

-----Original Message-----
From: ProfoxTech <profoxtech-***@leafe.com> On Behalf Of Paul H. Tarver
Sent: Thursday, April 26, 2018 12:07 PM
To: ***@leafe.com
Subject: RE: ODBC or OLEDB to Oracle - Resources?

I verified I was using the 32-bit version and since I had this working on
this same computer for a previous client, I was pre-disposed to "ass-u-me"
everything was working. However, after manually uninstalling the ODBC
drivers and re-installing the drivers I downloaded yesterday, everything
started working magically. I can only guess that the previous ODBC driver
installation had become corrupted for some reason.

Back in the ODBC game for now. But still interested in the OLE options that
might be available to me since I've not worked with that before.

Paul

-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, April 26, 2018 6:13 AM
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe

I have been tripped up, more than once, in not ensuring I am using all
32-bit components and the 32-bit ODBC Administrator when trying to
connect from VFP.
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/09c001d3dda3$60e42ad0$22ac8070$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Alan Bourke]

Post by Richard Kaye
I thought OLEDB was a proprietary Microsoft technology and they stopped
pushing that a while ago?

It's a Microsoft wrapper for ODBC designed to simplify it and additionally support things that aren't relational databases, like spreadsheets.

They did deprecate it and recommended ODBC for talking to SQL Server going forward, however as of 30th of March this year they have reversed that decision and released a new SQL Server OLEDB driver.

https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm


_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[AndyHC]

Post by Alan Bourke

Post by Richard Kaye
I thought OLEDB was a proprietary Microsoft technology and they stopped
pushing that a while ago?

It's a Microsoft wrapper for ODBC designed to simplify it and additionally support things that aren't relational databases, like spreadsheets.
They did deprecate it and recommended ODBC for talking to SQL Server going forward, however as of 30th of March this year they have reversed that decision and released a new SQL Server OLEDB driver.
https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-drieof - etcver-for-sql-server/

.... and unless things have changed, ole-db does not give you a Foxpro
type cursor but an ole-db object with properties/methods something like
next() previous() etc. - you were compelled to use it for js/vb web
queries but I never found it as easy to use as a cursor.

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/209eb5c9-c9dd-f603-49cf-***@hawthorncottage.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Richard Kaye]

Interesting. Thanks for the update, Alan.

I now have the great joy of a true SQL DBA at my company who really knows his MSSQL stuff. I'll be curious to see what he has to say.

--

rk

-----Original Message-----
From: ProfoxTech <profoxtech-***@leafe.com> On Behalf Of Alan Bourke
Sent: Friday, April 27, 2018 4:59 AM
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Post by Richard Kaye
I thought OLEDB was a proprietary Microsoft technology and they stopped
pushing that a while ago?

It's a Microsoft wrapper for ODBC designed to simplify it and additionally support things that aren't relational databases, like spreadsheets.

They did deprecate it and recommended ODBC for talking to SQL Server going forward, however as of 30th of March this year they have reversed that decision and released a new SQL Server OLEDB driver.

https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/***@DM5PR10MB1244.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Stephen Russell]

Do you have the correct details for the tnsnames.ora that is in place at
the client? Just having user/pw is not enough.

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe
Interestingly I'm using EMS's Oracle Manager software and it connects fine
and returns queried data perfectly well. But no joy trying to connect
directly with ODBC.
I'm going to try uninstalling my Oracle ODBC drivers and install the latest
version of the drivers to see if that changes anything and if that fails I
need to investigate using OLEDB. However, I have not been working OLEDB and
am not sure how to proceed with that option.
So here's my question: Does anyone have any advice about connecting with
ODBC to Oracle or do you have any resources you can point me to regarding
using OLEDB to connect to Oracle.
Thanks in advance!
Paul
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYLgmYxa2wXM==***@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Paul H. Tarver]

Looks like the tnsnames.ora file was fine, but the ODBC driver itself had
become corrupted. After ground-up re-install everything is working as
expected now.

Looks like I panicked and called in the Calvary too soon! :)

Thanks!

Paul

-----Original Message-----
From: ProfoxTech [mailto:profoxtech-***@leafe.com] On Behalf Of Stephen
Russell
Sent: Thursday, April 26, 2018 9:50 AM
To: ***@leafe.com
Subject: Re: ODBC or OLEDB to Oracle - Resources?

Do you have the correct details for the tnsnames.ora that is in place at
the client? Just having user/pw is not enough.

Post by Paul H. Tarver
I have been able to ODBC to an Oracle 11g database in the past for a
previous client but I've picked up a new client who is also on Oracle 11g
and I'm having a devil of a time to get the ODBC connection string working
either from within Foxpro or even from ODBC32.exe
Interestingly I'm using EMS's Oracle Manager software and it connects fine
and returns queried data perfectly well. But no joy trying to connect
directly with ODBC.
I'm going to try uninstalling my Oracle ODBC drivers and install the latest
version of the drivers to see if that changes anything and if that fails I
need to investigate using OLEDB. However, I have not been working OLEDB and
am not sure how to proceed with that option.
So here's my question: Does anyone have any advice about connecting with
ODBC to Oracle or do you have any resources you can point me to regarding
using OLEDB to connect to Oracle.
Thanks in advance!
Paul
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---

[excessive quoting removed by server]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/033a01d3dd78$a1d7ba00$e5872e00$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.