freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Odd problem round 2.

From: Michael Peppler <mpeppler AT peppler.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: Odd problem round 2.
Date: Tue, 2 Jan 2001 16:36:40 -0800 (PST)

Tim Uckun writes:
>
> >Tim Uckun wrote:
> > > $server= sybase_connect('192.168.0.4' , 'web' , 'web');
> > > $connectionID = sybase_select_db('crims', $server);
> >
> >My code just does a sybase_connect(), there is no attempt to select a
> >database. No idea if that is significant.
>
> How does it know which database to use?

It'll use the default database for the "web" user (see sp_defaultdb).

In any case you can also change your SQL to fully qualify the tables
(including the database and the owner).

Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com

Odd problem round 2., Tim Uckun, 01/02/2001
- <Possible follow-up(s)>
- Re: Odd problem round 2., James Cameron, 01/02/2001
- Re: Odd problem round 2., Tim Uckun, 01/02/2001
- Re: Odd problem round 2., Michael Peppler, 01/02/2001
- Re: Odd problem round 2., James Cameron, 01/02/2001
- Re: Odd problem round 2., D. J. Hagberg, 01/02/2001
- Re: Odd problem round 2., Tim Uckun, 01/03/2001
- Re: Odd problem round 2., James K. Lowden, 01/03/2001
- Re: Odd problem round 2., Tim Uckun, 01/03/2001
- Re: Odd problem round 2., Lowden, James K, 01/04/2001
- Re: Odd problem round 2., Brian Bruns, 01/21/2001
- Re: Odd problem round 2., Brian Bruns, 01/21/2001