From toddthomp at hotmail.com Sun Apr 26 15:06:38 2020 From: toddthomp at hotmail.com (todd thompson) Date: Sun, 26 Apr 2020 19:06:38 +0000 Subject: [freetds] Installing freetds-1.1.20 on HPUX 11.31 Message-ID: Hi All, The articles I've found in google searches keep pointing to this site (http://www.freetds.org/userguide/) but haven't been able to find something specific for HPUX 11.31 or just HPUX. I've installed freetds on RHEL 6.10 but I've read a couple articles saying the configure statement (i.e. ./configure --prefix=/opt/cloudhost/apache/www/cgi-bin/webutils/freetds with-tdsver=auto) is different so I'm mainly looking for the configure statement because I think the make and make install commands are the same. Thanks ahead of time. Todd From freddy77 at gmail.com Mon Apr 27 06:11:54 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Mon, 27 Apr 2020 11:11:54 +0100 Subject: [freetds] Installing freetds-1.1.20 on HPUX 11.31 In-Reply-To: References: Message-ID: Il giorno dom 26 apr 2020 alle ore 20:24 todd thompson ha scritto: > > Hi All, > > The articles I've found in google searches keep pointing to this site (http://www.freetds.org/userguide/) but haven't been able to find something specific for HPUX 11.31 or just HPUX. I've installed freetds on RHEL 6.10 but I've read a couple articles saying the configure statement (i.e. ./configure --prefix=/opt/cloudhost/apache/www/cgi-bin/webutils/freetds with-tdsver=auto) is different so I'm mainly looking for the configure statement because I think the make and make install commands are the same. > > Thanks ahead of time. > > Todd Hi, there's nothing special to be done for HP-UX, you should be able to use the standard configure/make. Somebody reported an issue with the standard preprocessor which is not C compatible (neither C89 nor C99), if this is the case use another preprocessor/compiler (like gcc). For any issue you can report here. In the past I had access to HP-UX machine but not anymore (it was about 8 years ago). Regards, Frediano From niklas at saers.com Fri May 1 10:09:33 2020 From: niklas at saers.com (Niklas Saers) Date: Fri, 1 May 2020 16:09:33 +0200 Subject: [freetds] Cross-compiling for Mac Catalyst In-Reply-To: References: <0DF8952A-13FC-4E31-964B-68D9E9AFDA3E@saers.com> <6A68D02D-02B3-4CC5-BD85-6271AEB51495@saers.com> Message-ID: <5FCAC947-E34E-49A6-A2BD-1527B3919489@saers.com> Hi Frediano and the rest of the team, Sorry for the delay, I?m no-where closer than I was 1,5 month ago although having given it many evenings. To build the macOS Catalyst only version, I made a branch that does that: https://github.com/niklassaers/freetds-ios/tree/catalyst-only Here I?ve included the full log with the make V=1: https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst.log Also, I?ve inlined in https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst-2.sh some of the many different ways I?ve tried, and how the errors I?ve received have been a bit different. Does this ring a bell? Any suggestions to what I should try? If anyone wants to give it a shot but doesn?t have access to macOS Catalina, I have prepared a macOS VM on my iMac, that is available via SSH from the internet. I?d be happy to give access to anyone who wants to give building it a shot. Just shoot me a private email and I?ll provide the details Cheers Niklas > On 9 Mar 2020, at 09.49, Frediano Ziglio wrote: > > Hi, > no much ideas, I would check the commands to see if there are some > weird options. > I usually do a clean and another "make V=1" to see the full commands. > The important ones are a compile command and a final link one, with > all options. Can you post them? > I don't have a Mac to try myself. > > Regards, > Frediano > > > Il giorno ven 6 mar 2020 alle ore 15:17 Niklas Saers > > ha scritto: >> >> Hi Frediano, >> No, I haven?t made any progress, and I?d really appreciate some help. :-) >> >> The build script go.sh in https://github.com/niklassaers/freetds-ios > will download FreeDTS, and build it from clean. So unless I?ve done something odd, I don?t think there should be leftovers from an old build. I just verified it by downloading the repo to an clean dir and running it. I still get the same error: >> >> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h >> >> If you?re on a Mac running Catalina, would you mind downloading the repo and running go.sh ? I expect you?ll get the same error, but perhaps you?ll have a better understanding as to why it comes? >> >> PS, Mac Catalyst architecture is x86_64-apple-ios13.0-macabi - no arm involved >> >> Cheers >> >> Niklas >> >> >>> On 6 Mar 2020, at 11.32, Frediano Ziglio wrote: >>> >>> Il giorno mer 26 feb 2020 alle ore 16:18 Niklas Saers >>> ha scritto: >>>> >>>> Hi, >>>> First of all thanks for all the hard work that has been put into this project, and thank you very much for letting me join the list. >>>> >>>> I'm trying to cross-compile FreeTDS for the different iOS platforms and for Mac Catalyst. I've made a project with my scripts at https://github.com/niklassaers/freetds-ios >>>> >>>> If you clone it and run go.sh, it compiles iOS versions for arm64e, arm64, armv7s, armv7 and the simulator, plus a catalyst version. It goes seemingly fine for the iOS versions, but for Mac Catalyst, I get the following error: >>>> >>>> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h >>>> >>>> Any idea why I get this linker error, and how I can resolve it? >>>> >>>> My build script for the Mac Catalyst build by itself is here: https://raw.githubusercontent.com/niklassaers/freetds-ios/master/build-catalyst-2.sh >>>> >>>> Cheers >>>> >>>> Niklas >>> >>> Hi, >>> did you solve this? >>> >>> From the message looks like some kind of leftover from an old build or >>> picking up a library for another architecture. >>> Unless for some reason you manage to compile for x86_64 and attempting >>> linking with arm. >>> >>> Regards, >>> Frediano >>> _______________________________________________ >>> FreeTDS mailing list >>> FreeTDS at lists.ibiblio.org >>> https://lists.ibiblio.org/mailman/listinfo/freetds >> >> _______________________________________________ >> FreeTDS mailing list >> FreeTDS at lists.ibiblio.org >> https://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From toddthomp at hotmail.com Wed May 6 14:32:21 2020 From: toddthomp at hotmail.com (todd thompson) Date: Wed, 6 May 2020 18:32:21 +0000 Subject: [freetds] Installing freetds-1.1.20 on HPUX 11.31 In-Reply-To: References: , Message-ID: Hi All, We used this configure statement: ./configure --prefix=/opt/ictest/freetds --with-tdsver=auto And we received the following error during the make: ---------------------------------------------------------------------------- opt/ictest/freetds/freetds-1.1.20 s11u013c:freetds/freetds-1.1.20 $ make No suffix list. Making all in include No suffix list. make all-recursive No suffix list. Making all in freetds No suffix list. echo '#define FREETDS_SYSCONFDIR "/opt/ictest/freetds/etc"' >sysconfdir.h No suffix list. Making all in src No suffix list. Making all in utils Making all in . CC md4.lo In file included from md4.c:42: ../../include/tds_sysdep_public.h:62: error: conflicting types for 'intptr_t' /usr/include/sys/_inttypes.h:114: error: previous declaration of 'intptr_t' was here ../../include/tds_sysdep_public.h:63: error: conflicting types for 'uintptr_t' /usr/include/sys/_inttypes.h:115: error: previous declaration of 'uintptr_t' was here *** Error exit code 1 Stop. *** Error exit code 1 Stop. *** Error exit code 1 Stop. *** Error exit code 1 Stop. ------------------------------------------------------------------------------ I found this explanation on Google: The package you are trying to build (like almost every package you'll find) is written in ANSI C. The bundled HP compiler handles only K&R C; you need to either purchase the ANSI C compiler for your HP machine, or build gcc and its dependencies first. If this is accurate, we more than likely won't be able to purchase the ANSI C compiler. Do you know how to "build gcc and it's dependencies"? Todd ________________________________ From: FreeTDS on behalf of Frediano Ziglio Sent: Monday, April 27, 2020 10:11 AM To: FreeTDS Development Group Subject: Re: [freetds] Installing freetds-1.1.20 on HPUX 11.31 Il giorno dom 26 apr 2020 alle ore 20:24 todd thompson ha scritto: > > Hi All, > > The articles I've found in google searches keep pointing to this site (http://www.freetds.org/userguide/) but haven't been able to find something specific for HPUX 11.31 or just HPUX. I've installed freetds on RHEL 6.10 but I've read a couple articles saying the configure statement (i.e. ./configure --prefix=/opt/cloudhost/apache/www/cgi-bin/webutils/freetds with-tdsver=auto) is different so I'm mainly looking for the configure statement because I think the make and make install commands are the same. > > Thanks ahead of time. > > Todd Hi, there's nothing special to be done for HP-UX, you should be able to use the standard configure/make. Somebody reported an issue with the standard preprocessor which is not C compatible (neither C89 nor C99), if this is the case use another preprocessor/compiler (like gcc). For any issue you can report here. In the past I had access to HP-UX machine but not anymore (it was about 8 years ago). Regards, Frediano _______________________________________________ FreeTDS mailing list FreeTDS at lists.ibiblio.org https://lists.ibiblio.org/mailman/listinfo/freetds From freddy77 at gmail.com Thu May 7 04:49:55 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Thu, 7 May 2020 09:49:55 +0100 Subject: [freetds] Installing freetds-1.1.20 on HPUX 11.31 In-Reply-To: References: Message-ID: Hi, se below. Frediano Il giorno mer 6 mag 2020 alle ore 19:49 todd thompson ha scritto: > > Hi All, > > We used this configure statement: ./configure --prefix=/opt/ictest/freetds --with-tdsver=auto > And we received the following error during the make: > > > ---------------------------------------------------------------------------- > > opt/ictest/freetds/freetds-1.1.20 > > s11u013c:freetds/freetds-1.1.20 $ make > > No suffix list. > > Making all in include > > No suffix list. > > make all-recursive > > No suffix list. > > Making all in freetds > > No suffix list. > > echo '#define FREETDS_SYSCONFDIR "/opt/ictest/freetds/etc"' >sysconfdir.h > > No suffix list. > > Making all in src > > No suffix list. > > Making all in utils > > Making all in . > > CC md4.lo > > In file included from md4.c:42: > > ../../include/tds_sysdep_public.h:62: error: conflicting types for 'intptr_t' > > /usr/include/sys/_inttypes.h:114: error: previous declaration of 'intptr_t' was here > > ../../include/tds_sysdep_public.h:63: error: conflicting types for 'uintptr_t' > > /usr/include/sys/_inttypes.h:115: error: previous declaration of 'uintptr_t' was here > searching for this issue, try to change in include/tds_sysdep_public.h from #elif defined(__sun) && defined(__SVR4) to #elif (defined(__sun) && defined(__SVR4)) || defined (__HP_cc) > *** Error exit code 1 > > > > Stop. > > *** Error exit code 1 > > > > Stop. > > *** Error exit code 1 > > > > Stop. > > *** Error exit code 1 > > > > Stop. > > ------------------------------------------------------------------------------ > > I found this explanation on Google: > > > The package you are trying to build (like almost every package you'll > find) is written in ANSI C. The bundled HP compiler handles only K&R C; > you need to either purchase the ANSI C compiler for your HP machine, or > build gcc and its dependencies first. > It could happen. Honestly I found strange that cpp (the preprocessor, at least the classic executable name for it in Unix) does not have an option for this. But try with the above patch and let me know. > If this is accurate, we more than likely won't be able to purchase the ANSI C compiler. Do you know how to "build gcc and it's dependencies"? > I did once, it takes some times but worked. But it was many years ago, I would just search "how to compile gcc under hp-ux". I remember there was also an open source repository of compiled programs for hp-ux. >From a quick search I found http://hpux.connect.org.uk/hppd/hpux/Gnu/gcc-4.2.3/ https://community.hpe.com/t5/languages-and-scripting/how-to-download-gcc/td-p/6899991 > Todd > > ________________________________ > From: FreeTDS on behalf of Frediano Ziglio > Sent: Monday, April 27, 2020 10:11 AM > To: FreeTDS Development Group > Subject: Re: [freetds] Installing freetds-1.1.20 on HPUX 11.31 > > Il giorno dom 26 apr 2020 alle ore 20:24 todd thompson > ha scritto: > > > > Hi All, > > > > The articles I've found in google searches keep pointing to this site (http://www.freetds.org/userguide/) but haven't been able to find something specific for HPUX 11.31 or just HPUX. I've installed freetds on RHEL 6.10 but I've read a couple articles saying the configure statement (i.e. ./configure --prefix=/opt/cloudhost/apache/www/cgi-bin/webutils/freetds with-tdsver=auto) is different so I'm mainly looking for the configure statement because I think the make and make install commands are the same. > > > > Thanks ahead of time. > > > > Todd > > Hi, > there's nothing special to be done for HP-UX, you should be able to > use the standard configure/make. > Somebody reported an issue with the standard preprocessor which is not > C compatible (neither C89 nor C99), if this is the case use another > preprocessor/compiler (like gcc). > For any issue you can report here. > In the past I had access to HP-UX machine but not anymore (it was > about 8 years ago). > > Regards, > Frediano > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From freddy77 at gmail.com Thu May 7 15:17:35 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Thu, 7 May 2020 20:17:35 +0100 Subject: [freetds] Cross-compiling for Mac Catalyst In-Reply-To: <5FCAC947-E34E-49A6-A2BD-1527B3919489@saers.com> References: <0DF8952A-13FC-4E31-964B-68D9E9AFDA3E@saers.com> <6A68D02D-02B3-4CC5-BD85-6271AEB51495@saers.com> <5FCAC947-E34E-49A6-A2BD-1527B3919489@saers.com> Message-ID: Hi, I manage to get Catalina on my laptop (pretty old nowadays) but I'm pretty busy at the moment. I looked at the log. So, the error is ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h trying to link fisql which is an executable. This error is apparently a mismatch of ABIs. A mismatch between a shared library (dylib) and the executable. The 2 parameters that seem to specify the target are -arch and -target. The command for the executable is clang -D_THREAD_SAFE -arch x86_64h -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -target x86_64-apple-ios13.0-macabi -Wdeclaration-after-statement -arch x86_64h -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -target x86_64-apple-ios13.0-macabi -o .libs/fisql fisql.o terminal.o edit.o handlers.o interrupt.o ../../dblib/.libs/libsybdb.dylib ../../replacements/.libs/libreplacements.a -liconv the one for the dylib is clang -dynamiclib -Wl,-undefined -Wl,dynamic_lookup -o .libs/libsybdb.5.dylib .libs/dblib.o .libs/dbutil.o .libs/rpc.o .libs/bcp.o .libs/xact.o .libs/dbpivot.o -Wl,-force_load,../tds/.libs/libtds.a -Wl,-force_load,../replacements/.libs/libreplacements.a -liconv -arch x86_64h -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -arch x86_64h -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -install_name /Users/niklas/Downloads/freetds-ios/work/catalyst/build_ios/freetds/x86_64h/lib/libsybdb.5.dylib -compatibility_version 7 -current_version 7.0 -Wl,-single_module one thing weird is that this last has no -target specified. Maybe is this the issue? I also noted that tdspool, another executable, is linked successfully but the difference here is that tdspool links only convenience libraries (basically static libraries). I would suggest manually to try to rebuild the dylib, something like: - build as you are doing - move to src/dblib - launch the command to compile libsybdb.5.dylib with the additional "-target x86_64-apple-ios13.0-macabi" - move back to src/apps/fisql - launch the command to compile fisql (I think also make should work here) All object files have both -arch and -target too. Did you run autoreconf? Sometimes it's helpful as it replaces the libtool provided which sometimes helps under some systems, something like - "autoreconf -vif" - configure - make Regards, Frediano Il giorno ven 1 mag 2020 alle ore 15:11 Niklas Saers ha scritto: > > Hi Frediano and the rest of the team, > Sorry for the delay, I?m no-where closer than I was 1,5 month ago although having given it many evenings. > > To build the macOS Catalyst only version, I made a branch that does that: https://github.com/niklassaers/freetds-ios/tree/catalyst-only > > Here I?ve included the full log with the make V=1: > > https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst.log > > Also, I?ve inlined in https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst-2.sh some of the many different ways I?ve tried, and how the errors I?ve received have been a bit different. > > Does this ring a bell? Any suggestions to what I should try? > > If anyone wants to give it a shot but doesn?t have access to macOS Catalina, I have prepared a macOS VM on my iMac, that is available via SSH from the internet. I?d be happy to give access to anyone who wants to give building it a shot. Just shoot me a private email and I?ll provide the details > > Cheers > > Niklas > > > On 9 Mar 2020, at 09.49, Frediano Ziglio wrote: > > > > Hi, > > no much ideas, I would check the commands to see if there are some > > weird options. > > I usually do a clean and another "make V=1" to see the full commands. > > The important ones are a compile command and a final link one, with > > all options. Can you post them? > > I don't have a Mac to try myself. > > > > Regards, > > Frediano > > > > > > Il giorno ven 6 mar 2020 alle ore 15:17 Niklas Saers > > > ha scritto: > >> > >> Hi Frediano, > >> No, I haven?t made any progress, and I?d really appreciate some help. :-) > >> > >> The build script go.sh in https://github.com/niklassaers/freetds-ios > will download FreeDTS, and build it from clean. So unless I?ve done something odd, I don?t think there should be leftovers from an old build. I just verified it by downloading the repo to an clean dir and running it. I still get the same error: > >> > >> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h > >> > >> If you?re on a Mac running Catalina, would you mind downloading the repo and running go.sh ? I expect you?ll get the same error, but perhaps you?ll have a better understanding as to why it comes? > >> > >> PS, Mac Catalyst architecture is x86_64-apple-ios13.0-macabi - no arm involved > >> > >> Cheers > >> > >> Niklas > >> > >> > >>> On 6 Mar 2020, at 11.32, Frediano Ziglio wrote: > >>> > >>> Il giorno mer 26 feb 2020 alle ore 16:18 Niklas Saers > >>> ha scritto: > >>>> > >>>> Hi, > >>>> First of all thanks for all the hard work that has been put into this project, and thank you very much for letting me join the list. > >>>> > >>>> I'm trying to cross-compile FreeTDS for the different iOS platforms and for Mac Catalyst. I've made a project with my scripts at https://github.com/niklassaers/freetds-ios > >>>> > >>>> If you clone it and run go.sh, it compiles iOS versions for arm64e, arm64, armv7s, armv7 and the simulator, plus a catalyst version. It goes seemingly fine for the iOS versions, but for Mac Catalyst, I get the following error: > >>>> > >>>> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h > >>>> > >>>> Any idea why I get this linker error, and how I can resolve it? > >>>> > >>>> My build script for the Mac Catalyst build by itself is here: https://raw.githubusercontent.com/niklassaers/freetds-ios/master/build-catalyst-2.sh > >>>> > >>>> Cheers > >>>> > >>>> Niklas > >>> > >>> Hi, > >>> did you solve this? > >>> > >>> From the message looks like some kind of leftover from an old build or > >>> picking up a library for another architecture. > >>> Unless for some reason you manage to compile for x86_64 and attempting > >>> linking with arm. > >>> > >>> Regards, > >>> Frediano > >>> _______________________________________________ > >>> FreeTDS mailing list > >>> FreeTDS at lists.ibiblio.org > >>> https://lists.ibiblio.org/mailman/listinfo/freetds > >> > >> _______________________________________________ > >> FreeTDS mailing list > >> FreeTDS at lists.ibiblio.org > >> https://lists.ibiblio.org/mailman/listinfo/freetds > > _______________________________________________ > > FreeTDS mailing list > > FreeTDS at lists.ibiblio.org > > https://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From niklas at saers.com Sun May 24 07:45:35 2020 From: niklas at saers.com (Niklas Saers) Date: Sun, 24 May 2020 13:45:35 +0200 Subject: [freetds] Cross-compiling for Mac Catalyst In-Reply-To: References: <0DF8952A-13FC-4E31-964B-68D9E9AFDA3E@saers.com> <6A68D02D-02B3-4CC5-BD85-6271AEB51495@saers.com> <5FCAC947-E34E-49A6-A2BD-1527B3919489@saers.com> Message-ID: <5FC2BA0B-391C-4310-9CBE-4F8F0A9A79FA@saers.com> Hi Frediano, I?m sorry for my long overdue answer, I had accidentally marked the message as read and didn?t notice it had come before I went to search. I have a Catalina instance ready, I?ll send you the login details privately. I installed lib tool for glibtoolize via Homebrew, but couldn?t get autoreconf to work, it kept complaining about a possibly undefined macro AM_ICONV: configure.ac:123: warning: macro 'AM_ICONV' not found in library autoreconf: running: /usr/local/Cellar/autoconf/2.69/bin/autoconf --force configure.ac:123: error: possibly undefined macro: AM_ICONV I?ve tried forcing it, and I?ve tried it for both freetds-1.1.24 and freetds-dev.1.1.91 You absolutely found the error with the missing -target for the dylib. Do you have a suggestion as to how we can try to apply it? I wrote it manually into configure and ran again, and then build succeeded :-) Now I have a Catalyst library! :-) Wonderful! :-) Cheers Niklas > On 7 May 2020, at 21.17, Frediano Ziglio wrote: > > Hi, > I manage to get Catalina on my laptop (pretty old nowadays) but I'm > pretty busy at the moment. > > I looked at the log. > So, the error is > > ld: building for Mac Catalyst, but linking in dylib built for macOS, > file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h > > trying to link fisql which is an executable. This error is apparently > a mismatch of ABIs. A mismatch between a shared library (dylib) and > the executable. > The 2 parameters that seem to specify the target are -arch and -target. > > The command for the executable is > > clang -D_THREAD_SAFE -arch x86_64h -isysroot > /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk > -target x86_64-apple-ios13.0-macabi -Wdeclaration-after-statement > -arch x86_64h -isysroot > /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk > -target x86_64-apple-ios13.0-macabi -o .libs/fisql fisql.o terminal.o > edit.o handlers.o interrupt.o ../../dblib/.libs/libsybdb.dylib > ../../replacements/.libs/libreplacements.a -liconv > > the one for the dylib is > > clang -dynamiclib -Wl,-undefined -Wl,dynamic_lookup -o > .libs/libsybdb.5.dylib .libs/dblib.o .libs/dbutil.o .libs/rpc.o > .libs/bcp.o .libs/xact.o .libs/dbpivot.o > -Wl,-force_load,../tds/.libs/libtds.a > -Wl,-force_load,../replacements/.libs/libreplacements.a -liconv > -arch x86_64h -isysroot > /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk > -arch x86_64h -isysroot > /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk > -install_name > /Users/niklas/Downloads/freetds-ios/work/catalyst/build_ios/freetds/x86_64h/lib/libsybdb.5.dylib > -compatibility_version 7 -current_version 7.0 -Wl,-single_module > > one thing weird is that this last has no -target specified. Maybe is > this the issue? > > I also noted that tdspool, another executable, is linked successfully > but the difference here is that tdspool links only convenience > libraries (basically static libraries). > > I would suggest manually to try to rebuild the dylib, something like: > - build as you are doing > - move to src/dblib > - launch the command to compile libsybdb.5.dylib with the additional > "-target x86_64-apple-ios13.0-macabi" > - move back to src/apps/fisql > - launch the command to compile fisql (I think also make should work here) > > All object files have both -arch and -target too. > > Did you run autoreconf? Sometimes it's helpful as it replaces the > libtool provided which sometimes helps under some systems, something > like > - "autoreconf -vif" > - configure > - make > > Regards, > Frediano > > Il giorno ven 1 mag 2020 alle ore 15:11 Niklas Saers > > ha scritto: >> >> Hi Frediano and the rest of the team, >> Sorry for the delay, I?m no-where closer than I was 1,5 month ago although having given it many evenings. >> >> To build the macOS Catalyst only version, I made a branch that does that: https://github.com/niklassaers/freetds-ios/tree/catalyst-only > >> >> Here I?ve included the full log with the make V=1: >> >> https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst.log > >> >> Also, I?ve inlined in https://raw.githubusercontent.com/niklassaers/freetds-ios/catalyst-only/build-catalyst-2.sh > some of the many different ways I?ve tried, and how the errors I?ve received have been a bit different. >> >> Does this ring a bell? Any suggestions to what I should try? >> >> If anyone wants to give it a shot but doesn?t have access to macOS Catalina, I have prepared a macOS VM on my iMac, that is available via SSH from the internet. I?d be happy to give access to anyone who wants to give building it a shot. Just shoot me a private email and I?ll provide the details >> >> Cheers >> >> Niklas >> >>> On 9 Mar 2020, at 09.49, Frediano Ziglio > wrote: >>> >>> Hi, >>> no much ideas, I would check the commands to see if there are some >>> weird options. >>> I usually do a clean and another "make V=1" to see the full commands. >>> The important ones are a compile command and a final link one, with >>> all options. Can you post them? >>> I don't have a Mac to try myself. >>> >>> Regards, >>> Frediano >>> >>> >>> Il giorno ven 6 mar 2020 alle ore 15:17 Niklas Saers >>> >> ha scritto: >>>> >>>> Hi Frediano, >>>> No, I haven?t made any progress, and I?d really appreciate some help. :-) >>>> >>>> The build script go.sh in https://github.com/niklassaers/freetds-ios > >> will download FreeDTS, and build it from clean. So unless I?ve done something odd, I don?t think there should be leftovers from an old build. I just verified it by downloading the repo to an clean dir and running it. I still get the same error: >>>> >>>> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h >>>> >>>> If you?re on a Mac running Catalina, would you mind downloading the repo and running go.sh ? I expect you?ll get the same error, but perhaps you?ll have a better understanding as to why it comes? >>>> >>>> PS, Mac Catalyst architecture is x86_64-apple-ios13.0-macabi - no arm involved >>>> >>>> Cheers >>>> >>>> Niklas >>>> >>>> >>>>> On 6 Mar 2020, at 11.32, Frediano Ziglio wrote: >>>>> >>>>> Il giorno mer 26 feb 2020 alle ore 16:18 Niklas Saers >>>>> ha scritto: >>>>>> >>>>>> Hi, >>>>>> First of all thanks for all the hard work that has been put into this project, and thank you very much for letting me join the list. >>>>>> >>>>>> I'm trying to cross-compile FreeTDS for the different iOS platforms and for Mac Catalyst. I've made a project with my scripts at https://github.com/niklassaers/freetds-ios >>>>>> >>>>>> If you clone it and run go.sh, it compiles iOS versions for arm64e, arm64, armv7s, armv7 and the simulator, plus a catalyst version. It goes seemingly fine for the iOS versions, but for Mac Catalyst, I get the following error: >>>>>> >>>>>> ld: building for Mac Catalyst, but linking in dylib built for macOS, file '../../dblib/.libs/libsybdb.dylib' for architecture x86_64h >>>>>> >>>>>> Any idea why I get this linker error, and how I can resolve it? >>>>>> >>>>>> My build script for the Mac Catalyst build by itself is here: https://raw.githubusercontent.com/niklassaers/freetds-ios/master/build-catalyst-2.sh >>>>>> >>>>>> Cheers >>>>>> >>>>>> Niklas >>>>> >>>>> Hi, >>>>> did you solve this? >>>>> >>>>> From the message looks like some kind of leftover from an old build or >>>>> picking up a library for another architecture. >>>>> Unless for some reason you manage to compile for x86_64 and attempting >>>>> linking with arm. >>>>> >>>>> Regards, >>>>> Frediano >>>>> _______________________________________________ >>>>> FreeTDS mailing list >>>>> FreeTDS at lists.ibiblio.org >>>>> https://lists.ibiblio.org/mailman/listinfo/freetds >>>> >>>> _______________________________________________ >>>> FreeTDS mailing list >>>> FreeTDS at lists.ibiblio.org > >>>> https://lists.ibiblio.org/mailman/listinfo/freetds > >>> _______________________________________________ >>> FreeTDS mailing list >>> FreeTDS at lists.ibiblio.org > >>> https://lists.ibiblio.org/mailman/listinfo/freetds > >> _______________________________________________ >> FreeTDS mailing list >> FreeTDS at lists.ibiblio.org >> https://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From freddy77 at gmail.com Sun May 31 09:10:36 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Sun, 31 May 2020 14:10:36 +0100 Subject: [freetds] FreeTDS 1.2 Release Candidate 1 Message-ID: Hi, time for a new release. Release brings all these changes (available also in NEWS.md file): Summary of Changes in release 1.2 --------------------------------- User visible (not in a particular order): - Sybase server: - All strings are now converted as MSSQL; - Support kerberos login; - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION and DBSETSERVERPRINCIPAL; - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH; - Bulk copies: - DB-Library: fix trim of unicode fields; - (*) Apply character conversion for Sybase, like MSSQL; - (*) Ignore computed columns; - (*) Properly support multibyte strings in column names; - (*) DB-Library: stop correctly on BCPMAXERRS setting; - (*) DB-Library: do not try to convert skipped rows reading file allowing for instance to load CVS files; - (*) CT-Library: added CS_DATABASE property to allows to connect correctly to Azure servers; - (*) Improve support for MS XML columns for both DB-Library and CT-Library; - (*) Fix some issues with MSSQL server redirection (used for instance in Azure); - (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns; - Better support for SQL_VARIANT: - Better column checks; - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE; - Some updates to server part: - Set correctly initial state; - IPv6 support; - Fix TDS 7.2 logins; - Support extended character using domain logins under Unix; - Improve MARS: - Less memory copies; - (*) Remove possible deadlock; - Handle wrapping sequence/window numbers; - Make sure we sent the wanted packet; - (*) Support UTF-16 surrogate pairs in odbc_wide2utf and odbc_set_string_flag fixing some character encoding support; - (*) Fix multiple queries, used by ODBC to optimize data load; - (*) Improve emulated parameter queries, fixing minor issues and reducing memory usage; - Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic detection); - CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE; - (*) CT-Library: fix cs_will_convert accepting library constants, not libTDS. (*) Feature backported in stable 1.1 branch. Implementation: - User guide converted to XML; - Always use little endian on network level, simpler and faster; - Converted some files to markdown; - Optimize bytes endianess conversion; - Made character lookup faster making character conversion quicker; - Optimize data padding in CT-Library; - Fix some build dependencies causing some files to not be properly recompiled during development; - Add "freeze" support allowing to pause sending in order to simplify lengths computations sending data. Kind Regards, Frediano From freddy77 at gmail.com Tue Jun 9 08:32:01 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Tue, 9 Jun 2020 13:32:01 +0100 Subject: [freetds] FreeTDS 1.2 Release Candidate 2 Message-ID: Hi, just another updated release candidate. Changes since previous release candidate: - Small update to user guide; - Fix build for OpenVMS; - Fix build from git for MacOS. Summary of Changes in release 1.2 --------------------------------- User visible (not in a particular order): - Sybase server: - All strings are now converted as MSSQL; - Support kerberos login; - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION and DBSETSERVERPRINCIPAL; - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH; - Bulk copies: - DB-Library: fix trim of unicode fields; - (*) Apply character conversion for Sybase, like MSSQL; - (*) Ignore computed columns; - (*) Properly support multibyte strings in column names; - (*) DB-Library: stop correctly on BCPMAXERRS setting; - (*) DB-Library: do not try to convert skipped rows reading file allowing for instance to load CVS files; - (*) CT-Library: added CS_DATABASE property to allows to connect correctly to Azure servers; - (*) Improve support for MS XML columns for both DB-Library and CT-Library; - (*) Fix some issues with MSSQL server redirection (used for instance in Azure); - (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns; - Better support for SQL_VARIANT: - Better column checks; - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE; - Some updates to server part: - Set correctly initial state; - IPv6 support; - Fix TDS 7.2 logins; - Support extended character using domain logins under Unix; - Improve MARS: - Less memory copies; - (*) Remove possible deadlock; - Handle wrapping sequence/window numbers; - Make sure we sent the wanted packet; - (*) Support UTF-16 surrogate pairs in odbc_wide2utf and odbc_set_string_flag fixing some character encoding support; - (*) Fix multiple queries, used by ODBC to optimize data load; - (*) Improve emulated parameter queries, fixing minor issues and reducing memory usage; - Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic detection); - CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE; - (*) CT-Library: fix cs_will_convert accepting library constants, not libTDS. (*) Feature backported in stable 1.1 branch. Implementation: - User guide converted to XML; - Always use little endian on network level, simpler and faster; - Converted some files to markdown; - Optimize bytes endianess conversion; - Made character lookup faster making character conversion quicker; - Optimize data padding in CT-Library; - Fix some build dependencies causing some files to not be properly recompiled during development; - Add "freeze" support allowing to pause sending in order to simplify lengths computations sending data. Kind Regards, Frediano From ikorot01 at gmail.com Tue Jun 9 11:16:09 2020 From: ikorot01 at gmail.com (Igor Korot) Date: Tue, 9 Jun 2020 10:16:09 -0500 Subject: [freetds] FreeTDS 1.2 Release Candidate 2 In-Reply-To: References: Message-ID: Frediano, On Tue, Jun 9, 2020 at 7:34 AM Frediano Ziglio wrote: > > Hi, > just another updated release candidate. > > Changes since previous release candidate: > - Small update to user guide; > - Fix build for OpenVMS; > - Fix build from git for MacOS. > > > Summary of Changes in release 1.2 > --------------------------------- > User visible (not in a particular order): > - Sybase server: > - All strings are now converted as MSSQL; > - Support kerberos login; > - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION and > DBSETSERVERPRINCIPAL; > - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH, > CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH; > - Bulk copies: > - DB-Library: fix trim of unicode fields; > - (*) Apply character conversion for Sybase, like MSSQL; > - (*) Ignore computed columns; > - (*) Properly support multibyte strings in column names; > - (*) DB-Library: stop correctly on BCPMAXERRS setting; > - (*) DB-Library: do not try to convert skipped rows reading file allowing > for instance to load CVS files; > - (*) CT-Library: added CS_DATABASE property to allows to connect correctly > to Azure servers; > - (*) Improve support for MS XML columns for both DB-Library and CT-Library; > - (*) Fix some issues with MSSQL server redirection (used for instance in > Azure); > - (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns; > - Better support for SQL_VARIANT: > - Better column checks; > - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE; > - Some updates to server part: > - Set correctly initial state; > - IPv6 support; > - Fix TDS 7.2 logins; > - Support extended character using domain logins under Unix; > - Improve MARS: > - Less memory copies; > - (*) Remove possible deadlock; > - Handle wrapping sequence/window numbers; > - Make sure we sent the wanted packet; > - (*) Support UTF-16 surrogate pairs in odbc_wide2utf and > odbc_set_string_flag > fixing some character encoding support; > - (*) Fix multiple queries, used by ODBC to optimize data load; > - (*) Improve emulated parameter queries, fixing minor issues and reducing > memory usage; > - Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic detection); > - CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE; > - (*) CT-Library: fix cs_will_convert accepting library constants, not > libTDS. > > (*) Feature backported in stable 1.1 branch. > > Implementation: > - User guide converted to XML; > - Always use little endian on network level, simpler and faster; > - Converted some files to markdown; > - Optimize bytes endianess conversion; > - Made character lookup faster making character conversion quicker; > - Optimize data padding in CT-Library; > - Fix some build dependencies causing some files to not be properly > recompiled during development; > - Add "freeze" support allowing to pause sending in order to simplify > lengths computations sending data. Is there a plan to implement the missing ODBC function? There is only one left... Thank you. > > Kind Regards, > Frediano > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From freddy77 at gmail.com Tue Jun 9 14:23:01 2020 From: freddy77 at gmail.com (Frediano Ziglio) Date: Tue, 9 Jun 2020 19:23:01 +0100 Subject: [freetds] FreeTDS 1.2 Release Candidate 2 In-Reply-To: References: Message-ID: Il giorno mar 9 giu 2020 alle ore 16:18 Igor Korot ha scritto: > Frediano, > > On Tue, Jun 9, 2020 at 7:34 AM Frediano Ziglio wrote: > > > > Hi, > > just another updated release candidate. > > > > Changes since previous release candidate: > > - Small update to user guide; > > - Fix build for OpenVMS; > > - Fix build from git for MacOS. > > > > > > Summary of Changes in release 1.2 > > --------------------------------- > > User visible (not in a particular order): > > - Sybase server: > > - All strings are now converted as MSSQL; > > - Support kerberos login; > > - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION > and > > DBSETSERVERPRINCIPAL; > > - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH, > > CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH; > > - Bulk copies: > > - DB-Library: fix trim of unicode fields; > > - (*) Apply character conversion for Sybase, like MSSQL; > > - (*) Ignore computed columns; > > - (*) Properly support multibyte strings in column names; > > - (*) DB-Library: stop correctly on BCPMAXERRS setting; > > - (*) DB-Library: do not try to convert skipped rows reading file > allowing > > for instance to load CVS files; > > - (*) CT-Library: added CS_DATABASE property to allows to connect > correctly > > to Azure servers; > > - (*) Improve support for MS XML columns for both DB-Library and > CT-Library; > > - (*) Fix some issues with MSSQL server redirection (used for instance in > > Azure); > > - (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns; > > - Better support for SQL_VARIANT: > > - Better column checks; > > - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE; > > - Some updates to server part: > > - Set correctly initial state; > > - IPv6 support; > > - Fix TDS 7.2 logins; > > - Support extended character using domain logins under Unix; > > - Improve MARS: > > - Less memory copies; > > - (*) Remove possible deadlock; > > - Handle wrapping sequence/window numbers; > > - Make sure we sent the wanted packet; > > - (*) Support UTF-16 surrogate pairs in odbc_wide2utf and > > odbc_set_string_flag > > fixing some character encoding support; > > - (*) Fix multiple queries, used by ODBC to optimize data load; > > - (*) Improve emulated parameter queries, fixing minor issues and > reducing > > memory usage; > > - Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic > detection); > > - CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE; > > - (*) CT-Library: fix cs_will_convert accepting library constants, not > > libTDS. > > > > (*) Feature backported in stable 1.1 branch. > > > > Implementation: > > - User guide converted to XML; > > - Always use little endian on network level, simpler and faster; > > - Converted some files to markdown; > > - Optimize bytes endianess conversion; > > - Made character lookup faster making character conversion quicker; > > - Optimize data padding in CT-Library; > > - Fix some build dependencies causing some files to not be properly > > recompiled during development; > > - Add "freeze" support allowing to pause sending in order to simplify > > lengths computations sending data. > > Is there a plan to implement the missing ODBC function? > There is only one left... > > Thank you. > > Hi, I suppose you refer to SQLDescribeParam. Currently no plan but using new MSSQL and store procedure suggested should not be that hard. Surely not for 1.2 (maybe 1.2.1 ;-) ) Regards, Frediano From ikorot01 at gmail.com Tue Jun 9 14:47:45 2020 From: ikorot01 at gmail.com (Igor Korot) Date: Tue, 9 Jun 2020 13:47:45 -0500 Subject: [freetds] FreeTDS 1.2 Release Candidate 2 In-Reply-To: References: Message-ID: Frediano, On Tue, Jun 9, 2020 at 1:25 PM Frediano Ziglio wrote: > > Il giorno mar 9 giu 2020 alle ore 16:18 Igor Korot ha > scritto: > > > Frediano, > > > > On Tue, Jun 9, 2020 at 7:34 AM Frediano Ziglio wrote: > > > > > > Hi, > > > just another updated release candidate. > > > > > > Changes since previous release candidate: > > > - Small update to user guide; > > > - Fix build for OpenVMS; > > > - Fix build from git for MacOS. > > > > > > > > > Summary of Changes in release 1.2 > > > --------------------------------- > > > User visible (not in a particular order): > > > - Sybase server: > > > - All strings are now converted as MSSQL; > > > - Support kerberos login; > > > - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION > > and > > > DBSETSERVERPRINCIPAL; > > > - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH, > > > CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH; > > > - Bulk copies: > > > - DB-Library: fix trim of unicode fields; > > > - (*) Apply character conversion for Sybase, like MSSQL; > > > - (*) Ignore computed columns; > > > - (*) Properly support multibyte strings in column names; > > > - (*) DB-Library: stop correctly on BCPMAXERRS setting; > > > - (*) DB-Library: do not try to convert skipped rows reading file > > allowing > > > for instance to load CVS files; > > > - (*) CT-Library: added CS_DATABASE property to allows to connect > > correctly > > > to Azure servers; > > > - (*) Improve support for MS XML columns for both DB-Library and > > CT-Library; > > > - (*) Fix some issues with MSSQL server redirection (used for instance in > > > Azure); > > > - (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns; > > > - Better support for SQL_VARIANT: > > > - Better column checks; > > > - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE; > > > - Some updates to server part: > > > - Set correctly initial state; > > > - IPv6 support; > > > - Fix TDS 7.2 logins; > > > - Support extended character using domain logins under Unix; > > > - Improve MARS: > > > - Less memory copies; > > > - (*) Remove possible deadlock; > > > - Handle wrapping sequence/window numbers; > > > - Make sure we sent the wanted packet; > > > - (*) Support UTF-16 surrogate pairs in odbc_wide2utf and > > > odbc_set_string_flag > > > fixing some character encoding support; > > > - (*) Fix multiple queries, used by ODBC to optimize data load; > > > - (*) Improve emulated parameter queries, fixing minor issues and > > reducing > > > memory usage; > > > - Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic > > detection); > > > - CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE; > > > - (*) CT-Library: fix cs_will_convert accepting library constants, not > > > libTDS. > > > > > > (*) Feature backported in stable 1.1 branch. > > > > > > Implementation: > > > - User guide converted to XML; > > > - Always use little endian on network level, simpler and faster; > > > - Converted some files to markdown; > > > - Optimize bytes endianess conversion; > > > - Made character lookup faster making character conversion quicker; > > > - Optimize data padding in CT-Library; > > > - Fix some build dependencies causing some files to not be properly > > > recompiled during development; > > > - Add "freeze" support allowing to pause sending in order to simplify > > > lengths computations sending data. > > > > Is there a plan to implement the missing ODBC function? > > There is only one left... > > > > Thank you. > > > > Hi, > I suppose you refer to SQLDescribeParam. Yes, I am. ;-) > > Currently no plan but using new MSSQL and store procedure suggested should > not be that hard. > > Surely not for 1.2 (maybe 1.2.1 ;-) ) I hope so. Because I need it for both Sybase and MS SQL. ;-) Could you please add it to your TO DO? Thank you. > > Regards, > Frediano > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds From elena.black at amundipioneer.com Fri Jun 19 10:00:59 2020 From: elena.black at amundipioneer.com (Black Elena (AMUNDI-PIONEER.USA)) Date: Fri, 19 Jun 2020 14:00:59 +0000 Subject: [freetds] Microsoft SQL Server 2016 SSL Message-ID: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com> Hi I set up SSL on an instance of MS SQL Server 2016. Confirmed that all connections (using SQL Server Management Server as a first step) were encrypted. I changed the flag, Force Encryption to yes on the instance. The Certificate is set up as in the documentation using the Server name as CN (I am going to add a different instance using the CN as the sql server network resource name, am waiting on that). I set up an entry (manually) in the freeTDS.conf file as follows: INSTANCE_NAME freeTDS version 8.0 encryption = true Port 1453 The error I get is: Error, failed to connect to INSTANCE_NAME !!!
FreeTDS: db-lib: exiting because client error handler returned INT_EXIT for msgno 20002

Can someone assist?

Thank you!

[cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]

Elena Black
Sr. DBA Administrator
60 State Street
Boston, MA 02109
Web: www.amundi.com
Tel: +33 1 617 697-8213
@: elena.black at amundipioneer.com
Amundi Pioneer
A company of the Amundi group

Visit us on:

[twitter]  [linkedin]    [facebook]    [Sans titre-1]    [youtube] 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2890 bytes
Desc: image001.png
URL: 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 1588 bytes
Desc: image003.png
URL: 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 1503 bytes
Desc: image005.png
URL: 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 1368 bytes
Desc: image007.png
URL: 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.png
Type: image/png
Size: 2012 bytes
Desc: image009.png
URL: 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.png
Type: image/png
Size: 1548 bytes
Desc: image011.png
URL: 

From freddy77 at gmail.com  Fri Jun 19 11:44:01 2020
From: freddy77 at gmail.com (Frediano Ziglio)
Date: Fri, 19 Jun 2020 16:44:01 +0100
Subject: [freetds] Microsoft SQL Server 2016 SSL
In-Reply-To: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com>
References: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com>
Message-ID: 

Il giorno ven 19 giu 2020 alle ore 15:04 Black Elena (AMUNDI-PIONEER.USA) <
elena.black at amundipioneer.com> ha scritto:

> Hi
>
> I set up SSL on an instance of MS SQL Server 2016. Confirmed that all
> connections (using SQL Server Management Server as a first step) were
> encrypted. I changed the flag,  Force Encryption to yes on the instance.
> The Certificate is set up as in the documentation using the Server name as
> CN (I am going to add a different instance using the CN as the sql server
> network resource name, am waiting on that).
>
> I set up an entry (manually) in the freeTDS.conf file as follows:
>
> INSTANCE_NAME
> freeTDS version 8.0
> encryption = true
> Port 1453
>
> The error I get is:
>
> Error, failed to connect to INSTANCE_NAME !!!
>
> FreeTDS: db-lib: exiting because client error handler returned INT_EXIT
> for msgno 20002
>
> Can someone assist?
>
> Thank you!
>
> [cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]
>
> Elena Black
> Sr. DBA Administrator
> 60 State Street
> Boston, MA 02109
> Web: www.amundi.com
> Tel: +33 1 617 697-8213
> @: elena.black at amundipioneer.com
> Amundi Pioneer
> A company of the Amundi group
>
>
Hi,
  see http://www.freetds.org/userguide/ChoosingTdsProtocol.html and
http://www.freetds.org/userguide/freetdsconf.html.
Also try to solve with http://www.freetds.org/userguide/serverthere.html.

Regards,
  Frediano

From elena.black at amundipioneer.com  Tue Jun 23 15:06:31 2020
From: elena.black at amundipioneer.com (Black Elena (AMUNDI-PIONEER.USA))
Date: Tue, 23 Jun 2020 19:06:31 +0000
Subject: [freetds] [Marketing Mail] Re:  Microsoft SQL Server 2016 SSL
In-Reply-To: 
References: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com>
 
Message-ID: <1d25d4d4049442839b9395f5b47d6d0c@amundipioneer.com>

Hi thank you for your assistance and sorry for the late reply.

To clarify, if using SQL Server 2016, the highest version that it supports is 7.4? We are using version 8.0 so I need to override the version in the .conf file?

I have tried the following settings:

host = ClusterResourceName
  port = xxxx
  tds version =  7.4
  instance = MSS_SSLINSTANCE_XXX
  encryption = request

none seem to work. 

I CAN ping the server. Am working on getting telnet allowed through the firewall. That will be tomorrow. Also, the settings for the conf file are stored in a Mysql db, it gets overwritten whenever we add in a new instance, which is yet another issue that I will have to work through because the ssl settings that I set up in the .conf file get removed when a new instance is added. I can see the sql that is used to write the file, it only takes the server/hostname and port no other settings are brought forth.

Elena Black
Sr. DBA Administrator
60 State Street
Boston, MA 02109 
Web: www.amundi.com
Tel: +33 1 617 697-8213
@: elena.black at amundipioneer.com
Amundi Pioneer
A company of the Amundi group 

Visit us on: 

        

-----Original Message-----
From: FreeTDS  On Behalf Of Frediano Ziglio
Sent: Friday, June 19, 2020 11:44 AM
To: FreeTDS Development Group 
Subject: [Marketing Mail] Re: [freetds] Microsoft SQL Server 2016 SSL

Il giorno ven 19 giu 2020 alle ore 15:04 Black Elena (AMUNDI-PIONEER.USA) < elena.black at amundipioneer.com> ha scritto:

> Hi
>
> I set up SSL on an instance of MS SQL Server 2016. Confirmed that all 
> connections (using SQL Server Management Server as a first step) were 
> encrypted. I changed the flag,  Force Encryption to yes on the instance.
> The Certificate is set up as in the documentation using the Server 
> name as CN (I am going to add a different instance using the CN as the 
> sql server network resource name, am waiting on that).
>
> I set up an entry (manually) in the freeTDS.conf file as follows:
>
> INSTANCE_NAME
> freeTDS version 8.0
> encryption = true
> Port 1453
>
> The error I get is:
>
> Error, failed to connect to INSTANCE_NAME !!!
 style="font-size:12px; 
> font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; 
> background-color:white;">
> FreeTDS: db-lib: exiting because client error handler returned 
> INT_EXIT for msgno 20002
>
> Can someone assist?
>
> Thank you!
>
> [cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]
>
> Elena Black
> Sr. DBA Administrator
> 60 State Street
> Boston, MA 02109
> Web: www.amundi.com
> Tel: +33 1 617 697-8213
> @: elena.black at amundipioneer.com
> Amundi Pioneer
> A company of the Amundi group
>
>
Hi,
  see http://www.freetds.org/userguide/ChoosingTdsProtocol.html and http://www.freetds.org/userguide/freetdsconf.html.
Also try to solve with http://www.freetds.org/userguide/serverthere.html.

Regards,
  Frediano
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds

From marsupilami79 at gmx.de  Wed Jun 24 04:34:31 2020
From: marsupilami79 at gmx.de (Marsupilami79)
Date: Wed, 24 Jun 2020 10:34:31 +0200
Subject: [freetds] FreeTDS Reference Manual is not accessible
Message-ID: <56bb6636-3ef9-ee95-96ec-6900886f66e7@gmx.de>

Hello,

the link to the Reference Manual on the FreeTDS homepage doesn't work
anymore. Is this by intention?

Best regards,

Jan

From freddy77 at gmail.com  Wed Jun 24 08:49:01 2020
From: freddy77 at gmail.com (Frediano Ziglio)
Date: Wed, 24 Jun 2020 13:49:01 +0100
Subject: [freetds] FreeTDS Reference Manual is not accessible
In-Reply-To: <56bb6636-3ef9-ee95-96ec-6900886f66e7@gmx.de>
References: <56bb6636-3ef9-ee95-96ec-6900886f66e7@gmx.de>
Message-ID: 

Hi,
  I'll check, not expected. Probably some build failure.

Thanks,
   Frediano


Il giorno mer 24 giu 2020 alle ore 09:41 Marsupilami79 
ha scritto:

> Hello,
>
> the link to the Reference Manual on the FreeTDS homepage doesn't work
> anymore. Is this by intention?
>
> Best regards,
>
> Jan
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>

From freddy77 at gmail.com  Thu Jun 25 08:08:34 2020
From: freddy77 at gmail.com (Frediano Ziglio)
Date: Thu, 25 Jun 2020 13:08:34 +0100
Subject: [freetds] FreeTDS Reference Manual is not accessible
In-Reply-To: <56bb6636-3ef9-ee95-96ec-6900886f66e7@gmx.de>
References: <56bb6636-3ef9-ee95-96ec-6900886f66e7@gmx.de>
Message-ID: 

Hi,
  fixed.

Thanks,
  Frediano


Il giorno mer 24 giu 2020 alle ore 09:41 Marsupilami79 
ha scritto:

> Hello,
>
> the link to the Reference Manual on the FreeTDS homepage doesn't work
> anymore. Is this by intention?
>
> Best regards,
>
> Jan
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>

From freddy77 at gmail.com  Thu Jun 25 08:18:54 2020
From: freddy77 at gmail.com (Frediano Ziglio)
Date: Thu, 25 Jun 2020 13:18:54 +0100
Subject: [freetds] FreeTDS 1.2 Release Candidate 3
Message-ID: 

Hi,
    just another updated release candidate.

This should be the last release candidate.

Changes since previous release candidate:
- Fix an issue with pool server not disconnecting from idle servers if no
activity;
- Fix SQLColumns from different database;
- Fixed Doxygen reference manual on the website.

Summary of Changes in release 1.2
---------------------------------
User visible (not in a particular order):
- Sybase server:
  - All strings are now converted as MSSQL;
  - Support kerberos login;
  - DB-Library: add DBSETNETWORKAUTH, DBSETMUTUALAUTH, DBSETDELEGATION and
    DBSETSERVERPRINCIPAL;
  - CT-Library: add CS_SEC_NETWORKAUTH, CS_SEC_NETWORKAUTH,
    CS_SEC_NETWORKAUTH and CS_SEC_NETWORKAUTH;
- Bulk copies:
  - DB-Library: fix trim of unicode fields;
  - (*) Apply character conversion for Sybase, like MSSQL;
  - (*) Ignore computed columns;
  - (*) Properly support multibyte strings in column names;
  - (*) DB-Library: stop correctly on BCPMAXERRS setting;
  - (*) DB-Library: do not try to convert skipped rows reading file allowing
    for instance to load CVS files;
- (*) CT-Library: added CS_DATABASE property to allows to connect correctly
  to Azure servers;
- (*) Improve support for MS XML columns for both DB-Library and CT-Library;
- (*) Fix some issues with MSSQL server redirection (used for instance in
  Azure);
- (*) Change SQL_DESC_OCTET_LENGTH value for wise character columns;
- Better support for SQL_VARIANT:
  - Better column checks;
  - (*) CT-Library: now supported, columns are returned as CS_CHAR_TYPE;
- Some updates to server part:
  - Set correctly initial state;
  - IPv6 support;
  - Fix TDS 7.2 logins;
- Support extended character using domain logins under Unix;
- Improve MARS:
  - Less memory copies;
  - (*) Remove possible deadlock;
  - Handle wrapping sequence/window numbers;
  - Make sure we sent the wanted packet;
- (*) Support UTF-16 surrogate pairs in odbc_wide2utf and
odbc_set_string_flag
  fixing some character encoding support;
- (*) Fix multiple queries, used by ODBC to optimize data load;
- (*) Improve emulated parameter queries, fixing minor issues and reducing
  memory usage;
- Support DBVERSION_UNKNOWN in dbsetlversion (will use automatic detection);
- CT-Library: define CS_MIN_SYBTYPE and CS_MAX_SYBTYPE;
- (*) CT-Library: fix cs_will_convert accepting library constants, not
libTDS.

(*) Feature backported in stable 1.1 branch.

Implementation:
- User guide converted to XML;
- Always use little endian on network level, simpler and faster;
- Converted some files to markdown;
- Optimize bytes endianess conversion;
- Made character lookup faster making character conversion quicker;
- Optimize data padding in CT-Library;
- Fix some build dependencies causing some files to not be properly
  recompiled during development;
- Add "freeze" support allowing to pause sending in order to simplify
  lengths computations sending data.

Kind Regards,
   Frediano

From freddy77 at gmail.com  Fri Jun 26 11:59:21 2020
From: freddy77 at gmail.com (Frediano Ziglio)
Date: Fri, 26 Jun 2020 16:59:21 +0100
Subject: [freetds] [Marketing Mail] Re: Microsoft SQL Server 2016 SSL
In-Reply-To: <1d25d4d4049442839b9395f5b47d6d0c@amundipioneer.com>
References: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com>
 
 <1d25d4d4049442839b9395f5b47d6d0c@amundipioneer.com>
Message-ID: 

Hi,

Il giorno mar 23 giu 2020 alle ore 20:08 Black Elena (AMUNDI-PIONEER.USA) <
elena.black at amundipioneer.com> ha scritto:

> Hi thank you for your assistance and sorry for the late reply.
>
> To clarify, if using SQL Server 2016, the highest version that it supports
> is 7.4? We are using version 8.0 so I need to override the version in the
> .conf file?
>
>
Last version of the protocol is still 7.4, also for MSSQL 2019. Microsoft
moved to feature extensions not bumping protocol versions.
Latest FreeTDS versions default to "auto" as protocol version which will
work using the latest protocol version available.

I have tried the following settings:
>
> host = ClusterResourceName
>   port = xxxx
>   tds version =  7.4
>   instance = MSS_SSLINSTANCE_XXX
>   encryption = request
>
>
Either port or instance. Port is faster.


> none seem to work.
>
> I CAN ping the server. Am working on getting telnet allowed through the
> firewall. That will be tomorrow. Also, the settings for the conf file are
> stored in a Mysql db, it gets overwritten whenever we add in a new
> instance, which is yet another issue that I will have to work through
> because the ssl settings that I set up in the .conf file get removed when a
> new instance is added. I can see the sql that is used to write the file, it
> only takes the server/hostname and port no other settings are brought forth.
>
>
If you cannot telnet (or netcat or other tool) at mssql port you simply
cannot connect.

Frediano

Elena Black
> Sr. DBA Administrator
> 60 State Street
> Boston, MA 02109
> Web: www.amundi.com
> Tel: +33 1 617 697-8213
> @: elena.black at amundipioneer.com
> Amundi Pioneer
> A company of the Amundi group
>
> Visit us on:
>
>
>
> -----Original Message-----
> From: FreeTDS  amundipioneer.com at lists.ibiblio.org> On Behalf Of Frediano Ziglio
> Sent: Friday, June 19, 2020 11:44 AM
> To: FreeTDS Development Group 
> Subject: [Marketing Mail] Re: [freetds] Microsoft SQL Server 2016 SSL
>
> Il giorno ven 19 giu 2020 alle ore 15:04 Black Elena (AMUNDI-PIONEER.USA)
> < elena.black at amundipioneer.com> ha scritto:
>
> > Hi
> >
> > I set up SSL on an instance of MS SQL Server 2016. Confirmed that all
> > connections (using SQL Server Management Server as a first step) were
> > encrypted. I changed the flag,  Force Encryption to yes on the instance.
> > The Certificate is set up as in the documentation using the Server
> > name as CN (I am going to add a different instance using the CN as the
> > sql server network resource name, am waiting on that).
> >
> > I set up an entry (manually) in the freeTDS.conf file as follows:
> >
> > INSTANCE_NAME
> > freeTDS version 8.0
> > encryption = true
> > Port 1453
> >
> > The error I get is:
> >
> > Error, failed to connect to INSTANCE_NAME !!!
 > style="font-size:12px;
> > font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black;
> > background-color:white;">
> > FreeTDS: db-lib: exiting because client error handler returned
> > INT_EXIT for msgno 20002
> >
> > Can someone assist?
> >
> > Thank you!
> >
> > [cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]
> >
> > Elena Black
> > Sr. DBA Administrator
> > 60 State Street
> > Boston, MA 02109
> > Web: www.amundi.com
> > Tel: +33 1 617 697-8213
> > @: elena.black at amundipioneer.com
> > Amundi Pioneer
> > A company of the Amundi group
> >
> >
> Hi,
>   see http://www.freetds.org/userguide/ChoosingTdsProtocol.html and
> http://www.freetds.org/userguide/freetdsconf.html.
> Also try to solve with http://www.freetds.org/userguide/serverthere.html.
>
> Regards,
>   Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>

From elena.black at amundipioneer.com  Fri Jun 26 12:10:54 2020
From: elena.black at amundipioneer.com (Black Elena (AMUNDI-PIONEER.USA))
Date: Fri, 26 Jun 2020 16:10:54 +0000
Subject: [freetds] [Marketing Mail] Re: [Marketing Mail] Re: Microsoft
 SQL Server 2016 SSL
In-Reply-To: 
References: <4c56a8e6917a40c4a214150662c4a9cc@amundipioneer.com>
 
 <1d25d4d4049442839b9395f5b47d6d0c@amundipioneer.com>
 
Message-ID: 

Hello:
Thanks for the assistance! I'm going through all your suggestions. But still no luck. I know I'm missing one small thing somewhere.

If I turn SSL off at the database, and make no changes, freeTDS.conf,  freeTDS connects fine and runs the scripts.

Even with these settings in the freeTDS.conf

[ServerName]
  host = XXXXX
  port = XXXX
  encrypt = request
  ca file =  XXXX/XXX/freetds/etc/xxxx_xx_xx_xxxxx_xxxxx_xx.pem

Elena Black
Sr. DBA Administrator
60 State Street
Boston, MA 02109 
Web: www.amundi.com
Tel: +33 1 617 697-8213
@: elena.black at amundipioneer.com
Amundi Pioneer
A company of the Amundi group 

Visit us on: 

        

-----Original Message-----
From: FreeTDS  On Behalf Of Frediano Ziglio
Sent: Friday, June 26, 2020 11:59 AM
To: FreeTDS Development Group 
Subject: [Marketing Mail] Re: [freetds] [Marketing Mail] Re: Microsoft SQL Server 2016 SSL

Hi,

Il giorno mar 23 giu 2020 alle ore 20:08 Black Elena (AMUNDI-PIONEER.USA) < elena.black at amundipioneer.com> ha scritto:

> Hi thank you for your assistance and sorry for the late reply.
>
> To clarify, if using SQL Server 2016, the highest version that it 
> supports is 7.4? We are using version 8.0 so I need to override the 
> version in the .conf file?
>
>
Last version of the protocol is still 7.4, also for MSSQL 2019. Microsoft moved to feature extensions not bumping protocol versions.
Latest FreeTDS versions default to "auto" as protocol version which will work using the latest protocol version available.

I have tried the following settings:
>
> host = ClusterResourceName
>   port = xxxx
>   tds version =  7.4
>   instance = MSS_SSLINSTANCE_XXX
>   encryption = request
>
>
Either port or instance. Port is faster.


> none seem to work.
>
> I CAN ping the server. Am working on getting telnet allowed through 
> the firewall. That will be tomorrow. Also, the settings for the conf 
> file are stored in a Mysql db, it gets overwritten whenever we add in 
> a new instance, which is yet another issue that I will have to work 
> through because the ssl settings that I set up in the .conf file get 
> removed when a new instance is added. I can see the sql that is used 
> to write the file, it only takes the server/hostname and port no other settings are brought forth.
>
>
If you cannot telnet (or netcat or other tool) at mssql port you simply cannot connect.

Frediano

Elena Black
> Sr. DBA Administrator
> 60 State Street
> Boston, MA 02109
> Web: www.amundi.com
> Tel: +33 1 617 697-8213
> @: elena.black at amundipioneer.com
> Amundi Pioneer
> A company of the Amundi group
>
> Visit us on:
>
>
>
> -----Original Message-----
> From: FreeTDS  amundipioneer.com at lists.ibiblio.org> On Behalf Of Frediano Ziglio
> Sent: Friday, June 19, 2020 11:44 AM
> To: FreeTDS Development Group 
> Subject: [Marketing Mail] Re: [freetds] Microsoft SQL Server 2016 SSL
>
> Il giorno ven 19 giu 2020 alle ore 15:04 Black Elena 
> (AMUNDI-PIONEER.USA) < elena.black at amundipioneer.com> ha scritto:
>
> > Hi
> >
> > I set up SSL on an instance of MS SQL Server 2016. Confirmed that 
> > all connections (using SQL Server Management Server as a first step) 
> > were encrypted. I changed the flag,  Force Encryption to yes on the instance.
> > The Certificate is set up as in the documentation using the Server 
> > name as CN (I am going to add a different instance using the CN as 
> > the sql server network resource name, am waiting on that).
> >
> > I set up an entry (manually) in the freeTDS.conf file as follows:
> >
> > INSTANCE_NAME
> > freeTDS version 8.0
> > encryption = true
> > Port 1453
> >
> > The error I get is:
> >
> > Error, failed to connect to INSTANCE_NAME !!!
 > style="font-size:12px; 
> > font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; 
> > background-color:white;">
> > FreeTDS: db-lib: exiting because client error handler returned 
> > INT_EXIT for msgno 20002
> >
> > Can someone assist?
> >
> > Thank you!
> >
> > [cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]
> >
> > Elena Black
> > Sr. DBA Administrator
> > 60 State Street
> > Boston, MA 02109
> > Web: www.amundi.com
> > Tel: +33 1 617 697-8213
> > @: elena.black at amundipioneer.com
> > Amundi Pioneer
> > A company of the Amundi group
> >
> >
> Hi,
>   see http://www.freetds.org/userguide/ChoosingTdsProtocol.html and 
> http://www.freetds.org/userguide/freetdsconf.html.
> Also try to solve with http://www.freetds.org/userguide/serverthere.html.
>
> Regards,
>   Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds

From bseely at stsci.edu  Tue Jun 30 00:01:45 2020
From: bseely at stsci.edu (Bruce Seely)
Date: Tue, 30 Jun 2020 04:01:45 +0000
Subject: [freetds] Need help understanding an error
Message-ID: <944A5342-7FB2-4574-8501-C9DEB6A5DA28@stsci.edu>

We are using freeTDS with the ODBC package that is provided by our Lisp vendor.
Beginning with freeTDS version 1.1.1, we started seeing an error for queries that worked in earlier releases:

Error: While getting numeric column info, Allegro ODBC detected an error: error code returned


The ODBC code has a function SQLCOLATTRIBUTES that calls freeTDS code.
The same call that worked in pre 1.1.1 releases, fails now.
Also, when the freeTDS call fails, no reason is provided.

Below are traces of the test run in versions 1.00.99 and 1.1.1.

We are complaining to the Lisp folks, and they don?t know what to do, since there is no explanation for the error.
What changed in version 1.1 that would cause this?

Thank you very much for your help.

Bruce Seely
Space Telescope Science Institute



;;;;;;; This is what is being done by the test function  ;;;;;;;;;;;;;;;;

  (setq db (connect :data-source-name "R2D2" :user "bseely" :password ?..." ))
  (sql "use pps_lrp_alpha" :db db)
  (sql "select * from ppsdb_version" :db db))

;;;;;;; run in version 1.00.99  ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

CL-USER(2): (test "ppsdb_version")
>>doing (DBI::WITH-NATIVE-STRING-ODBC (DBI::SQL-STATEMENT
                                       DBI::SQL-STATEMENT
                                       DBI::DB)
          (DBI::SQLEXECDIRECT DBI::HSTMT DBI::SQL-STATEMENT
                              DBI::SQL_NTS))%<< and it returns 1
; Autoloading for FOREIGN-FUNCTIONS:CHAR*-TO-STRING:
; Fast loading from bundle code/ffcompat.fasl.
>>doing (DBI::SQLNUMRESULTCOLS DBI::HSTMT DBI::COUNT-VAR)%<< and it returns 0
>>doing (DBI::SQLMORERESULTS DBI::HSTMT)%<< and it returns 100
>>doing (DBI::WITH-NATIVE-STRING-ODBC (DBI::SQL-STATEMENT
                                       DBI::SQL-STATEMENT
                                       DBI::DB)
          (DBI::SQLEXECDIRECT DBI::HSTMT DBI::SQL-STATEMENT
                              DBI::SQL_NTS))%<< and it returns 0
>>doing (DBI::SQLNUMRESULTCOLS DBI::HSTMT DBI::COUNT-VAR)%<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             1 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             2 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             3 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             4 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (DBI::BLOCK-CHECK #:G1415 (DBI::SQLFETCH #:G1412))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK #:G1415 (DBI::SQLFETCH #:G1412))%<< and it returns 100
>>doing (DBI::WITH-NATIVE-STRING-ODBC (DBI::SQL-STATEMENT
                                       DBI::SQL-STATEMENT
                                       DBI::DB)
          (DBI::SQLEXECDIRECT DBI::HSTMT DBI::SQL-STATEMENT
                              DBI::SQL_NTS))%<< and it returns 0
>>doing (DBI::SQLNUMRESULTCOLS DBI::HSTMT DBI::COUNT-VAR)%<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             1 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             2 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             3 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             4 1011
                             #
                             256
                             #
                             0)
 0[2]: returned 0
<< and it returns 0
>>doing (DBI::BLOCK-CHECK #:G1415 (DBI::SQLFETCH #:G1412))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK DBI::DB
                          (DBI::SQLGETDATA DBI::HSTMT DBI::INDEX
                                           DBI::TYPECODE DBI::RES
                                           DBI::WIDTH DBI::LENRES))%<< and it returns 0
>>doing (DBI::BLOCK-CHECK #:G1415 (DBI::SQLFETCH #:G1412))%<< and it returns 100
(("1" "PPSDB86" "2020-02-11 18:26:38 -05:00" ""))
("id" "ppsdb_version" "build_time" "comment")
CL-USER(3):




;;;;;;; run in version 1.1.1  ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

CL-USER(2): (test "ppsdb_version")
>>doing (DBI::WITH-NATIVE-STRING-ODBC (DBI::SQL-STATEMENT
                                       DBI::SQL-STATEMENT
                                       DBI::DB)
          (DBI::SQLEXECDIRECT DBI::HSTMT DBI::SQL-STATEMENT
                              DBI::SQL_NTS))%<< and it returns 1
; Autoloading for FOREIGN-FUNCTIONS:CHAR*-TO-STRING:
; Fast loading from bundle code/ffcompat.fasl.
>>doing (DBI::SQLNUMRESULTCOLS DBI::HSTMT DBI::COUNT-VAR)%<< and it returns 0
>>doing (DBI::SQLMORERESULTS DBI::HSTMT)%<< and it returns 100
>>doing (DBI::WITH-NATIVE-STRING-ODBC (DBI::SQL-STATEMENT
                                       DBI::SQL-STATEMENT
                                       DBI::DB)
          (DBI::SQLEXECDIRECT DBI::HSTMT DBI::SQL-STATEMENT
                              DBI::SQL_NTS))%<< and it returns 0
>>doing (DBI::SQLNUMRESULTCOLS DBI::HSTMT DBI::COUNT-VAR)%<< and it returns 0
>>doing (IF* (EQL DBI::*ODBC-VERSION* 2)
           THEN (DBI::SQLCOLATTRIBUTES DBI::HSTMT DBI::COLUMN
                                       (IF*
                                        (EQL
                                         DBI::ATTRIBUTE
                                         DBI::SQL_DESC_NAME)
                                        THEN DBI::SQL_COLUMN_NAME
                                        ELSE DBI::ATTRIBUTE)
                                       DBI::RETVAL 256 DBI::CHAR-CNT 0)
           ELSE (DBI::SQLCOLATTRIBUTE DBI::HSTMT DBI::COLUMN
                                      DBI::ATTRIBUTE DBI::RETVAL 256
                                      DBI::CHAR-CNT 0))%
 0[2]: (DBI::SQLCOLATTRIBUTE #
                             1 1011
                             #
                             256
                             #
                             0)
 0[2]: returned -1
<< and it returns -1
Error: While getting numeric column info, Allegro ODBC detected an
       error: error code returned
  [condition type: ODBC-ERROR]

Restart actions (select using :continue):
 0: Return to Top Level (an "abort" restart).
 1: Abort entirely from this (lisp) process.
[1] CL-USER(3):