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









Reply via email to