Re: Manual install ODBC services ColdFusion MX7
> What are the actual column names in the insert? Never mind. I skimmed and missed it. There might be others, but I am guessing the "Year" column is the culprit. Try escaping it with square brackets ie [Year] -Le ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
> but all I get is "Syntax error in INSERT INTO statement".. Usually that means the query is using a reserved word. The reserved words seem to be different between the odbc and unicode drivers. IIRC, "password" is one example. It works under odbc, but fails under the unicode driver. I have seen that one a lot on the adobe forums. What are the actual column names in the insert? -Le ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
Yeah, see my other post.. I can't get a simple insert to work from CF On Fri, Nov 11, 2011 at 4:00 PM, Leigh wrote: > > Not to discourage you from switching, but was there a reason you could not > just use the access unicode driver? > > > -Leig > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
Not to discourage you from switching, but was there a reason you could not just use the access unicode driver? -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
Screw Access.. I'm creating the tables in Oracle and exporting the data.. I'll deal with fixing the queries.. Thanks for all of your help guys! On Fri, Nov 11, 2011 at 2:42 PM, Greg Morphis wrote: > it installed but installed incorrectly.. > The bin folder is in slserver54 but the service points to slserver52.. > I modified the registry to point to slserver54 but get an error when > trying to launch the service.. > something like 'could not start the service, no error was returned, if you > continue to experience this contact your system administrator' > > I'm copying the db folder from CF8 and will try again, I don't know what > else to do. > > > > > On Fri, Nov 11, 2011 at 2:33 PM, Dave Watts wrote: > >> >> > I'm trying to follow this page: >> > >> > http://kb2.adobe.com/cps/191/tn_19135.html >> > >> > However the directory doesn't exist on our production server.. >> > I copied it from our dev directory to prod.. >> >> Which directory, exactly, doesn't exist on your production server? >> >> > The page mentions running a CF template: >> > >> > >> > >> > >> > >> > > > arguments='!TargetDir="#cfusionHome#" !DoDNS=true'> >> > > > ="HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX" >> > entry="SqlLink"type="String" >> > value="#cfusionHome#\db\slserver54"> >> > >> > >> > Error Occurred: >> > #cfcatch.message##cfcatch.detail# >> > >> > >> > >> > >> > Is there a way I can manually run the setup in a command line to get the >> > same results? >> > >> > Double clicking on setup.exe yields an Install Shield that never goes >> away >> >> Sure. Navigate to the directory in question, then type 'setup.exe >> !TargetDir="your_cf_directory_goes_here" !DoDNS=true'. At least, >> that's what it looks like it should be to me. >> >> 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, >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
it installed but installed incorrectly.. The bin folder is in slserver54 but the service points to slserver52.. I modified the registry to point to slserver54 but get an error when trying to launch the service.. something like 'could not start the service, no error was returned, if you continue to experience this contact your system administrator' I'm copying the db folder from CF8 and will try again, I don't know what else to do. On Fri, Nov 11, 2011 at 2:33 PM, Dave Watts wrote: > > > I'm trying to follow this page: > > > > http://kb2.adobe.com/cps/191/tn_19135.html > > > > However the directory doesn't exist on our production server.. > > I copied it from our dev directory to prod.. > > Which directory, exactly, doesn't exist on your production server? > > > The page mentions running a CF template: > > > > > > > > > > > > > arguments='!TargetDir="#cfusionHome#" !DoDNS=true'> > > > ="HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX" > > entry="SqlLink"type="String" > > value="#cfusionHome#\db\slserver54"> > > > > > > Error Occurred: > > #cfcatch.message##cfcatch.detail# > > > > > > > > > > Is there a way I can manually run the setup in a command line to get the > > same results? > > > > Double clicking on setup.exe yields an Install Shield that never goes > away > > Sure. Navigate to the directory in question, then type 'setup.exe > !TargetDir="your_cf_directory_goes_here" !DoDNS=true'. At least, > that's what it looks like it should be to me. > > 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, > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
> I'm trying to follow this page: > > http://kb2.adobe.com/cps/191/tn_19135.html > > However the directory doesn't exist on our production server.. > I copied it from our dev directory to prod.. Which directory, exactly, doesn't exist on your production server? > The page mentions running a CF template: > > > > > > arguments='!TargetDir="#cfusionHome#" !DoDNS=true'> > ="HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX" > entry="SqlLink" type="String" > value="#cfusionHome#\db\slserver54"> > > > Error Occurred: > #cfcatch.message##cfcatch.detail# > > > > > Is there a way I can manually run the setup in a command line to get the > same results? > > Double clicking on setup.exe yields an Install Shield that never goes away Sure. Navigate to the directory in question, then type 'setup.exe !TargetDir="your_cf_directory_goes_here" !DoDNS=true'. At least, that's what it looks like it should be to me. 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, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
