Re: JDBC or ODBC?

Thanks for the reply!

To clarify, we are choosing between a server that sits on top of Windows
2000 Server that can use ODBC directly with SQL 2000, or a new version of the
same server that sits on top of a Java platform and uses JDBC (Type 4).
Either way we will not be using a bridge. Our concern is the performance
implication directly related to the database access interface. How does JDBC
compare with ODBC in this situation? Are there any reliability or
performance implications we need to consider? Thanks!
.

Relevant Pages

  • RE: BUG: JDBC connection disconnected, cant reconnect
    ... SQL 2005 Standard ... Windows Server 2003, Service Pack 2 ... SQLServer JDBC driver 1.2 ... Sun JDK 1.6 ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Cannot connect to my SQL 2005 server using JDBC - can any dia
    ... Do you have any references on which version of the Microsoft JDBC driver ... is talking about doesn't talk to UDP 1434 to retrieve the port automatically. ... I have seen some scenarios where not every JDBC drivers handles problems with the UDP broadcast from the SQL Browser service ... Cannot connect to my SQL 2005 server using JDBC - can any diagnostic tool tell me what the problem is? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Unblocking items in firewall - Symantec AntiVirus Corporate Edition
    ... > I sell a server based software product. ... > Symantec AntiVirus Corporate Edition product but one of my customers ... It will not block connection attempts. ... Is my JDBC connection code incorrect? ...
    (comp.security.firewalls)
  • Re: -952 Authentication Error on Solaris 10
    ... Then it sends the info into the server, ... causing Informix to barf on the authentication and then failing. ... Now I know and I'm looking at not using the Informix native jdbc ... driver but trying to use the informix jdbc driver that ships with the ...
    (comp.databases.informix)
  • Re: JDBC or ODBC?
    ... But if it came down to it, I bet I could beat slightly performance of JDBC ... The reason for this is ODBC ... we are choosing between a server that sits on top of Windows ... >> performance implication directly related to the database access ...
    (microsoft.public.sqlserver.jdbcdriver)