Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: rconner AT commspeed.net
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Sybase error
  • Date: Thu, 22 Apr 2004 11:42:29 -0700 (MST)

Thanks for the feedback

dbo_AMATS_Equipments is the name of the table. So I think that that is as
it should be. I think what you mean would be the colums under that table
like columname.dbo_AMATS_Equipments

Yes?

Conner


> On Thu, 2004-04-22 at 19:41, rconner AT commspeed.net wrote:
>> Thanks for the reply,
>>
>> Yes I tried that. The problem seems to be the dbo_AMATS_Equipments.
>> Any
>> other Ideas?
>
> Shouldn't that be dbo.AMATS.Equipments ?
>
> Michael
>
>>
>> > Have you tried the query without prefacing the column names with the
>> table
>> > name?
>> >
>> > i.e.:
>> > SELECT EquipmentID, Model FROM dbo_AMATS_Equipments
>> >
>> > Deven
>> >
>> >
>> >
>> > On Thursday 22 April 2004 07:15 am, rconner AT commspeed.net wrote:
>> >> I am having a bit of a problem pulling information down with an SQL
>> >> SELECT
>> >> statment. I connect to the db fine but then the SELECT statement is
>> >> causing an error.
>> >>
>> >> Here is what I have.
>> >> ---------------------------------------------------
>> >> $query = "SELECT dbo_AMATS_Equipments.EquipmentID,
>> >> dbo_AMATS_Equipments.Model FROM dbo_AMATS_Equipments";
>> >>
>> >> $result = mssql_query($query);
>> >> $numRows = mssql_num_rows($result);
>> >>
>> >>
>> >> while($row = mssql_fetch_array($result))
>> >> {
>> >> echo "<br>$row[1]</br>";
>> >> }
>> >>
>> >> ?>
>> >> ---------------------------------------------
>> >> and it returns this.
>> >>
>> >> Connected to TEST Server
>> >> Connected to TEST db
>> >>
>> >> Warning: mssql_query(): Sybase message: Invalid object name
>> >> 'dbo_AMATS_Equipments'. (severity 16) in
>> >> /usr/local/apache2/htdocs/AMATS_test.php on line 26
>> >>
>> >> Warning: mssql_num_rows(): is not a Sybase result index in
>> >> /usr/local/apache2/htdocs/AMATS_test.php on line 27
>> >>
>> >> Warning: mssql_fetch_array(): is not a Sybase result index in
>> >> /usr/local/apache2/htdocs/AMATS_test.php on line 30
>> >>
>> >> I am using an Access frontend that you can actually create SQL
>> >> statements
>> >> in, so I am pretty sure the dbo_AMATS_Equipments is valid. I
>> currently
>> >> use the same method to create SELECT statements for the MySQL
>> database.
>> >> Can someone shed some light on the errors?
>> >>
>> >> Thanks
>> >>
>> >> Conner
>> >>
>> >> _______________________________________________
>> >> FreeTDS mailing list
>> >> FreeTDS AT lists.ibiblio.org
>> >> http://lists.ibiblio.org/mailman/listinfo/freetds
>> > _______________________________________________
>> > FreeTDS mailing list
>> > FreeTDS AT lists.ibiblio.org
>> > http://lists.ibiblio.org/mailman/listinfo/freetds
>> >
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> --
> Michael Peppler Data Migrations, Inc.
> mpeppler AT peppler.org http://www.peppler.org/
> Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
> or long term contract positions - http://www.peppler.org/resume.html
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>





Archive powered by MHonArc 2.6.24.

Top of Page