We are running iPlanet App Server SP3 on both Solaris, NT4, and Win2K using
Merant's Type4 JDBC Drivers for SQL Server, and they work great!
You can download a 30 Day eval from
http://www.merant.com/products/datadirect/download/eval/Licenses/connect_java.asp
* Add the 4 Merant jars to to the iPlanet classpath (using kregedit).
* Run jdbcsetup and create a new ODBC data source with the following params:
1. Driver Identifier: sqlserver
2. Driver Classname: com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
3. Driver Classpath: $SDKS_HOME\merant\JDBC\lib\sqlserver.jar
4. Third Party Native: (leave blank)
Then register using resreg with an xml file similar to the following:
<?xml version="1.0" encoding="UTF-8"?>
<ias-resource>
<resource>
<jndi-name>jdbc/sqlServer</jndi-name>
<jdbc>
<database-url>jdbc:sqlserver://SERVER:1433</database-url>
<database>DBNAME</database>
<username>USER</username>
<password>pass</password>
<driver-type>sqlserver</driver-type>
</jdbc>
</resource>
</ias-resource>
Hope this helps!
Matt
--- Mikkel Bruun <[EMAIL PROTECTED]> wrote:
> Hi Guys,
>
> A little of topic, but anyways...
>
> On a current project we will be running an webapp on Solaris, using
> Iplanet...
>
> Our application needs to connect to a MS Sql 7.0 running on a win 2k
> server...
>
> can you recommend any jdbc drivers???
>
> thanks a lot...
>
> ::
> Mikkel Bruun
> Senior IT Developer
> [EMAIL PROTECTED]
> Direct: +45 32 88 22 73
>
> Valtech A/S
> Kanonbaadsvej 10
> DK-1437 Copenhagen
> Tel +45 32 88 20 00
> Fax +45 32 88 20 20
>
>
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
