Excel Linked Server in MSSQL2000
Hi,
Am using Delphi7
RBuilder 10.0.4
MSSQL2000
Excel2003
The server and excel spreadsheet are local on the consultant's machine.
I have created a linked server (excel) on MSSQL2000 and I have tested the
following query and results are returned as expected in Query Analyser
select *
into #allelementsTMP1 FROM OPENQUERY(ENAPInstrumentDATA, 'SELECT * FROM
[allelements$]')
However, when I place this in the data tab of the end user report and try to
run it I get OLE/DB provider returned message ot a valid account name or
password. OLEDB error trace IBInitilize
Can someone help please.
Am using Delphi7
RBuilder 10.0.4
MSSQL2000
Excel2003
The server and excel spreadsheet are local on the consultant's machine.
I have created a linked server (excel) on MSSQL2000 and I have tested the
following query and results are returned as expected in Query Analyser
select *
into #allelementsTMP1 FROM OPENQUERY(ENAPInstrumentDATA, 'SELECT * FROM
[allelements$]')
However, when I place this in the data tab of the end user report and try to
run it I get OLE/DB provider returned message ot a valid account name or
password. OLEDB error trace IBInitilize
Can someone help please.
This discussion has been closed.
Comments
As an intermediate step, try getting this query working with an ADO dataset
and ADO query on a Delphi form. Connect this to a DBGrid to see if the
query is returning the proper data. Once you get this working correctly,
try moving to ReportBuilder with DADE.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com