Results 1 to 3 of 3

Thread: Database Connection Drivers

  1. Nov 19th, 2007, 11:48 AM #1
    MethadoneBoy
    MethadoneBoy is offline

    Thread Starter
    Addicted Member MethadoneBoy's Avatar
    Join Date
    Oct 2001
    Location
    Preferably somewhere between Keira Knightley and Diane Kruger but I'm not fussy
    Posts
    180

    Database Connection Drivers

    Hi guys,

    I've been working with a couple of database applications and I'm currently using the Sun JDBC driver for all my connections -

    Code:
    "sun.jdbc.odbc.JdbcOdbcDriver"
    My question is basically what other kinds of driver are available and what are the advantages and disadvantages of each one? Are there any that you would prefer to use or does it depend on the kind of database you're connecting to?

    Thanks
    "'Oh, hello Mr. Crick! What do you think of Jeffrey Archer?' Clip-clip-clip! Oh, come on! Who are you kidding? You wait til I'm mayor, you'll see how tough I am! Christ almighty...."
    Reply With Quote Reply With Quote
  2. Nov 19th, 2007, 07:04 PM #2
    ComputerJy
    ComputerJy is offline
    Arabic Poster ComputerJy's Avatar
    Join Date
    Nov 2005
    Location
    Happily misplaced
    Posts
    2,513

    Re: Database Connection Drivers

    Well, where do I start!

    Your question requires a long research and I don't think you can find an easy answer to it.

    The JDBC driver is general and works for most DB connections. But as far as I know each of the well known DB servers provide it's own JDBC compatible driver for easier usage.

    I haven't tried many but the component for the MySql db works much faster than just using the simple JDBC connection. and comes with great tools and classes for us developers (to make out lives easier). but that doesn't mean that the JDBC driver is not as good -it was even better than the driver the community made for the MS-SQL Server 2000 until Microsoft released their version.

    So as far as I know it's just about easiness and performance (not in many cases)
    "I'm not normally a praying man, but if you're up there, save me... Superman!" - Homer Simpson
    My Blog
    Reply With Quote Reply With Quote
  3. Feb 3rd, 2008, 11:21 PM #3
    jetbrains
    jetbrains is offline
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Re: Database Connection Drivers

    We always use MERLIA as jdbc driver for the SQL Server,which supports ResultSetMetaData,XAConnection and SQLXML.
    Affordable Hosting
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width