[freetds] freetds and windows

Brett generica at email.com
Mon Apr 11 22:28:54 EDT 2005


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