FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Oops,

login guest
password sybase 
 
:)

Brian

On Wed, 1 Sep 1999, Brian Bruns wrote:

> 
> Here is 0.46 running against the JDBC server (in the interfaces), the only
> changes are for login information and the database name was changed to
> pubs2.
> 
> Can you test it against the JDBC server to determine if it is specially
> related to SQL 7.0 or your configuration.  The server is in the interfaces
> but you'll need an internet connection to get to it of course.
> 
> Brian
> 
> [camber@amd133 samples]$ !cc
> cc -o sample sample.c -I/usr/local/freetds/include 
> -L/usr/local/freetds/lib -lsybdb -lnsl
> [camber@amd133 samples]$ ./sample
> White from Menlo Park
> Green from Oakland
> Carson from Berkeley
> O'Leary from San Jose
> Straight from Oakland
> Bennet from Berkeley
> Dull from Palo Alto
> Gringlesby from Covelo
> Locksley from San Francisco
> Yokomoto from Walnut Creek
> Stringer from Oakland
> MacFeather from Oakland
> Karsen from Oakland
> Hunter from Palo Alto
> McBadden from Vacaville
> [camber@amd133 samples]$ 
> 
> 
> On Wed, 1 Sep 1999, Kenny Pang wrote:
> 
> > Hi
> > I am new to FreeTDS. I successfully compiled and installed freetds 0.46
> > in Redhat Linux 6.0. It was configured with "--with-tdsver=4.2".
> > However when I try some very sample programs to retrieve rows from a MS
> > SQL server, the results are not the one I expected.  The sample program
> > is extracted from the MS SQL server 7.0 online book. It caused
> > segmentation fault in the line
> > 
> > while (dbnextrow(dbproc) != NO_MORE_ROWS)
> > 
> > When total while block is commented, it runs but the printf outputs some
> > rubbish, instead of the correct column.
> > 
> > The sample program and the compile option is attached. Can somebody tell
> > me what stupid mistake I have made or anything I have missed. Thanks a
> > lot...
> > 
> > cc -o sample.c sample.c -I/usr/local/freetds/include
> > -L/usr/local/freetds/lib -lsybdb -lnsl
> > ------------------------------------------------------------------
> > sample.c
> > ------------------------------------------------------------------
> > #include <stdio.h>
> > #include <sqlfront.h>
> > #include <sqldb.h>
> > main()
> > 
> > {
> >     DBPROCESS  *dbproc;    // The connection with SQL Server.
> >     LOGINREC   *login;     // The login information.
> >     DBCHAR      name[100];
> >     DBCHAR      city[100];
> > 
> >     // Install user-supplied error- and message-handling functions.
> >     dbinit ();
> > 
> >     // Get a LOGINREC.
> >     login = dblogin();
> >     DBSETLUSER(login, "sa");
> >     DBSETLPWD(login, "");
> >     DBSETLAPP(login, "example");
> > 
> >     // Get a DBPROCESS structure for communication with SQL Server.
> >     dbproc = dbopen(login, "eex861");
> >     // Retrieve some columns from the authors table in the     // pubs
> > database.
> > 
> >     // First, put the command into the command buffer.
> >     dbcmd(dbproc, "SELECT au_lname, city FROM pubs..authors");
> >     dbcmd(dbproc, " WHERE state = 'CA' ");
> > 
> >     // Send the command to SQL Server and start execution.
> >     dbsqlexec(dbproc);
> > 
> >     // Process the results.
> >     if (dbresults(dbproc) == SUCCEED)
> >     {
> >         // Bind column to program variables.
> >         dbbind(dbproc, 1, NTBSTRINGBIND, 0, name);
> >         dbbind(dbproc, 2, NTBSTRINGBIND, 0, city);
> >         // Retrieve and print the result rows.
> > 
> >         while (dbnextrow(dbproc) != NO_MORE_ROWS)
> >         {
> >             printf("%s from %s\n", name, city);
> >         }
> >     }
> > 
> >     // Close the connection to SQL Server.
> >     dbexit();
> >     return(0);
> > 
> > 
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> > 
> > 
> 
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>