Hi Matthew,
Sometimes, it might happen that the ODBC services Coldfusion8 ODBC Agent
and Coldfusion 8 ODBC Server do not get installed properly for new J2EE
deployment and in services property the path keeps pointing to an old
deployment directory and hence they do not start up.
What you can do is, remove the existing ODBC services using
remove-odbcservices.cfm having the script given below:
<cfscript>
createObject("component","cfide.adminapi.administrator").login("admin");
myObj =
createObject("component","cfide.adminapi.datasource");
writeOutput("Removing ODBC Services...<br>");
returnValue = myObj.removeODBCservice();
writeOutput("ODBC Services removed");
</cfscript>
And then, install the ODBC services using install-odbcservices.cfm
having the script given below:
<cfscript>
createObject("component","cfide.adminapi.administrator").login("admin");
myObj =
createObject("component","cfide.adminapi.datasource");
writeOutput("Installing ODBC Services...<br>");
returnValue = myObj.installODBCservice();
writeOutput("ODBC Services installed");
</cfscript>
Then, try starting ColdFusion ODBC Server service.
Thanks,
Hareni
-----Original Message-----
From: Matthew Smith [mailto:[EMAIL PROTECTED]
Sent: 22 August 2007 01:25
To: CF-Talk
Subject: error with ColdFusion 8 ODBC Agent
I am trying to add a datasource to my new install of CF8 developer
edition. When I went to do so in cf admin, the admin said "The
ColdFusion ODBC Server service is not running or has not been
installed." So I figured the service wasn't set to automatic and went
into services to start it up. When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
I did a clean install of windows and CF 8.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
