0

I have been using this connection string:

 fn_Connection_String = "Provider=MSDAORA;Data Source=[address]:1521/orcl;User ID=xxx;Password=xxx"

...and it has been working fine. The IT company that works for my client has reported that the client is unable to use my software any longer, it is not connecting to the database. I test with the Oracle tools and all seems to be well, so I assume the problem is with the provider.

I tried this as well and was met with the same error but from different software:

fn_Connection_String = "Driver={Microsoft ODBC for Oracle}; " & _
    "CONNECTSTRING=(DESCRIPTION=" & _
    "(ADDRESS=(PROTOCOL=TCP)" & _
    "(HOST=[address])(PORT=1521))" & _
    "(CONNECT_DATA=(SERVICE_NAME=orcl))); uid=xxx;pwd=xxx;"

Does anyone have a clue what is going on? Maybe some updates broke something, or people have been mucking about in the environment?

It seems like the old ODBC connection no longer works, and there is an "oracle in instantclient" connector which works, but isn't working in VBA.

The message I'm getting is Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these component are installed

EDIT After posting I found that the IT company installed 2 drivers, version 11 something, and also instantclient, which is version 12 something. I tried using "Driver={Oracle in instantclient_12_1}; " (Since that is the driver name in the 32 bit ODBC connection manager) but that does not work.

Community
  • 1
  • 1
n8.
  • 1,732
  • 3
  • 16
  • 38
  • 1
    Sounds like someone's been mucking around in the environment. I hate it when muck gets mucked around in my environment or environments. – CustodianOfCode Feb 26 '16 at 05:41
  • @CustodianOfCode Totally. – n8. Feb 26 '16 at 05:47
  • @n8 have you checked the port if it has been allowed or not? someone must have accidentally disallow that port. – bipartite Feb 26 '16 at 05:49
  • No, I hadn't thought of that. I'll have them look, thanks for the suggestion. – n8. Feb 26 '16 at 05:55
  • Do you have any error message? – Wernfried Domscheit Feb 26 '16 at 06:04
  • Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these component are installed – n8. Feb 26 '16 at 07:09

1 Answers1

0

Microsoft released a patch on the 9th of Feb, which has been causing this issue.

Its now listed as a known issue.

https://support.microsoft.com/en-us/kb/3126587

Michael OShea
  • 397
  • 2
  • 7
  • I tried a bunch of stuff and it started working again. There was another factor in that the Oracle driver is now housed in Oracle's InstantClient. Ultimately I rebuilt the connection string and that was the last step in getting it working. – n8. Mar 03 '16 at 18:57