freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
Re: [freetds] FreeTDS Digest, Vol 32, Issue 22,
V mar, 09/29/2005
- Re: [freetds] FreeTDS Digest, Vol 32, Issue 22, martin, 09/29/2005
Archive powered by MHonArc 2.6.24.