the Connection to SQL server DB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 8 of 8

Thread: the Connection to SQL server DB

  1. #1
    waleed Guest

    the Connection to SQL server DB


    Hi All,

    Please , any body can help me ..
    I want a simple compelte code to connect to SEL server and retrive any record.
    Thanks,
    Regards,

  2. #2
    java java Guest

    Re: the Connection to SQL server DB



    people would like to know that what kind of JDBC driver are you using

    "waleed" <waleedmkamel@hotmail.com> wrote:
    >
    >Hi All,
    >
    >Please , any body can help me ..
    >I want a simple compelte code to connect to SEL server and retrive any record.
    >Thanks,
    >Regards,



  3. #3
    Guest

    Re: the Connection to SQL server DB


    "waleed" <waleedmkamel@hotmail.com> wrote:
    >
    >Hi All,
    >
    >Please , any body can help me ..
    >I want a simple compelte code to connect to SEL server and retrive any record.
    >Thanks,
    >Regards,


    Hi ,
    Use ADO to connect to SQL Server 2000.Please check the Microsoft site to
    for more
    details. In Microsoft site search for MDAC and you will get lot of reference.
    Regards
    Francis

    francis.tedeus@sympatico.ca





  4. #4
    Guest

    Re: the Connection to SQL server DB


    if you have software sql find in help there are connections examples

  5. #5
    Wessel Mans Guest

    Re: the Connection to SQL server DB


    <java.@127.0.0.1> wrote:
    >
    >"waleed" <waleedmkamel@hotmail.com> wrote:
    >>
    >>Hi All,
    >>
    >>Please , any body can help me ..
    >>I want a simple compelte code to connect to SEL server and retrive any

    record.
    >>Thanks,
    >>Regards,

    >
    >Hi ,
    >Use ADO to connect to SQL Server 2000.Please check the Microsoft site to
    >for more
    >details. In Microsoft site search for MDAC and you will get lot of reference.
    >Regards
    >Francis
    >
    >francis.tedeus@sympatico.ca
    >
    >
    >
    >

    Hi
    Ihave found Microsoft SQL Server 2000 Driver for JDBC
    Version 2.2 Patch 1 on the Microsoft site. i have not
    implemented it yet but it is wortha try
    Regards
    Wessel
    visisol@telkomsa.net


  6. #6
    MarkN Guest

    Re: the Connection to SQL server DB



    >>

    >Hi
    >Ihave found Microsoft SQL Server 2000 Driver for JDBC
    >Version 2.2 Patch 1 on the Microsoft site. i have not
    >implemented it yet but it is wortha try


    I downloaded it and used it. It works fine. I think it comes with examples
    on how to set it up. After setting the basic params, everything else is
    the same.

  7. #7
    MarkN Guest

    Re: the Connection to SQL server DB


    >Hi ,
    >Use ADO to connect to SQL Server 2000.Please check the Microsoft site to
    >for more
    >details. In Microsoft site search for MDAC and you will get lot of reference.


    Great idea except he is probably using Java since this is a Java discussion
    group. On the other hand, since 99.99% of the posters in the SQL discussion
    ask Database Specific questions, so who knows.

  8. #8
    Russ Guest

    Re: the Connection to SQL server DB


    "waleed" <waleedmkamel@hotmail.com> wrote:
    >
    >Hi All,
    >
    >Please , any body can help me ..
    >I want a simple compelte code to connect to SEL server and retrive any record.
    >Thanks,
    >Regards,


    Check out http://www.eazydb.com

    EasyDB is a unique API which provides a way of building web based database
    applications. There are two primary ways of providing this functionality,
    each of which has pros and cons.
    A two-tier architecture consists of a client tier and a database tier. This
    type of architecture most often leads to very large client side code. This
    is not a problem if the client is a stand-alone application. However, this
    presents some very serious performance issues when the client is a web based
    applet. The sheer size of the applet with all the normal database support
    libraries makes this approach very undesirable from a users point of view.
    They must wait for the entire applet to download to their machine before
    they can began to use it. Even though the two-tier approach is somewhat
    easy to use, it does not provide the flexibility needed for a light weight
    web based database application. Furthermore, the data being sent back to
    the client could consist of very large result sets which will also tend to
    frustrate the user if it takes an unusual amout of time.

    A three-tier architecture is similar to the two-tier architecture, except
    that it includes a module that sits between the client and the database.
    This module, or middle tier of this type of architecture, acts as a "middleman"
    in the database communications between the client and the database. This
    approach is by the far the most flexible and is the core concept of EasyDB.
    By having a middle man in our design we can offload all the database access
    to a java servlet or ASP script. This makes our client smaller. In fact,
    the EasyDB client side API adds just over 20k to the overall size of the
    applet! That's almost as impressive as the built-in on-the-fly data compression
    capability of EasyDB. The built in compression can achieve performance gains
    up to 4 times faster than what it takes to receive data from the remote database
    server without compression.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center