Function linked to ODBC fail

FAQ

Profile

Function linked to ODBC fail

Database Forums (Home) -> ODBC

Next: Grouping Menu Choices

Author

Message

André

External

Since: Dec 05, 2008
Posts: 1

(Msg. 1) Posted: Fri Dec 05, 2008 2:03 pm Post subject: Function linked to ODBC fail Archived from groups: microsoft>public>sqlserver>odbc (more info?)

Hi, I have a function on sql 2005 that calls a odbc link to oracle. The oracle DB was down when I called the function and I received this error: Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" Is there a way for me just to return Null so the stored procedure that calls this function continues to work? Thanks Andre >> Stay informed about: Function linked to ODBC fail

Display posts from previous:

Related Topics:

SQL linked server with ODBC - Hi, I am having trouble extracting data from a Navision database via an sql linked server. I am using sql server 2000. The steps I have followed so far are; I installed the codbc driver, (the odbc driver which comes with navision), on the sql server. ...

linked server to db2 using odbc - I'm trying to link SQL Server 2000 to DB2 UDB 7.2 using the Microsoft OLE DB Provider for ODBC Drivers. I've created a System DSN, which I've successfully tested using a Microsoft Access Linked Table (selects, inserts, updates, and deletes all work)....

ODBC Linked server error. - I have setup a 'Microsoft OLE DB Provider for ODBC Drivers' linked server on my Microsoft SQL 2000 (MSDE) server. The linked server is a system DSN which connects to a informix database running on SCO unix. I can run queries, views etc on the Windows..

Avg function returns string via ODBC - I am developing application in MS Access 2002. I have a passthrough query to retrieve data from SQL Server 2000 SP4 (8.00.2039) with count, avg and sum functions. All three functions work properly against floating datatypes in SQL Server. However, the...

ODBC Data Source to a linked SQL Server - I'd like to set up an ODBC Data Source to a table in a linked SQL Server, via my local SQL Server. When I use the ODBC Data Sources program to set up the ODBC DSN, it only shows databases in the local SQL Server, not in the linked one. If I try typing....

	Database Forums (Home) -> ODBC	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum