Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Expand / Collapse
Author
Message
Posted Saturday, June 28, 2008 1:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 02, 2012 4:09 AM
Points: 2, Visits: 18
hi Friends

i m getting following error msg on my production server

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

while creating sp which contain

code

select productid,productkeyword,brand,Manufacturer,manfid,upc,price,saleprice,variablecommission,@advid,@commission from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\perfeed','select * from catalog.txt')


this sp is executing properly on my local machine

my production server have jet driver 4.0 and i m using sql2005

i m login remotely to my server

and i ready run
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure

still getting this problem

any solution




Post #525452
Posted Friday, July 25, 2008 5:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 28, 2013 10:48 AM
Points: 2,869, Visits: 371
Note that "C:\perfeed" refers to a folder located on the C: drive at the server.

Does that folder exist at the server? Does the file exist in that folder? Does the SQL Server service account have appropriate permissions in that folder? How are you connecting to the server (i.e. which authentication mode are you using)?



ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Post #540823
Posted Saturday, June 11, 2011 10:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 01, 2011 3:30 AM
Points: 2, Visits: 4
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
Post #1123867
Posted Saturday, June 11, 2011 10:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 01, 2011 3:30 AM
Points: 2, Visits: 4
hi dear friends,

please provide me the solution while i'm trying to select openrowset


OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
Post #1123869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse