There is a SQL list at houseoffusion.com.
I agree with Cameron that MS Access shouldn't be used for web apps, but in
some cases it is all you have or your only option. There are a few good
tricks for maintenance, use etc if access is what you have to use, but IF
you have the option of using a SQL server (MS or MySQL) then I would take a
good look at it. it is well worth the migration and really isn't that
difficult to do. Some ISP's will give you a hand in the migration as well.
Take care,
Jason Egan
VP Partner/Customer Relations
Konnections, Inc.
www.CFDynamics.com
office 801-337-0135
fax 801-1394-1254
sales 866-CFDynamics
-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 07, 2004 7:17 AM
To: CF-Talk
Subject: RE: crystal tech - access databases
Thanks Cameron... I think its probably time to look at SQL server 2000
.... 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]
