Path: news.eternal-september.org!eternal-september.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Arne_Vajh=C3=B8j?= <arne@vajhoej.dk>
Newsgroups: comp.os.vms
Subject: Re: FreeTDS port to VMS V9.x on x86?
Date: Thu, 5 Jun 2025 10:55:06 -0400
Organization: A noiseless patient Spider
Lines: 75
Message-ID: <101sb4a$1ioac$1@dont-email.me>
References: <101n7gq$4m9b$1@dont-email.me>
 <683f3086$0$693$14726298@news.sunsite.dk> <101ncau$57on$1@dont-email.me>
 <101nqij$9edo$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 05 Jun 2025 16:55:06 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="f78ef932b1852ec372e50a62897ef5f1";
	logging-data="1663308"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18VSx3v6QeDPr/YBaoQlC6OuGXlEFce5nY="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:nes8j67IFdHJR8vHyyT3YIhFHFk=
In-Reply-To: <101nqij$9edo$1@dont-email.me>
Content-Language: en-US

On 6/3/2025 5:48 PM, Craig A. Berry wrote:
> 
> On 6/3/25 12:45 PM, Arne Vajhøj wrote:
>> On 6/3/2025 1:27 PM, Arne Vajhøj wrote:
>>> On 6/3/2025 12:22 PM, Richard Jordan wrote:
>>>> Is there a downloadable build of the FreeTDS package for VSI VMS on 
>>>> x86 available?  I don't have access to a C compiler to try building it.
>>>
>>> 1.5.2 descrip_mms.template has:
>>>
>>> ... Craig A. Berry ... 23-JAN-2003
>>>
>>> But I could take a look at building on x86-64.
>>
>> Did.
>>
>> * download 1.5.2
>> * unpack on VMS
>> * @[.vms]configure
>> * mmk
>> * note only I message
>> * zip tree with -V
>> * upload
>>
>> https://www.vajhoej.dk/arne/temp/freetds-1_5_2.zip
>>
>> Nothing is tested. No guarantees.
>>
>> (I actually do have some TDS code somewhere that I could test with,
>> but I assume that you have your test setup ready, so faster that
>> you get it)
> 
> It comes with an extensive test suite:
> 
> 1.) Populate PWD.in with server and credentials
> 2.) $ define DECC$EFS_CHARSET ENABLE ! for some of the test infrastructure
> 3.) mmk test
> 
> I had it working pretty well on x86 against SQL 2022 a couple of months
> ago.  I think there was one test failure I never finished tracking down.

I want to test with my own code.

Old DBLIB code.  :-)

First I had some problems with connection. Apparently the client lib
and my SQLServer had a chit chat and decided to use SSL which failed.

freetds.conf with:

[arnepc5]
host = arnepc5
port = 1433
tds version = 7.0
encryption = off

solved that.

Now I have queries working.

Updates fail with:

TDS DBLIB error: Unable to allocate sufficient memory
TDS OS error: error 0
TDS error in dbcmd

But I suspect that is a bug in my code.

Arne