Driver?
I'm trying to troubleshoot and a .pdf in the C:\CFusionMX\db\slserver52
directory indicates
that I should be able to do a JDBC Test with a JDBC Configuration file which
is not installed.
(did a search for the directory jdbctest and the file config.txt)
-- gil
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] The Microsoft Jet database engine cannot find the input table
or query 'sale'. Make sure it exists and that its name is spelled correctly.
-- gil
-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 12:43 PM
To: CF-Talk
Subject: RE: CFMX installation problems, datasource
Thanks for the suggestions Michael,
I dumped the files in C:\CFusionMX\db\slserver52\tracing.
Restarted CFMX, CFMX ODBC Agent and CFMX ODBC Server. (Had to stop them
to
remove the .trc files.
It didn't work
CF created new .trc files. Removed them as well as dumping the file in
C:\CFusionMX\db\slserver52\logging.
This time I went to the page with ODBC Agent and ODBC Server shut down.
Expected a different error msg and got it.
Error Executing Database Query.
SQLException occurred in JDBCPool while attempting to connect,
please
check your username, password, URL, and other connectivity info.
Restarted ODBC Agent and ODBC Server and got the same error msg as before
"cannot find input table or query"
Rebooted and got the same error.
Any other suggestions? Remove and reinstall CF? This is getting
frustrating.
-- gil
==========================================================
==========================================================
For others that may have the same problem in the future:
I was getting a
"Cannot delete Cold Fusion MX ODBC Server.trc: There has been a
sharing
violation.
The source or destination file may be in use."
I stopped CFMX, same error. Stopped CFMX ODBC Agent and ODBC Server and
was
able to delete them both.
(Made back-ups of the folders before).
==========================================================
==========================================================
-- gil
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 1:22 AM
To: CF-Talk
Subject: RE: CFMX installation problems, datasource
Try this..
go to: C:\CFusionMX\db\slserver52\
There should be two folders: tracing and logging. Dump the contents of
tracing to start, then logging if it still does not resolve your issue.
Back these folders up first, in case the reuslts are not what you
expect.
_____
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 1:13 AM
To: CF-Talk
Subject: RE: CFMX installation problems, datasource
yes, same script, same databases. I can access the databases via php.
I reinstalled IIS.
Reinstalled CFMX.
CF is working fine.
What's not working is accessing databases.
Went to CF administrator, added the datasource, verified it, verified it
again, rebooted my laptop, restarted CF, restarted IIS.
Same problem.
It gives that weird "cannot find table or query" error.
I even made a brand new database, set up an ODBC connection and ...
still
the sam error.
Using Windows 2000, IS 5, CFMX 6
Any ideas on what errors to look for?
The Cold Fusion logs aren't telling me anything.
IIS logs have the following errors
event viewer > systems:
MSFTPSVC
SMPTSVC
W3VC
Service Control Manager (The WrKPoET2000 service failed to start due to
the
following error: A device attached to the system is not functioning. )
event viewer >applications:
WrNetworkDriver
Error: WR_::KERNEL_DRIVER_STUB::Start(WrKPoET2000) failed. Error = A
device
attached to the system is not functioning.
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 12:53 AM
To: CF-Talk
Subject: RE: CFMX installation problems, datasource
Sounds like it can not find a query or a table, did you verify that
the
DB
was still the same and that all the tables that were initially there
were
in
fact still there?
_____
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 12:00 AM
To: CF-Talk
Subject: CFMX installation problems, datasource
After IIS and CFMX crashed last week I had to reinstall both.
IIS works as does CFMX **** EXCEPT **** for the fact that CFMX there
is
a
problem accessing the database.
The ODBC connection seems to be working. If I don't put in the
datasource
it
gives the "Data Source x cannot be found" error. However after adding
the
datasource it give an error that it cannot find the table.
Of course I verified and reverified the datasource.
I bounced CFMX.
I rebooted the box.
I made a test db and a test page calling it and got the same error msg
as
before:
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver]
The Microsoft Jet database engine cannot find the input table or query
'whocares'.
Make sure it exists and that its name is spelled correctly.
Gil Midonnet
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
