[freetds] freetds and windows

Brett generica at email.com
Mon Apr 11 23:16:46 EDT 2005


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
>> 
>


More information about the FreeTDS mailing list