Avatar billede long Nybegynder
14. juli 1999 - 11:17 Der er 6 kommentarer og
1 løsning

Hvad betyder alt det vedr DBQ

Hvad betyder alt dette, og hvordan kan jeg optimere det ?

"DBQ=" & Server.MapPath("../minDB.mdb") & ";
DefaultDir=../;
Driver={Microsoft Access Driver (*.mdb)};
DriverId=25;
FIL=MSAccess;
ImplicitCommitSync=Yes;
MaxBufferSize=512;
MaxScanRows=8;
PageTimeout=5;
SafeTransactions=0;
Threads=3;
UID=admin;
UserCommitSync=Yes;
,admin"
Avatar billede 127144146281 Nybegynder
14. juli 1999 - 13:37 #1
DBQ er stien tril databsen, du kan sagtens fjerne det meste af det der står f.eks:

"DBQ=" & Server.MapPath("../minDB.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Avatar billede 127144146281 Nybegynder
14. juli 1999 - 13:38 #2
Eller hvis databasen ligger i samme mappe som ASP scriptet kan man bare bruge:

"DBQ=" & Server.MapPath("minDB.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Avatar billede long Nybegynder
14. juli 1999 - 13:46 #3
Så langt er jeg med, men vil gerne vide hvad de andre ting er til ...
Avatar billede floffy Nybegynder
14. juli 1999 - 14:58 #4
Se i hjælpen under ODBC-manager. Der er det forklaret.
Avatar billede flemming Nybegynder
15. juli 1999 - 13:01 #5
Jeg har lagt den fulde og offecielle  forklaring på parametrene her:

http://www.clan.dk/q2bench/odbc.htm

Hvad precis er det du vil optimere. generelt bør du ikke ændre default indstillingerne med mindre du har problemer.

mvh Flemming
Avatar billede long Nybegynder
15. juli 1999 - 13:45 #6
Fint nok !

Det var det jeg ville ha' :

Keyword Description
CHARACTERSET    For the Text driver, OEM or ANSI.
COLLATINGSEQUENCE      The sequence in which the fields are sorted.When the dBASE or Microsoft FoxPro driver is used, the sequence can be: ASCII (the default) or International.When the Paradox driver is used, the sequence can be: ASCII (default), International, Swedish-Finnish, or Norwegian-Danish.This sets the same option as the Collating Sequence control in the setup dialog box.
COLNAMEHEADER  For the Text driver, indicates whether the first record of data will specify the column names. Either TRUE or FALSE.
COMPACT_DB      For the Microsoft Access driver, performs data compaction on a database file.
CREATE_DB      For the Microsoft Access driver, creates a database file. Has the following format: CREATE_DB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used. When using the CREATE_DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples:“C:\PROGRAM FILES\COMMON FILES\
MyAccess.mdb”“C:\PROGRAM FILES\Access2.mdb”CREATE_DB=C:\TEMP\test.mdb (no quotation marks needed)
CREATE_SYSDB    For the Microsoft Access driver, creates a system database file. Has the following format: CREATE_SYSDB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used.
CREATE_V2DB    For the Microsoft Access driver, creates a database file that is compatible with Microsoft Access 2.0. Has the following format: CREATE_V2DB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used. When using the CREATE_V2DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples:“C:\PROGRAM FILES\COMMON FILES\
MyAccess.mdb”“C:\PROGRAM FILES\Access2.mdb”CREATE_V2DB=C:\TEMP\test.mdb (no quotation marks needed)
DBQ    For the Microsoft Access or Paradox driver, the name of the database file.For the Microsoft Excel driver when accessing Microsoft Excel 5.0, 7.0, or 97 files, the name of the workbook file.This sets the same option as the Database control in the setup dialog box.
DEFAULTDIR      The path specification to the database file (for the Microsoft Access driver) or directory (for the dBASE, Microsoft Excel, Microsoft FoxPro, Paradox, or Text driver). This sets the same option as the Select Directory control in the setup dialog box, or for Microsoft Excel, the Select Workbook control in the setup dialog box.
DELETED For the dBASE or Microsoft FoxPro driver, specifies whether or not rows that have been marked as deleted can be retrieved or positioned on. If set to 1, deleted rows are not displayed; if set to 0, deleted rows are treated the same as non-deleted rows. The default is unchecked. This sets the same option as the Show Deleted Rows control in the setup dialog box.
DESCRIPTION    A description of the data in the data source.This sets the same option as the Description control in the setup dialog box.
DRIVER  The path specification to the driver DLL.
DRIVERID        An integer ID for the driver.
  25 (Microsoft Access)
  21 (dBASE III)
  277 (dBASE IV)
  533 (dBASE 5.0)
  534 (Microsoft Excel 3.0)
  278 (Microsoft Excel 4.0)
  22 (Microsoft Excel 5.0/7.0)
  790 (Microsoft Excel 97)
  24 (Microsoft FoxPro 2.0)
  280 (Microsoft FoxPro 2.5)
  536 (Microsoft FoxPro 2.6)
  26 (Paradox 3.x)
  282 (Paradox 4.x)
  538 (Paradox 5.x)
  27 (Text)
EXCLUSIVE      Determines whether the database will be opened in exclusive mode (accessed by only one user at a time) or shared mode (accessed by more than one user at a time). Can be true (exclusive mode) or false (shared mode). (This does not apply to the Microsoft Excel or Text driver.)This sets the same option as the Exclusive control in the setup dialog box.
EXTENSIONS      Lists the file name extensions of the Text files on the data source. This sets the same option as the Extensions List control in the setup dialog box.
FIL    File type
  MS Access for Microsoft Access
  dBase III, dBase IV, or dBase 5
  Excel 3.0, 4.0, 5.0, 7.0, or 97 for Microsoft Excel
  FoxPro 2.0, 2.5, or 2.6 for Microsoft FoxPro
  Paradox 3.x, 4.x, or 5.x)
  Text.
FILETYPE        File type for the Text driver (Text).
FIRSTROWHASNAMES        For the Microsoft Excel driver, indicates whether the cells of the first row of the range contain the column names for the table (1) or not (0).
FORMAT  For the Text driver, can be FIXEDLENGTH, TABDELIMITED, CSVDELIMITED (by a comma), or DELIMITED() (by the special character specified in the parentheses). The special character is one character in length and can be in character, decimal, or hexadecimal format.
IMPLICITCOMMITSYNC      Determines whether the Microsoft Access driver will perform internal or implicit commits asynchronously. This value is initially set to “Yes”, which means that the Microsoft Access driver will wait for commits in an internal/implicit transaction to be completed. The value of this option should not be changed without careful consideration of the consequences. For more information on the option, see the the Microsoft Jet Database Engine Programmers’s Guide.This sets the same option as the ImplicitCommitSync control in the setup dialog box.
MAXBUFFERSIZE  The size of the internal buffer, in kilobytes, that is used by Microsoft Access to transfer data to and from the disk. The default buffer size is 512K (displayed as 512). Any integer value divisible by 256 can be used. This sets the same option as the Buffer Size control in the setup dialog box.
MAXSCANROWS    For the Microsoft Access, Microsoft Excel, or Text driver, the number of rows to be scanned when setting a column's data type based upon existing data.A number from 1 to 16 can be entered for the rows to scan. The value defaults to 8; if it is set to 0, all rows are scanned. (A number outside the limit will return an error.) For the Text driver, you can enter a number from 1 to 32767 for the number of rows to scan; however, the value will always default to 25. (A number outside the limit will return an error.) This sets the same option as the Rows to Scan Control in the setup dialog box.
PAGETIMEOUT    Specifies the period of time, in tenths of a second, that a page (if not used) remains in the buffer before being removed. For the Microsoft Access driver, the default is 5 tenths of a second (0.5 seconds). For the dBASE, Microsoft FoxPro, and Paradox drivers, the default is 600 tenths of a second (60 seconds). Note that this option applies to all data sources that use the ODBC driver. This sets the same option as the Page Timeout control in the setup dialog box.
PARADOXNETPATH  For the Paradox driver, the full path of the directory containing a Paradox lock database, because it contains either the PDOXUSRS.net file (in Paradox 4.x) or the PARADOX.net file (in Paradox 5.x). If the directory does not contain one of these files, the Paradox driver creates one. For information about these files, see the Paradox documentation.Before a network directory can be selected, a Paradox user name must be entered. This sets the same option as the Select Network Directory control in the Paradox setup dialog box.
PARADOXNETSTYLE For the Paradox driver, the network access style to use when accessing Paradox data: either “3.x” for Paradox 3.x or “4.x” for Paradox 4.x or 5.x. Can be set to “3.x” or “4.x” if the version is Paradox 4.x or 5.x; if the version is Paradox 3.x, the style must be “3.x”. This sets the same option as the Net Style control in the Paradox setup dialog box.
PARADOXUSERNAME For the Paradox driver, the Paradox user name. This sets the same option as the User Name control in the Paradox setup dialog box.
PWD    For the Microsoft Access or Paradox driver, the password.For the Paradox driver, this is an optional keyword and will never be written to the file by the driver. It is used in a call to SQLDriverConnect against password-secured Paradox files.
READONLY        TRUE to make file read-only; FALSE to make file not read-only. This sets the same option as the Read-Only control in the setup dialog box.
REPAIR_DB      For the Microsoft Access driver, repairs a database damaged by a failure that occurs during the commit process.
STATISTICS      For the dBASE or Microsoft FoxPro driver, determines whether table size statistics are approximated. Note that this option applies to all data sources that use the ODBC driver. This sets the same option as the Approximate Row Count control in the setup dialog box.
SYSTEMDB        For the Microsoft Access driver, the path specification to system database file. This sets the same option as the System Database control in the setup dialog box.
THREADS The number of background threads for the engine to use. For the Microsoft Access driver, this value defaults to 3, but can be changed. For the dBASE, Microsoft Excel, Microsoft FoxPro, Paradox, and Text drivers, this value is 3, and cannot be changed. This sets the same option as the Threads control in the setup dialog box.
UID    For the Microsoft Access driver, the user ID name used for login.
USERCOMMITSYNC  Determines whether the Microsoft Access driver will perform user-defined transactions asynchronously. This value is initially set to “Yes”, which means that the Microsoft Access driver will wait for commits in a user-defined transaction to be completed. The value of this option should not be changed without careful consideration of the consequences. For more information on the option, see the the Microsoft Jet Database Engine Programmers’s Guide.This sets the same option as the UserCommitSync control in the setup dialog box.
Avatar billede flemming Nybegynder
16. juli 1999 - 00:06 #7
Godt nok ;=)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester