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: martin <martin AT allbsd.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS Digest, Vol 32, Issue 22
  • Date: Thu, 29 Sep 2005 08:16:33 -0700

my problem turned out to not be a TDS problem (which is cool).
i needed to increase my outgoing port range. (upped from default 5000 to aout 20000 or 30000)
also ended up recompiling the kernel to increase maxusers so as to not run out of buffer space either.

thanks to anyone who made suggestions.

-martin

V mar wrote:
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
_______________________________________________
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