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=YesFor 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
