Skip to Content.
Sympa Menu

freetds - Re: configuring SQL Servers -- Really Really stuck

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: configuring SQL Servers -- Really Really stuck

Chronological Thread  
    < Chronological >       < Thread >
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: configuring SQL Servers -- Really Really stuck
  • Date: Tue, 17 Aug 1999 20:20:15 -0400 (EDT)

Hmmm....ok, 2 other things you must have a SYBASE environment variable set
to the installed directory, say:

export SYBASE=/usr/local/freetds

and for good measure, although not always necessary, add $SYBASE/lib to
your LD_LIBRARY_PATH (assumming linux...otherwise it may be LIBPATH or
some such)

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib

The other thing is I guess I should have mentioned that the user name and
password for the JDBC server is 'guest' and 'sybase' respectively.
Database is 'pubs2' if you care.

On Wed, 18 Aug 1999, Francis Smit wrote:

> Thank you for your help
> but I still don't get anywhere
> my default interfaces file looks like this:
> JDBC
> ??????? query tcp ether 192.138.151.39 4444
> ??????? master tcp ether 192.138.151.39 4444
>
> myserver
> ??????? query tcp ether 127.0.0.1 4000
> ??????? master tcp ether 127.0.0.1 4000
>
> myserver2
> ??????? query tcp ether 127.0.0.1 4001
> ??????? master tcp ether 127.0.0.1 4001
>
> and I have a php3 file like this:
> <html><head><title>Grislys PHP Test Page</title></head>
> <body bgcolor=green color=center>
>
> <h1 align=center><font color=aqua>Grislys PHP Test Page</font></h1>
> <hr>
> <br>
> <br>
> <br>
> <?php if(!isset($Btn))
> ????? {
> ??????? $con = mssql_connect("JDBC", "query", "");
> ??????? if($con > 0)
> ??????? {
> ????????? echo "cool \$con == $con\n";
> ??????? }else{
> ????????? echo "Bad \$con == $con\n";
> ??????? }
> ??????? mssql_close($con);
> ????? }else{? // if(!isset($Btn))? ....
> ????? }? // if(!isset($Btn))? ....
> ?>
> </body></html>
> and I get:
> Bad $con ==
> Warning: 0 is not a Sybase link index in
> /home/francis/public_html/ExDB.php3 on line 18
> in the body of the page I am sure this is really simple,
> when you know how? my problem is that I don't.
> any help would be greatly appreciated, thanks in advance.
> ?
>
> Brian Bruns wrote:
>
> The interfaces file should be located in the directory where
> freetds was
> install when you typed 'make install'. By default this is
> /usr/local/freetds.? There is a sample file in there with a
> couple of
> entries (if you have a connection to the internet you can use
> the 'JDBC'
> server for testing).? Just copy one of the entries and change
> its name (the
> first line), the hostname and port number to where your
> server lives.
>
> Cheers,
>
> Brian
>
> ---
> You are currently subscribed to freetds as:
> grisly AT kbdnet.net.au
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
> --
> Francis Smit
> ?
>
> Knowledge By Design/OzTel
> Suite 201, 683 George st
> Sydney 2000 NSW
>
> mailto:francis AT kbd.com.au
>
> Tel: +61 2 9212 1399
> Fax: +61 2 9212 5727
> ___________________________________
> m$: How can we stuff you up today?
> ? --- You are currently subscribed to freetds as: camber AT ais.org To
> unsubscribe, forward this message to
> $subst('Email.Unsub')
>



Archive powered by MHonArc 2.6.24.

Top of Page