The same except I set the timeout to 1200 (ODBC)
^
/ \__
( @\___
/ O
/ (_____/
/_____/
Whoof...
410-757-3487
-----Original Message-----
From: John Cesta - Lists [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:53 PM
To: CF-Server
Subject: Settings for Access DBs
In the Allaire knowledgbase they propose these settings for MS Access DBs:
In ColdFusion Administrator, modify every Access ODBC Datasource and set
the
following (you will need to click the CF Settings button to see these):
Buffer Size = 0 (ODBC only)
Page Timeout = 600 (ODBC only)
Uncheck Maintain Database Connections
By a show of emails, does anyone have these settings on their Access DBs?
Thanks,
John Cesta
> -----Original Message-----
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 1:14 AM
> To: CF-Server
> Subject: Re: repair and compact DBs
>
>
> Also, file locks will prevent the compacting from happening,
> unless you just
> happen to hit it when the web server has no locks on the
> database. In turn,
> while you're compacting, you'll then prevent all access to the database,
> including from your web site.
>
> Jim
>
>
> -----Original Message-----
> From: Jason <[EMAIL PROTECTED]>
> To: CF-Server <[EMAIL PROTECTED]>
> Date: Monday, March 19, 2001 9:10 PM
> Subject: RE: repair and compact DBs
>
>
> >Yes you would have to have Access installed on the server or on a
another
> >machine in the domain and then share the drive across so that
> you could call
> >it. Its been a while since Iv'e worked with Access - Im too spoiled by
MS
> >SQL :)
> >
> >Make note too that you could write a script and pass it varibles for all
> >your different database items.
> >You could use the custom Tag CFX_SHELLEXEC and pass it
> parameters for each
> >DB from within your CFM pages and automate most of the process.
> >Sending a variable like (d:\inetpub\odbcsources\AccessDB.mdb)
> >
> >C:\Progra~1\Micros~1\Office\MSACCESS.EXE %1 /compact %1
> >-----Original Message-----
> >From: John Cesta - Lists [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, March 19, 2001 7:07 PM
> >To: CF-Server
> >Subject: RE: repair and compact DBs
> >
> >
> >> C:\Progra~1\Micros~1\Office\MSACCESS.EXE
> >> d:\inetpub\odbcsources\AccessDB.mdb
> >> /compact d:\inetpub\odbcsources\AccessDB.mdb
> >
> >Thanks Jason,
> >
> >I guess this assumes that we have MS Access installed on the server. Am
I
> >correct? We don't have Access installed on the server.
> >
> >> -----Original Message-----
> >> From: Jason [mailto:[EMAIL PROTECTED]]
> >> Sent: Monday, March 19, 2001 9:39 PM
> >> To: CF-Server
> >> Subject: RE: repair and compact DBs
> >>
> >>
> >> I think you should be able to build a batch file using the following
> >> example - obviously this depends on where your stuff is installed.
> >>
> >> C:\Progra~1\Micros~1\Office\MSACCESS.EXE
> >> d:\inetpub\odbcsources\AccessDB.mdb
> >> /compact d:\inetpub\odbcsources\AccessDB.mdb
> >>
> >> -----Original Message-----
> >> From: John Cesta - Lists [mailto:[EMAIL PROTECTED]]
> >> Sent: Monday, March 19, 2001 6:20 PM
> >> To: CF-Server
> >> Subject: repair and compact DBs
> >>
> >>
> >>
> >>
> >> Does anyone know of a program that can repair and compact ODBC Access
> >> databases from the command line?
> >>
> >> Maybe it would take the DB as an argument and repair and compact it.
> >>
> >> John Cesta
> >>
> >>
> >>
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
