Re^2: 'use database' for sqlserver

Replies are listed 'Best First'.
Re^3: 'use database' for sqlserver by roboticus (Chancellor) on May 22, 2013 at 13:54 UTC
fionbarr: I'd be surprised if `$dbh->do("use $database")` didn't work. Did you try it and have it fail? ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply] [d/l]
Re^4: 'use database' for sqlserver by fionbarr (Friar) on May 22, 2013 at 14:25 UTC
I did try it and it failed.	[reply]
Re^5: 'use database' for sqlserver by mje (Curate) on May 23, 2013 at 08:35 UTC
$ perl -le 'use DBI; my $h = DBI->connect("dbi:ODBC:DRIVER={Easysoft O +DBC-SQL Server};server=172.20.0.39\\SQLEXPRESS;UID=xxx;PWD=yyy;"); $h +->{RaiseError} = 1;$h->do(q/use master/); $ echo $? 0 $ perl -le 'use DBI; my $h = DBI->connect("dbi:ODBC:DRIVER={Easysoft O +DBC-SQL Server};server=172.20.0.39\\SQLEXPRESS;UID=xxx;PWD=yyy;"); $h +->{RaiseError} = 1; $h->do(q/use fred/);' DBD::ODBC::db do failed: [unixODBC][Easysoft][SQL Server Driver 11.0][ +SQL Server]Database 'fred' does not exist. Make sure that the name is + entered correctly. (SQL-08004) at -e line 1. [download] I don't have a 'fred' database. Works for me but of course your probably using a different ODBC driver for SQL Server.	[reply] [d/l]