CREATE DATABASE fails in DBD::ADO 2.75-2.83

From: Ed Belisle (ebelisle_at_ix.netcom.com)
Date: 12/24/03

  • Next message: John: "Automatng import" 
    Date: Wed, 24 Dec 2003 13:29:41 -0700
To:  dbi-users@perl.org

    support for CREATE and DROP DATABASE appears to have stopped working
    between DBA::ADO versions 2.74 and 2.75. I have tested with MDAC 2.7
    SP1 and MDAC 2.8 RTM, and all DBD::ADO Versions from 2.70 through 2.83.

    It appears the results are erroneously interpreted as failing.

    For both queries, the command executes properly (a database is created
    or destroyed), err is set, and the errstr is populated with information
    messages of the successful execution.

    Details are below.

    Thanks

    Ed Belisle

    DETAILS

    I am running SQL Server 2000 on MyMachine. My connection string is:

    DBI:ADO:DRIVER={SQL
    Server};SERVER=MyMachine;CommandTimeout=900;DATABASE=bob_home;Trusted
    Connection=Yes

    For the query: 'DROP DATABASE [BOB_1500]', my result is

    err=-1
    errstr=
    Can't execute statement 'DROP DATABASE [BOB_1500]':
             Description : [Microsoft][ODBC SQL Server Driver][SQL
    Server]Deleting database file 'C:\data\mssql\log\\BOB_1500_log.LDF'.
             HelpContext :
                HelpFile :
             NativeError : 3738
                  Number : 265946
                  Source : Microsoft OLE DB Provider for ODBC Drivers
                SQLState : 01000

             Description : [Microsoft][ODBC SQL Server Driver][SQL
    Server]Deleting database file 'C:\data\mssql\data\\BOB_1500.mdf'.
             HelpContext :
                HelpFile :
             NativeError : 3738
                  Number : 265946
                  Source : Microsoft OLE DB Provider for ODBC Drivers
                SQLState : 01000

    For the query: 'CREATE DATABASE BOB_1500', my result is
    err=-1
    errstr=
    Can't execute statement 'CREATE DATABASE BOB_1500':
             Description : [Microsoft][ODBC SQL Server Driver][SQL
    Server]The CREATE DATABASE process is allocating 0.88 MB on disk 'BOB_1500'.
             HelpContext :
                HelpFile :
             NativeError : 1805
                  Number : 265946
                  Source : Microsoft OLE DB Provider for ODBC Drivers
                SQLState : 01000

             Description : [Microsoft][ODBC SQL Server Driver][SQL
    Server]The CREATE DATABASE process is allocating 0.49 MB on disk
    'BOB_1500_log'.
             HelpContext :
                HelpFile :
             NativeError : 1805
                  Number : 265946
                  Source : Microsoft OLE DB Provider for ODBC Drivers
                SQLState : 01000

  • Next message: John: "Automatng import"

    Relevant Pages

    • RE: USE Command With Dynamic Database Names Fails to Change Database
      ... "Changes in database context last only until the end of the EXECUTE statement" ... > stored procedures. ...
      (microsoft.public.sqlserver.programming)
    • Re: High Avg. Disk Queue Length When Opening Shared Calendars
      ... Let's assume 10K spindles, a 3:1 read/write ratio, and IOPS/user of 1. ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... A disk bottleneck on the database LUN. ...
      (microsoft.public.exchange.admin)
    • Re: Oracle Performance -- Possible Disk Bottleneck
      ... I've read that 15k drives can perform 180 IO's per second. ... confirm this is a disk bottle neck. ... so I'm hoping someone here has experience with SANs and ORACLE to help ... this is a disk bottleneck and that giving the database more spindles ...
      (comp.databases.oracle.server)
    • Re: Chaotic IMAP Message list
      ... bits of the database which are scattered about on your hard disk into a new ... break at an unfortunate location in the database. ... I was busy and didnšt read carefully so I thought you were advocating the more complete rebuild solution. ... or can you offer a thumbnail explanation of what happened and why a compact would fix it? ...
      (microsoft.public.mac.office.entourage)
    • [PATCH] inotify: add hook to catch fsync/msync events
      ... I actually excluded msync events when the MS_ASYNC flag is specified. ... application will perform an fsync to safely store data on disk. ... In my specific case I am using a database engine that supports ... +static inline void fsnotify_sync ...
      (Linux-Kernel)