FreeTDS Development Group

[Stefanos Karasavvidis <stefos AT multimedia-sa.gr>]

your SQL server is on another machine (IP-address) than your web server, so a 
security
exception is thrown.

Applets may only connect to the server where they come from.

sk

Deniz TATAR wrote:

> Hi all,
>    I use FreeTDS @version  $Id: Driver.java,v 1.10 1999/02/22
> I will send a small code that I want to try to connect MSSQL Server 7.
> Our network protocol is TCP/IP, servers is NT40. I configured MSSQL Server
> to TCP/IP (not named pipes). So I wrote a simple applet and try to connect
> but I can't. I compiled the applet code succesfully. When I use Netscape
> Nevigator 4.75 for test my applet in Java Console (Netscape) I saw a
> message. The message is :
>  SQLException: security.Couldn't connect to 'DENIZ' with origin from ''.
>
> So what's the problem??? My OS is Windows 2000 Proffessional. MSSQL Server
> 7 is on the Windows NT 40 SP6.
>
> I need your helps...
>
> Thanks ....
>
> Deniz
>
> My sample code is below ;
>
>  public void ARAMAYI_BASLAT() {
>    String     URL = "jdbc:freetds:sqlserver://DENIZ:1433/NUFUSDATA"      ;
>    Connection BAGLANTI                         ;
>    String     SQL = "SELECT * FROM NUFUSTABLO WHERE NUF_SYD ='TATAR'" ;
>    Statement  STATEMENT                        ;
>    try {
>      Class.forName("com.internetcds.jdbc.tds.Driver");
>    }
>    catch(java.lang.ClassNotFoundException e) {
>      System.err.print("ClassNotFoundException: ");
>      System.err.println(e.getMessage());
>    }
>    try {
>      BAGLANTI = DriverManager.getConnection(URL, "sa", "");
>      STATEMENT = BAGLANTI.createStatement();
>      ResultSet RS = STATEMENT.executeQuery(SQL);
>      while ( RS.next() ) {
>        SAHIS = RS.getString("NUF_ADI") +
>                RS.getString("NUF_SYD") +
>                RS.getString("NUF_AAD") +
>                RS.getString("NUF_BAD") +
>                RS.getString("NUF_DTA") +
>                RS.getString("NUF_DYE") + "\n";
>        txtSONUC.append( SAHIS );
>      }
>      STATEMENT.close();
>      BAGLANTI.close();
>    }
>    catch(SQLException ex) {
>      System.err.println("SQLException: " + ex.getMessage());
>    }
>  } // ARAMAYI_BASLAT
>
> ---
> You are currently subscribed to freetds as: [stefos AT multimedia-sa.gr]
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
======================================================================
Stefanos Karasavvidis
Electronics & Computer Engineer
e-mail : stefos AT multimedia-sa.gr

Multimedia Systems Center S.A.
Kissamou 178
73100 Chania - Crete - Hellas
http://www.multimedia-sa.gr

Tel : +30 821 88447
Fax : +30 821 88427