cookmyster
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
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
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
let me know ...
K'Rgds
Anand
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have used crosenblum's suggeston with great success.
Code:
<cfquery name="unlockmdb" datasource="#request.datas ource#">
SELECT cutemeerkats
FROM whereveryoucanfindthem
</cfquery>
Matthew
Code:
<cfquery name="unlockmdb" datasource="#request.datas
SELECT cutemeerkats
FROM whereveryoucanfindthem
</cfquery>
Matthew