i have a query and i want to use it in remote server
when i try to run it in my machine it executes ok.
but in remote server it cannot be executed.
im connected to the remote server and i can view all the
records in the table. i can make tables and stored proc as well
but unfortunately my query dont work for the remote server.

please kindly help


here is my query

SELECT A.TRACKINGNO AS 'TrackingNo', A.RECEIVEDBY AS 'ReceivedBy', convert(varchar(10),A.RECEIVEDDATE,101) AS 'ReceivedDate', A.RELATIONSHIP AS 
'Relationship',A.STATUS AS 'Status', ISNULL(B.CYCLENO,'') AS 'CycleNo', isnull(convert(varchar(10),B.ACTUALDATE,101),'') AS 'ActualDate',
 B.custid AS 'CustID' 
INTO excelSalesHeaderTbl
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                'Excel 8.0;Database=C:\valQuery.xls;IMEX=1',
                'SELECT * FROM [Sheet1$]') A

here is my error

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Recommended Answers

All 2 Replies

Is this the first time you try to access a link server remotely?

Are you running it with admin privileges?

no, it was not my first time to access remote server, the problem is
the filepath from client is c:\ drive, which the server thinks it is his c:\ drive.
yes im running it with admin privileges

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.