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 ---
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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.
In case you haven't found it, connectionstrings.com is a good resource.
--
rk
-----Original Message----- To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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
Great site. I've used them a lot in the past to work out connection strings! Thanks!
Paul
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, April 26, 2018 7:18 AM To: profoxtech@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: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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]
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-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 26, 2018 6:13 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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.
I thought OLEDB was a proprietary Microsoft technology and they stopped pushing that a while ago?
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: Thursday, April 26, 2018 12:07 PM To: profoxtech@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-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 26, 2018 6:13 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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.
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-bounces@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, April 26, 2018 12:27 PM To: profoxtech@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-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: Thursday, April 26, 2018 12:07 PM To: profoxtech@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-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 26, 2018 6:13 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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.
On Thu, 26 Apr 2018, at 6:26 PM, Richard Kaye wrote:
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-microso...
On 27-Apr-18 9:59 AM, Alan Bourke wrote:
On Thu, 26 Apr 2018, at 6:26 PM, Richard Kaye wrote:
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-microso... - 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.
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-bounces@leafe.com On Behalf Of Alan Bourke Sent: Friday, April 27, 2018 4:59 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Thu, 26 Apr 2018, at 6:26 PM, Richard Kaye wrote:
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-microso...
Do you have the correct details for the tnsnames.ora that is in place at the client? Just having user/pw is not enough.
On Wed, Apr 25, 2018 at 4:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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]
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-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, April 26, 2018 9:50 AM To: profoxtech@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.
On Wed, Apr 25, 2018 at 4:37 PM, Paul H. Tarver paul@tpcqpc.com wrote:
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]
-
Alan Bourke -
AndyHC -
Paul H. Tarver -
Richard Kaye -
Stephen Russell -
Ted Roche