dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Cannot create an instance of OLE DB. - sqlserver-odbc

This is a discussion on Cannot create an instance of OLE DB. - sqlserver-odbc ; Hi, In my SQL 2005 server, I've got an ODBC Connection to Prologue Criteria. I can get data with a script, executed in my server, and using ADODB.Connection via ODBC. But I cannot create an instance of OLE DB via ...


Home > Database Forum > Microsoft SQL Server > sqlserver-odbc > Cannot create an instance of OLE DB.

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-07-2008, 07:34 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Cannot create an instance of OLE DB.

Hi,
In my SQL 2005 server, I've got an ODBC Connection to Prologue Criteria.
I can get data with a script, executed in my server, and using
ADODB.Connection via ODBC.
But I cannot create an instance of OLE DB via a linked server.

I've tried all options of the Management Studio for my linked server, but
OLE DB doesn't work, I always get "Cannot create an instance of OLE DB".

Can SQL Server connect ODBC via ADODB?
Is there another options differents of the Management Sutdio ones?

Thanks for all.

Marc.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 08:03 AM.