Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Odd SQL Problem
Author: Brian Thornton
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63905#351069
Got it..
Thanks Dave.
----- Excess quoted text cut - see Original Post for more -----
Author: Dave Watts
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63905#351068
----- 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
http://www.figleaf.com/
http://training.figleaf.com/
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
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63905#351067
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...
Any ideas?
select *
into NewTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Brian.xls;HDR=YES',
'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
single quotes....
Any ideas or does anyone have cfquery example to the insert into?
|
May 21, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
