Bookshelf Home | Contents | Index | PDF |
Transports and Interfaces: Siebel eBusiness Application Integration Volume III > Using Siebel OLE DB Provider > Troubleshooting OLE DBThis section describes common connection problems when using OLE DB. Consult the Windows Event Log to view the details on other OLE DB and Siebel OLE DB Provider errors. ErrorInitialization of the data source failed with following error: Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database. CauseYou have selected an invalid .cfg file in your Connection string or the .cfg file you have selected has not been updated to support OLE DB. Sample Problem Code
SolutionCheck to make sure you have set the ErrorThe query did not run or the database table could not be opened and you received the following error: Check the database server or contact your database administrator. Make sure the external database is available and has not been moved or reorganized, then try the operation again. CauseThe database name in your .cfg file is not set correctly or the name of the table in your query is incorrect. Sample Problem Code
ResolutionCheck to make sure that the ErrorSQL Query Analyzer error message. The following error is generated in the SQL Query Analyzer when the Object Manager on the Server is not initialized:
CauseThis error typically occurs when Object Manager is not initialized or may be related to SQL Server caching of the OLEDB datasource or to the servers not being successfully restarted. Sample Problem CodeResolutionErrorTest connection failed because of an error in initializing provider. 0x80040e73 CauseFailure to set the DataSource property in the [Siebel] section correctly generates this error when testing the connection. You also get an entry in Windows Event Log regarding this failure. Sample Problem CodeResolutionCheck your connection in the Siebel.UDL file and test it by providing the correct username and password. Also in the .cfg file, make sure the ProblemReceiving "Could not process object select * from GPTest2" error message DescriptionIf you did not make the custom OLE DB available to the Siebel Server Object Manager, you see the following error when you run the query: Sample Problem CodeSolutionMake sure that you have copied the latest .srf ProblemProvider "SiebelOLEDB.Provider.1 supplied inconsistent metadata for a column. Metadata information was changed at execution time" DescriptionThe length of the columns in the two applications does not match. Sample Problem CodeSolutionWhen SQL Server reports inconsistent metadata, the user can modify the field length in the rowset definition in Siebel Tools. ProblemUnable to query SODP using MSSQL Query Analyzer DescriptionWhen a connection is established with one type of connection string and then another connection is attempted with a different type of connection string, it fails on the second connection attempt, and generates the following error message: Error message with MSSQL: OLE DB provider "siebelOLEDB.Provider.1"reported an error. Provider caused a server fault in an external process. Sample Problem CodeSolution |
Transports and Interfaces: Siebel eBusiness Application Integration Volume III |