Hi Charlie,
When I create the datasource I turn off the maintain datasource connection
option. Before I delete the datasource I had tried to turn on the disable db
connections option as well. I have stuck with the old cf 6 cfc for the
moment. I'll wait till cf 8 then try to use the cf admin api again. the
driver I'm using the follwoing code to create the datasource -:
<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("mypassword");
// Instantiate the data source object.
myObj = createObject("component","cfide.adminapi.datasource");
// Create a DSN.
myObj.setMSAccessUnicode(name="#Attributes.datasource#", databasefile =
"#Attributes.path##Attributes.datasource#.mdb", maintainconnect = 0,
enablemaxconnections = 1, maxconnections = 1);
</cfscript>
Then I insert some data into the datasource and then run this code to remove
the datasource.
<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("mypassword");
// Instantiate the data source object.
myObj = createObject("component","cfide.adminapi.datasource");
// Remove a DSN.
myObj.deletedatasource(dsnname="#Attributes.datasource#");
</cfscript>
As mentioned I had played around with trying to disable the datasource
connection option as well with the following code -:
<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("mypassword");
// Instantiate the data source object.
myObj = createObject("component","cfide.adminapi.datasource");
// Modify the dsn.
myObj.setMSAccessUnicode(name="#Attributes.datasource#", databasefile =
"#Attributes.path##Attributes.datasource#.mdb", maintainconnect = 0,
enablemaxconnections = 1, maxconnections = 1, disable = 1, timeout = 1);
</cfscript>
So I have looked into those options but still the lock file persists ?? It
may be that there is an issue with the OS itself or maybe with the admin
api??
Rod
----- Original Message -----
From: "Charlie Arehart" <[EMAIL PROTECTED]>
To: <cfaussie@googlegroups.com>
Sent: Tuesday, August 22, 2006 1:30 AM
Subject: [cfaussie] Re: Access Lock File
>
> Rod, no one has mentioned this: have you gone into the "show advanced
> settings" button of the datasource definition (in the CF Admin) to tell it
> "turn off" the "maintain connections" option? That's what's really causing
> the lock (as would any app that opened and kept open the .mdb file). Of
> course, as others have proposed, getting off of Access should be the next
> step (I realize that may be out of your hands).
>
> One other thought, if this doesn't work, is to ask whether your datasource
> is defined in the CFMX admin as being an "ODBC socket" or a "Microsoft
> Access" type. The former means you point at an existing ODBC DSN, where
> the
> latter uses a built-in connection CFMX offers using DataDirect. Whichever
> you have, try the other. Shouldn't have any negative impact on how the
> code
> works (but of course you should thoroughly test before relying on the
> change
> in production).
>
> Let us know how it goes.
>
> /charlie
> http://www.carehart.org/blog/
>
> -----Original Message-----
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> Of Rod Higgins
> Sent: Sunday, August 20, 2006 9:13 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Access Lock File
>
>
> The problem is releasing the lock file so users can download the access
> db.
> Currently cf retains the lock file no matter what I try to do, while this
> lock file is present the OS can not delete, rename or remove either the
> lock
> file or the access db, so this stops any user gaining access to it. Kinda
> frustrating. At first I thought there was some sort of error in the insert
> code but I broke that down to a single query and still I have the same
> problems. I did a google search but can't dig up any issues with the cf
> admin api so I can only assume it's either my code or some issue with the
> OS?
>
> ----- Original Message -----
> From: "Chad Renando" <[EMAIL PROTECTED]>
> To: <cfaussie@googlegroups.com>
> Sent: Monday, August 21, 2006 11:03 AM
> Subject: [cfaussie] Re: Access Lock File
>
>
>>
>> So where is the problem? Is it in dumping to the Access DB or in the
>> download?
>>
>> If it is in dumping to the Access DB, can you not just run a delete
>> and insert query to update with the latest data?
>>
>> How many users? Another solution may be to dump to a comma delimited
>> file which the user downloads and run an automated import using Access
>> on the client side.
>>
>> Chad
>>
>> On 8/21/06, Rod Higgins <[EMAIL PROTECTED]> wrote:
>>>
>>> Hi Chad,
>>>
>>> Im using access to dump very small sections of data from a much larger
>>> SQL
>>> database so users can download the access db and run ad hoc reports from
>>> it.
>>> I am not using access as a primary datasource. And no DTS is not an
>>> option -
>>> mostly due to security / access concerns to the primary datasource and
>>> complexity of the parameters passed into the extraction process.
>>>
>>> Rgds
>>> Rod
>>>
>>> ----- Original Message -----
>>> From: "Chad Renando" <[EMAIL PROTECTED]>
>>> To: <cfaussie@googlegroups.com>
>>> Sent: Monday, August 21, 2006 10:47 AM
>>> Subject: [cfaussie] Re: Access Lock File
>>>
>>>
>>> >
>>> > I ran into it, but had to design my app in a manner that didn't
>>> > require DB creation stuff in an Access file. Main reason I move to
>>> > SQL.
>>> >
>>> > Chad
>>> >
>>> > On 8/21/06, Rod Higgins <[EMAIL PROTECTED]> wrote:
>>> >>
>>> >> Hi,
>>> >>
>>> >> Currently I am having major issues with creating an MS Access with
>>> >> Unicode
>>> >> datasource via the CF admin api. The datasource is created I pump
>>> >> some
>>> >> data
>>> >> into the access db but then it seems to create a lock file that will
>>> >> not
>>> >> release even after I remove the datasource via the same api. The
>>> >> usual
>>> >> malformed query workaround doesn't seem to release the lock file nor
>>> >> any
>>> >> other workaround I have tried. Has anyone come across this and have a
>>> >> solution that works to release the lock?
>>> >>
>>> >> CF7 Ent on Windows 2003.
>>> >>
>>> >> TIA
>>> >> Rod
>>> >> >
>>> >>
>>> >
>>> > >
>>> >
>>>
>>>
>>> >
>>>
>>
>> >
>>
>
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
