I have an OBDC connection from NT Server to an Oracle database. When I execute a MS SQL query to select from a table on that Oracle database, it says the OLEDB PROVIDER DOES NOT CONTAIN THAT TABLE, but it does. I can, in fact, perform a select on a table in the same Oracle schema ??
Thanks.
I have an ODBC connection from NT Server to an Oracle database. When I execute a MS SQL query against that Oracle database, it appears that the “where” clause is not being executed until the entire database has been pulled over to the server ??? Any way to avoid this ?
Thanks
I am using SQL 7 to select and insert data into a table from Oracle via an ODBC connection. It works fine except when (as described in the documentation) the Oracle date field is less than 1/1/1753, in which case, I get ERROR CONVERTING DATATYPE DBTYPE_DBTIMESTAMP TO DATE TIME. That's fine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.