Enough

[billroper]

I'm trying to debug our ADO connectivity to an Oracle database using the Oracle OLE DB drivers.

It turns out that there's something ugly that Microsoft did to the MDAC that messed things up pretty thoroughly. I grabbed the newer versions of the MDAC drivers (version 2.8, so that we're backward compatible to Windows Server 2003) and that fixed up the connectivity problems.

Unfortunately, it just looks like the SQL statements that we've written to pass to the Oracle DB are wrong. And I don't speak SQL of any flavor.

So I have called for help.

And that is quite enough for a Friday night.

Comments

[lizneely.livejournal.com]

I'm a DB programmer, primarily SQL Server but I do have to occasionally write Oracle SQL as well to pull from some corporate Oracle DBs. It's annoying that the syntax is slightly different. There are also slight differences for Access DBs. Feel free to call on me if I can help with syntax issues. Not sure of a safe way to post my email address, but you can get it from Erica.

[billroper]

I appreciate it!

I will probably hold off on this for just a little bit, because if we cannot find someone in our larger group who understands the Oracle DB syntax -- given who my employer is -- then we are clearly doing something wrong. :)