connection verification failed

[kwasiada]

Hi I'm a newbie so please take it slow.
I'm running win98 & coldfusion v6.1.
I've also got an apache/mysql server setup on the same machine.
In order to get cf working I manually uninstalled it, reinstalled it and added:
application.home=c:/CFusionMX
in the
c:\CFusionMX\runtime\bin\jvm.config file.
I've tried to follow the compass travel tute but I can't add any data sources. I get the error message:

Connection verification failed for data source: CompassTravel
[]java.sql.SQLException: 'C:\\WINDOWS\\TEMP\\compasstravel.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
The root cause was that: java.sql.SQLException: 'C:\\WINDOWS\\TEMP\\compasstravel.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

I have tried moving the mdb file but that don't work.

Also I've displayed a helloworld.cfc message from the

http://wwwroot

folder if that helps.

Any help would be dandy.
Cheers
Peace

 

[pigsie]

It doesn't seem to be able to find the mdb in the path specified are you sure its in c:\\WINDOWS\\TEMP\\compasstravel.mdb

 

[kwasiada]

Positive.
I've tried to place the file in various folders, including the

http://wwwroot

folder, but every time I point to it using the browse server button it returns the same error.
Heres my startup log
Starting Macromedia JRun 4 (Build 63824), default server
12/03 01:25:43 warning Unable to open C:\CFusionMX\runtime/lib/license.propertie
s
12/03 01:25:50 info JRun Naming Service listening on *:2901
12/03 01:25:52 info No JDBC data sources have been configured for this server (s
ee jrun-resources.xml)
Running on JRun4...
Starting ColdFusion services...
- Starting logging...
0 [main] INFO coldfusion.server - Starting logging...
12/03 01:26:01 info JRun Web Server listening on *:8500
12/03 01:26:01 info Deploying enterprise application "Macromedia ColdFusion MX"
from: file:/C:/CFusionMX/
12/03 01:26:02 info Deploying web application "ColdFusion Web Application" from:
file:/C:/CFusionMX/
12/03 01:26:05 info Web Services in CFusionMX#

http://wwwroot:

12/03 01:26:05 info (No web services found.)
12/03 01:26:05 user JSPServlet: init
12/03 01:26:07 user FlashGateway: init
12/03 01:26:08 user CFCServlet: init
Server default ready (startup time: 32 seconds)

 

[kwasiada]

Hi Peeps, solved it.
Basically coz my coldfusion's on win98, I have to create an ODBC data source using the Windows ODBC Administrator, then open the ColdFusion MX Administrator & add a new data source selecting JDBC-ODBC bridge as the driver type.
See

http://www.macromedia.com/go/tn_19200

for complete solution.

Cheers
Peace