Re: sql.h not found problem
RUSSELL DILKS <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, Thanks guys for trying to help me out - I really appreciate it. I have tried running the configure without the with-unixodbc switch and I get the same error. I have checked on the system and the sql.h file is in /usr/include and not /usr/local/include which is why I was using the /usr switch with the ./configure for freetds - I think maybe the /usr/local/include is the default so this is where the installer is looking when the switch is not supplied - but I am guessing here. A bit more info: I installed the unicodbc-dev package from the red hat rpm from the repository - the server is a DELL T300 with a new copy of Red Hat Enterprise - all software so far has been installed via the rpm's without my intervention, with the exception now of freetds. Have you got any ideas where I can go from here. Thanks again + best regards, Russ --- On Mon, 6/7/09, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: FreeTDS Digest, Vol 78, Issue 4 To: [email protected] Date: Monday, 6 July, 2009, 6:20 PM Send FreeTDS mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.ibiblio.org/mailman/listinfo/freetds or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of FreeTDS digest..." Today's Topics: 1. Re: sql.h not found problem (Frediano Ziglio) 2. Re: sql.h not found problem (Goyal, Pravin Shyam) ---------------------------------------------------------------------- Message: 1 Date: Mon, 6 Jul 2009 12:11:35 +0200 From: Frediano Ziglio <[email protected]> Subject: Re: [freetds] sql.h not found problem To: FreeTDS Development Group <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=UTF-8 Strange... perhaps a missing check, try removing --with-unixODBC switch during configure (configure whould detect unitODBX automatically) freddy77 2009/7/4 RUSSELL DILKS <[email protected]>: > Got that installed via rpm - seems to be installed in /usr - and ran the configure on freetds again like so './configure ?with-tdsver=8.0 ?with-unixODBC=/usr' and it went through without a problem. > BUT > If I run a make on it I get: > connectparams.c:90: error static declaration of 'SQLGetPrivateProfileString' follows non-static declaration. > /usr/include/odbcinst.h.170: error previous declaration of 'SQLPrivateProfileString' was here > > Any ideas - the make just fails now and I am again stuck > > --- On Sat, 4/7/09, [email protected] <[email protected]> wrote: > > > From: [email protected] <[email protected]> > Subject: FreeTDS Digest, Vol 78, Issue 2 > To: [email protected] > Date: Saturday, 4 July, 2009, 6:20 PM > > > Send FreeTDS mailing list submissions to > ??? [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > ??? http://lists.ibiblio.org/mailman/listinfo/freetds > or, via email, send a message with subject or body 'help' to > ??? [email protected] > > You can reach the person managing the list at > ??? [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of FreeTDS digest..." > > > Today's Topics: > > ???1. sql.h not found problem (RUSSELL DILKS) > ???2. Re: sql.h not found problem (Clint Hopper) > ???3. Re: sql.h not found problem (Frediano Ziglio) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 3 Jul 2009 17:45:03 +0000 (GMT) > From: RUSSELL DILKS <[email protected]> > Subject: [freetds] sql.h not found problem > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset=iso-8859-1 > > Hi Folks, > I have a red hat enterprise server which I need to get to talk to an MS Sql server. > I downloaded the freetds 0.8 package but when I run configure with ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot find sql.h > ? > I have done a search for sql.h on the system and it cannot find it ?? I guess I must be missing a library or something - I am pretty new to this - but I really am stumped. > ? > I have searched extensively for the answer and cannot get anywhere. > ? > Can anyone help me out. > ? > Thanks > > ------------------------------ > > Message: 2 > Date: Fri, 3 Jul 2009 13:00:37 -0500 > From: Clint Hopper <[email protected]> > Subject: Re: [freetds] sql.h not found problem > To: FreeTDS Development Group <[email protected]> > Message-ID: > ??? <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > Your missing a lib -dev package..I can't remember which one. > > On 7/3/09, RUSSELL DILKS <[email protected]> wrote: >> Hi Folks, >> I have a red hat enterprise server which I need to get to talk to an MS Sql >> server. >> I downloaded the freetds 0.8 package but when I run configure with >> ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot >> find sql.h >> >> I have done a search for sql.h on the system and it cannot find it ?? I >> guess I must be missing a library or something - I am pretty new to this - >> but I really am stumped. >> >> I have searched extensively for the answer and cannot get anywhere. >> >> Can anyone help me out. >> >> Thanks >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > -- > Sent from my mobile device > > Clint Hopper > > > ------------------------------ > > Message: 3 > Date: Sat, 4 Jul 2009 09:39:32 +0200 > From: Frediano Ziglio <[email protected]> > Subject: Re: [freetds] sql.h not found problem > To: FreeTDS Development Group <[email protected]> > Message-ID: > ??? <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > unixodbc-devel > > freddy77 > > 2009/7/3 Clint Hopper <[email protected]>: >> Your missing a lib -dev package..I can't remember which one. >> >> On 7/3/09, RUSSELL DILKS <[email protected]> wrote: >>> Hi Folks, >>> I have a red hat enterprise server which I need to get to talk to an MS Sql >>> server. >>> I downloaded the freetds 0.8 package but when I run configure with >>> ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot >>> find sql.h >>> >>> I have done a search for sql.h on the system and it cannot find it ?? I >>> guess I must be missing a library or something - I am pretty new to this - >>> but I really am stumped. >>> >>> I have searched extensively for the answer and cannot get anywhere. >>> >>> Can anyone help me out. >>> >>> Thanks >>> _______________________________________________ >>> FreeTDS mailing list >>> [email protected] >>> http://lists.ibiblio.org/mailman/listinfo/freetds >>> >> >> -- >> Sent from my mobile device >> >> Clint Hopper >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > > ------------------------------ > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > > > End of FreeTDS Digest, Vol 78, Issue 2 > ************************************** > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > ------------------------------ Message: 2 Date: Mon, 6 Jul 2009 10:20:12 +0000 From: "Goyal, Pravin Shyam" <[email protected]> Subject: Re: [freetds] sql.h not found problem To: FreeTDS Development Group <[email protected]> Message-ID: <95D24D994076904F8B79DB0C981F4F984C838E0FA1@GVW0440EXB.americas.hpqcorp.net> Content-Type: text/plain; charset="utf-8" Hi, How are you using ./configure for FreeTDS? Are you not specifying the library in which unixODBC is pre-installed? For example, I normally use, ./configure --with-tdsver=8.0 --with-unixODBC=/usr/local Also, Make sure that you have below file present /usr/local/include/sql.h. The sql.h comes from unixODBC package. I installed unixODBC inside /usr/local and hence sql.h is in include path as /usr/local/include. Sql.h file location would depend on where have you installed unixODBC. Please make sure that sql.h is present under <unixODBC-install-path>/include/ Apart from that I sometimes configure as below on HP-Ux systems: Configure FreeTDS 1. Download Freetds from here: http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz 2. Upload it on the server under /installer 3. Unzip it using: gunzip FreeTDS-stable.tgz 4. Un-tar it using: tar ?xvf FreeTDS-stable.tar 5. env CC=cc CFLAGS="+O2 -I/usr/local/include" LDFLAGS="-L/usr/local/lib/hpux32" ./configure --with-tdsver=8.0 --with-unixodbc=/usr/local --with-libiconv-prefix=/usr/local/lib/hpux32 6. Once ./configure as in step 5 is done, do make 7. Then go to /installer/freetds-0.82/src/tds/unittests/Makefile and change the line LIBS = ../libtds.la ../../replacements/libreplacements.la -lxnet To look LIBS = ../libtds.la ../../replacements/libreplacements.la -lxnet $(LIBICONV) 8. Come back to /installer/freetds-0.82/ 9. Do make check. You may see many checks failed. For me it showed 13 out of 16 tests failed. But, don?t worry. Go ahead to step 10 10. make install Thanks and regards, Pravin Goyal -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio Sent: Monday, July 06, 2009 3:42 PM To: FreeTDS Development Group Subject: Re: [freetds] sql.h not found problem Strange... perhaps a missing check, try removing --with-unixODBC switch during configure (configure whould detect unitODBX automatically) freddy77 2009/7/4 RUSSELL DILKS <[email protected]>: > Got that installed via rpm - seems to be installed in /usr - and ran the configure on freetds again like so './configure ?with-tdsver=8.0 ?with-unixODBC=/usr' and it went through without a problem. > BUT > If I run a make on it I get: > connectparams.c:90: error static declaration of 'SQLGetPrivateProfileString' follows non-static declaration. > /usr/include/odbcinst.h.170: error previous declaration of 'SQLPrivateProfileString' was here > > Any ideas - the make just fails now and I am again stuck > > --- On Sat, 4/7/09, [email protected] <[email protected]> wrote: > > > From: [email protected] <[email protected]> > Subject: FreeTDS Digest, Vol 78, Issue 2 > To: [email protected] > Date: Saturday, 4 July, 2009, 6:20 PM > > > Send FreeTDS mailing list submissions to > ??? [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > ??? http://lists.ibiblio.org/mailman/listinfo/freetds > or, via email, send a message with subject or body 'help' to > ??? [email protected] > > You can reach the person managing the list at > ??? [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of FreeTDS digest..." > > > Today's Topics: > > ???1. sql.h not found problem (RUSSELL DILKS) > ???2. Re: sql.h not found problem (Clint Hopper) > ???3. Re: sql.h not found problem (Frediano Ziglio) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 3 Jul 2009 17:45:03 +0000 (GMT) > From: RUSSELL DILKS <[email protected]> > Subject: [freetds] sql.h not found problem > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset=iso-8859-1 > > Hi Folks, > I have a red hat enterprise server which I need to get to talk to an MS Sql server. > I downloaded the freetds 0.8 package but when I run configure with ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot find sql.h > ? > I have done a search for sql.h on the system and it cannot find it ?? I guess I must be missing a library or something - I am pretty new to this - but I really am stumped. > ? > I have searched extensively for the answer and cannot get anywhere. > ? > Can anyone help me out. > ? > Thanks > > ------------------------------ > > Message: 2 > Date: Fri, 3 Jul 2009 13:00:37 -0500 > From: Clint Hopper <[email protected]> > Subject: Re: [freetds] sql.h not found problem > To: FreeTDS Development Group <[email protected]> > Message-ID: > ??? <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > Your missing a lib -dev package..I can't remember which one. > > On 7/3/09, RUSSELL DILKS <[email protected]> wrote: >> Hi Folks, >> I have a red hat enterprise server which I need to get to talk to an MS Sql >> server. >> I downloaded the freetds 0.8 package but when I run configure with >> ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot >> find sql.h >> >> I have done a search for sql.h on the system and it cannot find it ?? I >> guess I must be missing a library or something - I am pretty new to this - >> but I really am stumped. >> >> I have searched extensively for the answer and cannot get anywhere. >> >> Can anyone help me out. >> >> Thanks >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > -- > Sent from my mobile device > > Clint Hopper > > > ------------------------------ > > Message: 3 > Date: Sat, 4 Jul 2009 09:39:32 +0200 > From: Frediano Ziglio <[email protected]> > Subject: Re: [freetds] sql.h not found problem > To: FreeTDS Development Group <[email protected]> > Message-ID: > ??? <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > unixodbc-devel > > freddy77 > > 2009/7/3 Clint Hopper <[email protected]>: >> Your missing a lib -dev package..I can't remember which one. >> >> On 7/3/09, RUSSELL DILKS <[email protected]> wrote: >>> Hi Folks, >>> I have a red hat enterprise server which I need to get to talk to an MS Sql >>> server. >>> I downloaded the freetds 0.8 package but when I run configure with >>> ./configure --with-tdsver=8.0 --with-unixodbc I get the erro that it cannot >>> find sql.h >>> >>> I have done a search for sql.h on the system and it cannot find it ?? I >>> guess I must be missing a library or something - I am pretty new to this - >>> but I really am stumped. >>> >>> I have searched extensively for the answer and cannot get anywhere. >>> >>> Can anyone help me out. >>> >>> Thanks >>> _______________________________________________ >>> FreeTDS mailing list >>> [email protected] >>> http://lists.ibiblio.org/mailman/listinfo/freetds >>> >> >> -- >> Sent from my mobile device >> >> Clint Hopper >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > > ------------------------------ > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > > > End of FreeTDS Digest, Vol 78, Issue 2 > ************************************** > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds ------------------------------ _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds End of FreeTDS Digest, Vol 78, Issue 4 **************************************