Link to home
Start Free TrialLog in
Avatar of cookmyster
cookmysterFlag for Canada

asked on

ColdFusion, Access, and ldb files

I have posted a question in the msaccess section and it has come down to it is now a coldfusion issue.

Pretty much.. on my webhost and get an database.ldb file and can't upload my database.  It eventuallys goes away.. but it takes hours sometimes.  How do I get rid of the ldb file.  Here is the link to the ongoing discussion.

https://www.experts-exchange.com/questions/20890238/ftp-and-ldb-files.html

Thx,
Rich
Avatar of Tacobell777
Tacobell777

You need to disable the ODBC connection, there is no other way as far as I know....
i suppose u wld have created a odbc conn via CFADMIN - in that case - under advanced tab  - u have a option of maintain connection - "uncheck" this option & then try - things shld hopefully work out for u

let me know ...

K'Rgds
Anand
ASKER CERTIFIED SOLUTION
Avatar of crosenblum
crosenblum

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have used crosenblum's suggeston with great success.

Code:
<cfquery name="unlockmdb" datasource="#request.datasource#">
  SELECT cutemeerkats
  FROM whereveryoucanfindthem
</cfquery>


Matthew