Printable View
I'm looking for a JDBC MS SQL Server driver type 4. I will also have the
need to connect to other servers such as Oracle, Sybase, DB2 in the future.
Our application is Internet Based, but the back-end database will reside
at the customer site. I do not really want to load software on the client
and or the back-end database server, that is why I'm looking at type 4 drivers.
Any suggestions on Vendors/implementation would be greatly appreciated!
...Eric
"Eric Ries" <eries@sagencesystems.com> wrote:
>
>I'm looking for a JDBC MS SQL Server driver type 4.
Try i-net Una driver, from i-net software.
http://www.inetsoftware.de/
>I will also have the
>need to connect to other servers such as Oracle, Sybase, DB2 in the future.
The Una Driver can do that for Oracle and Sybase, not sure about DB2. Why
do you use so many different ones? You should pick a database system and
use that.
> Our application is Internet Based, but the back-end database will reside
>at the customer site. I do not really want to load software on the client
>and or the back-end database server, that is why I'm looking at type 4 drivers.
> Any suggestions on Vendors/implementation would be greatly appreciated!
OK... now it gets complicated. When you talk about Internet-based, I hope
you don't mean you're using an applet. If you must use JDBC on the web, it
can be a real headache, and can open up a big security hole. Java applications
are another story. As long as you can figure out the path to your server,
JDBC access from a Java application is easy. However, if you really don't
want to load any software (meaning no applets or applications) on other computers,
and want your database to be accessible from the web, then you need to use
Java Server Pages. You will not have the same security problems with JSP,
(similar issues to applications). I have done this stuff in our company,
so if you have some specific questions, let me know :)
/*********************************************
Have a great day :)
Dan Adamson dan.adamson@wallst.com
"Not to end a sentence with a preposition is a
rule, up with which, I do not intend to put!"
Winston Churchill
**********************************************/
In addition to inet for SQL server we use OracleThin for Oracle and JConnect
for Sybase.
-Arun
"Dan Adamson" <dna_man@yahoo.com> wrote:
>
>"Eric Ries" <eries@sagencesystems.com> wrote:
>>
>>I'm looking for a JDBC MS SQL Server driver type 4.
>
>Try i-net Una driver, from i-net software.
>http://www.inetsoftware.de/
>
>>I will also have the
>>need to connect to other servers such as Oracle, Sybase, DB2 in the future.
>
>The Una Driver can do that for Oracle and Sybase, not sure about DB2. Why
>do you use so many different ones? You should pick a database system and
>use that.
>
>> Our application is Internet Based, but the back-end database will reside
>>at the customer site. I do not really want to load software on the client
>>and or the back-end database server, that is why I'm looking at type 4
drivers.
>> Any suggestions on Vendors/implementation would be greatly appreciated!
>
>OK... now it gets complicated. When you talk about Internet-based, I hope
>you don't mean you're using an applet. If you must use JDBC on the web,
it
>can be a real headache, and can open up a big security hole. Java applications
>are another story. As long as you can figure out the path to your server,
>JDBC access from a Java application is easy. However, if you really don't
>want to load any software (meaning no applets or applications) on other
computers,
>and want your database to be accessible from the web, then you need to use
>Java Server Pages. You will not have the same security problems with JSP,
>(similar issues to applications). I have done this stuff in our company,
>so if you have some specific questions, let me know :)
>
>/*********************************************
> Have a great day :)
>Dan Adamson dan.adamson@wallst.com
>
>"Not to end a sentence with a preposition is a
>rule, up with which, I do not intend to put!"
> Winston Churchill
>**********************************************/
>
>
>
