[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