Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

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,
[157 byte] By [waleed] at [2007-11-9 22:31:44]
# 1 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,
java java at 2007-11-11 23:02:06 >
# 2 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
at 2007-11-11 23:03:07 >
# 3 Re: the Connection to SQL server DB
if you have software sql find in help there are connections examples
at 2007-11-11 23:04:14 >
# 4 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
Wessel Mans at 2007-11-11 23:05:09 >
# 5 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.
MarkN at 2007-11-11 23:06:19 >
# 6 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.
MarkN at 2007-11-11 23:07:13 >
# 7 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.
Russ at 2007-11-11 23:08:12 >