rub. I reinstalled CFMX and I got the same errors. I reinstalled it again -
different errors!!!!. Reinstalled again and VOILA, it works!!!!
Why? No idea.
gil
thx everybody for your suggestions and help
-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 1:57 PM
To: CF-Talk
Subject: RE: CFMX installation problems, datasource
OK, maybe I'm grasping at straws here.
A macromedia.com tech note "Troubleshooting data sources and database
connectivity for Windows platforms"
says to check the username and password for your datasources.
I checked and there is no username and password listed. I added my
username
and password. Still no go.
A general question -- in your admin sections do you have a username and
password listed?
CFIDE > administrator > data sources :
click on a datasource
select "Show Advanced Settings"
username and password should be listed there.
-- glm
-----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]
