FreeTDS Development Group

[Brett <generica AT email.com>]

Arg,
and if i set TDSPORT=1433

i get:

net.c:154:Connecting to 192.168.88.11 port 1433.
net.c:157:socket creation error: Unknown error

So close, but yet so far!

        / Brett

On Tue, 12 Apr 2005, Brett wrote:

> Thanks for the help, things are progressing
>
> the log files show:
>
> util.c:273:Starting log file for FreeTDS 0.63
>         on 2005-04-12 12:26:25 with debug flags 0x4fff.
> config.c:158:Attempting to read conf files.
> config.c:202:Found conf file 'c:\freetds.conf' (from $FREETDSCONF). Reading 
> section 'kataku'.
> config.c:333:Looking for section global.
> config.c:390:... Found section global.
> config.c:393:Got a match.
> config.c:413:option = 'tds version' value = '4.2'.
> config.c:413:option = 'text size' value = '64512'.
> config.c:390:... Found section jdbc.
> config.c:390:... Found section jdbc_42.
> config.c:390:... Found section mypool.
> config.c:390:... Found section kataku.
> config.c:333:Looking for section kataku.
> config.c:390:... Found section global.
> config.c:390:... Found section jdbc.
> config.c:390:... Found section jdbc_42.
> config.c:390:... Found section mypool.
> config.c:390:... Found section kataku.
> config.c:393:Got a match.
> config.c:413:option = 'host' value = '192.168.88.11'.
> config.c:440:Found host entry 192.168.88.11.
> config.c:443:IP addr is 192.168.88.11.
> config.c:413:option = 'tds version' value = '8.0'.
> config.c:413:option = 'instance' value = 'Kataku'.
> config.c:206:...Success.
> config.c:578:Setting 'dump_file' to 'dump.log' from $TDSDUMP.
>
> then
>
>
> util.c:273:Starting log file for FreeTDS 0.63
>         on 2005-04-12 12:26:25 with debug flags 0x4fff.
> iconv.c:86:Using trivial iconv
> iconv.c:198:names for ISO-8859-1: ISO-8859-1
> iconv.c:198:names for UTF-8: UTF-8
> iconv.c:198:names for UCS-2LE: UCS-2LE
> iconv.c:198:names for UCS-2BE: (null)
> iconv.c:364:iconv to convert client-side data to the "ISO-8859-1" character 
> set
> iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> net.c:709:socket creation error: Unknown error
> login.c:225:invalid port number
> mem.c:453:tds_free_all_results()
> dblib.c:1138:dbuse()
>
> so
> invalid port number ??
>
> the ip address and port numbers dumpconfig found are correct
> why isn't it creating the socket correctly ?
>
> thanks
>
>         / Brett
>
> On Mon, 11 Apr 2005, ZIGLIO, Frediano, VF-IT wrote:
>
> > > Brett <generica AT email.com> wrote:
> > > > On Sat, 9 Apr 2005, James K. Lowden wrote:
> > > > > Brett <generica AT email.com> wrote:
> > > > > > The next plan was to compile it under windows, which I
> > > thought would
> > > > > be> straightforward.  We already had the system compiling under
> > > > > windows,> with faked calls for the sql stuff, so it was
> > > just a case of
> > > > > using the> freetds code, and linking it in with the
> > > windows libraries.
> > > > > Ah, but it is not straightforward. :-(  As you found, the
> > > VC++ project
> > > > > in the win32 directory builds the ODBC driver only.  If
> > > you update it
> > > > > to build db-lib, I would be glad to include your version
> > > in the main
> > > > > distribution.
> > > >
> > > > So does that mean, in it's current state, this won't work
> > > under windows
> > > > ?
> > >
> > > You can't simply unpack the source distribution and compile
> > > db-lib under
> > > Windows, no.  With a little work, you probably can, because
> > > the underlying
> > > communications library (libtds) does compile as part of the
> > > ODBC driver.
> >
> > 0.64 contains msvc6 project files for dblib as a static library.
> >
> > > > > shell32.lib?  That's a surprise.  What does db-lib need from that?
> > > >
> > > > from memory, something about finding a filename's path from
> > > desktop, or
> > > > some odd windows function.
> > >
> > > I'd be a little concerned that you're being misled.  I'm sure
> > > there's no
> > > Windows-specific code in db-lib, nor any GUI interaction.
> > > All it needs
> > > should come from the C standard library.
> >
> > To detect application data directory (that is the windows "home"
> > directory).
> >
> > > > I've never had any luck debugging this program, since it is not
> > > > straightforward c, but a mix of c and prolog, compiled by a prolog
> > > > compiler into an executable.  Generally debuggers 'just
> > > don't work' with
> > > > it :(
> > >
> > > If I were you and wanted to get db-lib compiled under Windows, I would
> > > begin by making sure the basic fuctions work.  You could try
> > > src/dblib/unittests/t0001.c, or src/apps/freebcp.c.  Those you can at
> > > least debug and we'll have a common frame of reference.  Once
> > > freebcp can
> > > load and extract a table on your server, you'll be in a
> > > position to link
> > > db-lib to your application.
> >
> > I would suggest to set environment to do logging (see UserGuide).
> >
> > freddy77
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds