FreeTDS Development Group

[Jose Geraldo de Oliveira <j.g.oliveira AT csu.com.br>]

Hi

In fact, i suggested a pure java application accessing SQL thru a MS JDBC
driver (or even a jtds driver) and Oracle thru Oracle JDBC driver but the
developper team don´t have java skill to do the job as quikly as our client
demands.

The option using C and Pro*C appears more quick to write only because the
programmers skill and the use of freetds to support SQL connections are
considered here more stable than MS JDBC driver.

I´m from the support team. This option ussing a SP with java accessing SQL
we didn´t thought but i don´t know if we have time to chenge the idea of the
project...

Our version is
MS SQL Server 2000 running on Windows 2000 machine
Oracle 8.1.7 (8i) running on RedHat Linux enterprise v2.1
Pro*C v10.2 and Freetds 0.62.1, running on a RedHat enterprise v3.0

We need to put a middle machine because Pro*c v10.2 isn´t certificate to
RHES v2.1


Thankx



-----Mensagem original-----
De: VZverev AT genesis.spb.ru [mailto:VZverev AT genesis.spb.ru]
Enviada em: segunda-feira, 6 de fevereiro de 2006 11:01
Para: FreeTDS Development Group
Assunto: Re: [freetds] RES: [SPAM] Re: Sample code[Scanned]


Welcome Jose,
which version of oracle server do you use? 

PS
If it is 8.1 or high you could try to wrap a java stored procedures around
jTds project or native jdbc driver.
I did exactly what you looking for but five years ago with 8.0. Then java
machine was raised as alternative SP engine by oracle and ... viola, because
extlib->proC->freetds performance was comparable with PL/Sql->jdbc call
stack. Even though I forgotten details but result remember excellent.

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 Jose 
> Geraldo de Oliveira
> Sent: Monday, February 06, 2006 2:41 PM
> To: 'FreeTDS Development Group'
> Subject: [freetds] RES: [SPAM] Re: Sample code[Scanned]
> 
> Hi
> 
> PHP is good but our project demands C, because the program 
> needs to use Pro*C from Oracle to connect to Oracle Database 
> and Freetds to connect to SQL database at the same time...
> 
> Thanx
> 
> 
> -----Mensagem original-----
> De: Pascal MIQUET [mailto:p.miquet AT hafiba.fr] Enviada em: 
> terça-feira, 31 de janeiro de 2006 05:56
> Para: FreeTDS Development Group
> Assunto: [SPAM] Re: [freetds] Sample code[Scanned]
> 
> 
> Hi,
> 
> You would like some PHP sample ?
> 
> Regards
> Pascal 
> 
> -----Message d'origine-----
> De : freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] De la part de Jose 
> Geraldo de Oliveira Envoyé : vendredi 27 janvier 2006 23:12 À 
> : freetds AT lists.ibiblio.org Objet : [freetds] Sample code[Scanned]
> 
> Hi All
> 
> Can anyone send me a little sample program to access a SQL 
> using only freetds (no ODBC) ?
> 
> Can be something very simple...
> 
> - connect
> - select anything
> - disconnect
> - quit
> 
> Thanks
> Jose Geraldo
> _______________________________________________
> 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
> 
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

!DSPAM:43e74af4912151533047104!