The oracle ole driver onto our new sql server. Sql oledb driver. To access a postgresql. How to install oracle ole drivers for use. SQL Server 64-bit Linked Server woes. Use the latest version of the new PostgreSQL 64-bit drivers now available main PostgreSQL. From OLE DB provider 'MSDASQL'. SQL Server 64-bit Linked Server woes. Use the latest version of the new PostgreSQL 64-bit drivers now available main PostgreSQL. From OLE DB provider 'MSDASQL'.
Could really use a hand here. We have a vb.net application that checks a back end database table for new data to process. The original back end database was in MS Access. We have upgraded the back end Database to Postgres. The application has been updated to now use the Postgres OLE DB driver. Microsoft Powerpoint 2004 (mac).
We have not been able to get the applicaiton to work as a service, where as the exact same code works as an application. Firewall has been turned off, same problem. Serice has been setup to use the same login creditials, same problem. The only strange entry in the event log is the error itself: Service cannot be started. System.Data.OleDb.OleDbExc eption: No error information available: 0x80040155. At System.Data.OleDb.OleDbDat aReader.Pr ocessResul ts(Int32 hr) at System.Data.OleDb.OleDbDat aReader.Ne xtResult() at System.Data.OleDb.OleDbCom mand.Execu teReaderIn ternal(Com mandBehavi or behavior, String method) at System.Data.OleDb.OleDbCom mand.Execu teReader(C ommandBeha vior behavior) at System.Data.OleDb.OleDbCom mand.Execu teReader().