Author: Dave Watts
----- Excess quoted text cut - see Original Post for more -----
I suspect that OPENROWSET isn't going to work with CF through JDBC.
I'm not sure why - perhaps it expects the connection string to work
from the machine running CF. You could try writing it as a stored
procedure, then calling the sproc from CF.
Dave Watts, CTO, Fig Leaf Software
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or ons
Author: Brian Thornton
I don't know if it's because its 11PM or what but I got a get of SQL
working on MSQL client but wont work via cfquery significant amount of
googleing was a nogo...
into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [Sheet1$]')
SQL MS comes back with "1500 record(s) added but cfcomes back with
"Microsoft.Jet.OLEDB.4.0" for linked server "(null)"
turns out this is a generic message and could very to permissions to
Any ideas or does anyone have cfquery example to the insert into?