roho has asked for the wisdom of the Perl Monks concerning the following question:
When I prepend "ADMIN:" to the server name in my DBI connection string I get the following error message:
DBI connect('Driver={SQL Server};Server=ADMIN:localhost\SQLEXPRESS;Database=pubs','sa',...) failed: MicrosoftODBC SQL Server DriverDBNETLIBSQL Server does not exist or access denied. (SQL-08001) state was 08001 now 01000
When I add the DAC listening port to the end of the server name in my DBI connection string I get the following error message:
DBI connect('Driver={SQL Server};Server=localhost\SQLEXPRESS,60488;Database=pubs','sa',...) failed: MicrosoftODBC SQL Server DriverDBNETLIBInvalid connection. (SQL-08001) state was 08001 now 01000
I have tried Super Search and Google, and have come up empty. Does anyone know how to establish a DAC connection to SQL Server using DBI?
Thanks.
UPDATE: Also posted to dbi-users@perl.org
"Its not how hard you work, its how much you get done."
|
|---|