Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS Digest, Vol 32, Issue 22

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: V mar <vpolv AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] FreeTDS Digest, Vol 32, Issue 22
  • Date: Thu, 29 Sep 2005 07:57:04 -0700 (PDT)

Do you have any contact number. Where I can call
explain my problem. Or may be some one can get on our
machine using putty and look into the problem.
Our company will pay the fees.

Thanks

venkat


--- freetds-request AT lists.ibiblio.org wrote:

> Send FreeTDS mailing list submissions to
> freetds AT lists.ibiblio.org
>
> To subscribe or unsubscribe via the World Wide Web,
> visit
> http://lists.ibiblio.org/mailman/listinfo/freetds
> or, via email, send a message with subject or body
> 'help' to
> freetds-request AT lists.ibiblio.org
>
> You can reach the person managing the list at
> freetds-owner AT lists.ibiblio.org
>
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of FreeTDS digest..."
>
>
> Today's Topics:
>
> 1. Re: Record has no fields (?????? ???????
> ?????????)
> 2. Re: problem with connection (cant assign
> address) (martin)
> 3. Re: MS SQL Server Lockup More Information
> (Lowden, James K)
>
>
>
----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 28 Sep 2005 13:06:00 +0400
> From: ?????? ??????? ?????????
> <VZverev AT genesis.spb.ru>
> Subject: Re: [freetds] Record has no fields
> To: "FreeTDS Development Group"
> <freetds AT lists.ibiblio.org>
> Message-ID:
> <4B1A3038F9F9DF47913BAC08BC087DB5638009 AT MUN.gen>
> Content-Type: text/plain; charset="koi8-r"
>
> HI Aaron,
> The 'customer_vw' table should be accessible from
> database noted in ODBCINI / HS_FDS_CONNECT_INFO or
> you should assign it explicitly before select:
> DECLARE
> c INTEGER;
> begin
> c:= DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@SC('use
> _bla_bla_bla_');
> end;
>
> By default HS uses upper cased column name notation
> and it can be a cornerstone of your problem. You
> should try to rewrite select in case-sensitive
> style: select "Exact_CoLuMn_NaMe" from
> customer_vw@sc If you doubt in translated HS
> case-sensitive column names, try this:
>
> select column_name
> from dba_tab_columns@sc
> where lower(table_name) like 'customer_vw'
>
> Sincerely yours.
>
>
-------------------------------------------------------
> Vitaly Zverev, OCP DBA 8&8i
> Oracle E-Business Suite &
> Infiniband Linux Cluster Administrator
> Genesis Ltd., St.Petersburg, Russia
>
>
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf
> Of apfuller AT dart.net.au
> Sent: Wednesday, September 28, 2005 4:35 AM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Record has no fields
>
>
> Hi All,
>
> Something that has got me stumped...
>
> I've setup freetds 0.63 (latest stable ver) and
> unixODBC to connect my Oracle
> to SQL Server instance in UNIX. So far I can use
> isql to query, create, insert
> etc against sql server, however when I try and query
> through sqlplus using a
> database link I get the following sorts of
> returns...
>
> 1.
> select * from all_catalog@SC
> --this works. Brings back tables for dbo and other
> users
>
> 2.
> SQL> select * from "customer_vw"@SC;
> select * from "customer_vw"@SC
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> [Generic Connectivity Using ODBC]DRV_DescribeTable:
> Record customer_vw has no fields. Loading failed
> ORA-02063: preceding 2 lines from SC
>
>
> I've read that it was a bug in previous versions of
> freetds, can I presume that
> it is ok in .63?
>
> Also I have tried many different variants
> of "customer_vw"@SC
> "serviceCentre"."customer_vw"@SC etc, none seem to
> work.
> I can only select from system tables.
>
> Any thoughts would be most appreciated,
>
> Cheers,
>
> Aaron
>
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 28 Sep 2005 04:19:51 -0700
> From: martin <martin AT allbsd.com>
> Subject: Re: [freetds] problem with connection (cant
> assign address)
> To: FreeTDS Development Group
> <freetds AT lists.ibiblio.org>
> Message-ID: <433A7C57.1050502 AT allbsd.com>
> Content-Type: text/plain; charset=ISO-8859-1;
> format=flowed
>
> it is on FreeBSD 4.10
>
> here is the script i am running. its basically a
> cli php script run
> from the shell
>
> #!/usr/local/bin/php -q
> <?php
>
> for ($i = 1; $i < 10000; ++$i){
> echo $i . "\n";
>
> if (!$cn =
>
mssql_connect("TRANSMISSION_SQL_SERVER","c21727-1","xxxxxxxx")){
> echo "fail\n";
> die();
> } else {
> mssql_close($cn);
> }
>
>
> }
> ?>
>
>
> it just opens and closes a connection until it cant
> make the connection
> .. then exits.
>
> i hope this helps :)
>
> let me know if more info required
>
> thanks
>
> -ms
>
>
> Daniel Fazekas wrote:
> > On Sep 28, 2005, at 2:38, martin wrote:
> >
> >
> >>net.c:220:tds_open_socket: 70.86.110.194:1433:
> Can't assign requested
> >>address
> >>i am not sure if this is indicative of anything
> but the problem occurs
> >>every time at the 7954'th iteration of the script.
> >
> >
> > It appears a simple connect() call is failing.
> That it fails only
>
=== message truncated ===




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com




Archive powered by MHonArc 2.6.24.

Top of Page