.... I've had the developer edition for some time but never took the
time to learn it... Is there a good mail list similar to this one for
dialoging with SQL Svr 2000 users?
Tim
-----Original Message-----
From: Cameron Childress [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 7:51 PM
To: CF-Talk
Subject: RE: crystal tech - access databases
The .ldb file problem is "an access thing", and the best long term
solution
*is* to not use a desktop database for a web application. That's not a
practically solution for everyone...
The ldb file represents a connection to your database from an
application
(CF in your case). Even if you rid yourself of it using a bogus query
or
other method, it will return the second your web app gets another hit.
If
you have any traffic at all on your app, you might consider actually
taking
the app offline when you are trying to move around the database like
this.
I've used a short message and a <cfabort> at the top of the
application.cfm
file before to accomplish this.
Also, remember that CF may cache the connection to your Access DB unless
"Maintain Connections" is unchecked in the CFADMIN for this ODBC
connection.
You may want to have your ISP double check that setting if you are
unsure
that it's unchecked.
Finally, it can be helpful to make a copy of your DB and download the
copy
rather than the live DB. Copying the DB is alot quicker than
downloading it
and the time window you need to leave open for a copy is much more
manageable.
-Cameron
-----------------
Cameron Childress
Sumo Consulting Inc
---
land: 858.509.3098
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]
-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 1:39 PM
To: CF-Talk
Subject: crystal tech - access databases
Hello All... I'm having a real problem with not being able to upload or
download access databases with crystal tech hosting... the .ldb file
hangs around any prevents the upload or download. I've even tried the
bogus query method and that doesn't work.
Has anybody experienced this before with Crystal Tech? I use other
hosts (es. Media 3)and never have this problem ... Crystal Tech claims
its an access thing and to look at SQL server or MySQL... I will be
moving some databases to SQL server but not all
Any insight would be appreciated
Tim Laureska
1st-String Technologies
443-496-1261
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
