Re: Problem connecting to non-default db

[Chuck Fox]

Bilal,

Try just executing "use dbA" after the connection is made.  Another 
option is to directly reference the db in the query by using "select * 
from dbA.dbo.array".  A table can be referenced as tableName or 
ownerName.tableName or as  databaseName.ownerName.tableName.  Insofar as 
the bug, try ugrading to the latest dbd, I believe that 1.01 was just 
released.  We are using 1.0 and the issue with the db disappeared 
there.  I think the fix was in the 0.94 release.

Chuck

[EMAIL PROTECTED] wrote:

Hi,

Do you mean replace "dbname=dbA" with "dbname=dbB" in my connect string?
I've tried that.  Is there another way to switch the data source to
another db?
Is there any fix for this DBD::Sybase bug?

Thanks,
Bilal
On Thu, 11 Sep 2003, Chuck Fox wrote:

 

[EMAIL PROTECTED] wrote:

   

Hi, 

     

Hello,

   

I'm trying to connect to two ms sqlserver 2000 databases with the same schema 
(let's call them 
dbA and dbB) using the following code: 

my $connect_string  = "dbi:Sybase:dbname=dbA:server=MyServer"; 
$connect_string .= ";host=192.168.0.2;port=1433"; 

my $dbh = DBI->connect($connect_string, $username, $userpass, {PrintError => 
0}); 
die "Unable for connect to server $DBI::errstr" 
  unless $dbh; 

and in my freetds.conf I have: 

[MyServer] 
      host = 192.168.0.2 
      port = 1433 
      tds version = 4.2 
      try domain login = no 
      try server login = yes 

I have read access to both dbA and dbB.  However if dbB is my default db and I 
specify dbA as the dbname (as in the example above), or vice versa, when my 
script executes the following: 

     

Why not just "use dbB" or whichever is appropriate to the query ?  I 
seem to remember some bug in Sybase DBD that prevented it from 
using/processing the database specified in the connect string.

   

$sth = $dbh->prepare("select count(*) from array"); 
die "Unable for connect to server $DBI::errstr" unless $sth; 
if($sth->execute) { 
  while(my @dat = $sth->fetchrow) { 
              print "@dat\n"; 
  } 
} 

the data is retrieved from the default db rather than the one I specified (btw, 
yes, i know for sure that the "select count(*) from array" on both db's should 
return different numbers).  So I think that DBI's only connecting to the 
default db. 

As well, the statment 

print "Data sources: " . ($dbh->data_sources()) . "\n $DBI::errstr\n"; 

prints out no data sources. 

The DBD I'm using is DBD::Sybase running on the freetds library.  My script's 
running on a linux box and the sqlserver 2000 db's are on a windows 2000 adv 
server box. 

So any ideas on how I may get around this problem?  I would really appreciate 
any help. 

Thanks, 
Take care, 
Bilal 

     

HTH,

Chuck Fox
Principal DBA
America Online, INC