Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

--_004_825744553010424695E4355C4DD3FDBD128B39AE41AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B39AE41AME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B39AE41AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I have an ODBC application on LINUX that needs to access databases on other=
machines using ODBC. I've downloaded the myodbc driver tarball for LINUX. =
I have a demo program that works with other drivers, but when I try to lin=
k to just the MYSql ODBC drivers I get the following:

make
g++ -g -m32 -o demoodbc -I../include demoodbc.c -L../lib -lmyodbc5 -lc
/usr/bin/ld: warning: libodbcinst.so.1, needed by ../lib/libmyodbc5.so, not=
found (try using -rpath or -rpath-link)
.../lib/libmyodbc5.so: undefined reference to `SQLSetConfigMode'
.../lib/libmyodbc5.so: undefined reference to `SQLValidDSN'
.../lib/libmyodbc5.so: undefined reference to `SQLInstallDriverEx'
.../lib/libmyodbc5.so: undefined reference to `SQLGetPrivateProfileString'
.../lib/libmyodbc5.so: undefined reference to `SQLRemoveDSNFromIni'
.../lib/libmyodbc5.so: undefined reference to `SQLPostInstallerError'
.../lib/libmyodbc5.so: undefined reference to `SQLGetConfigMode'
.../lib/libmyodbc5.so: undefined reference to `SQLWritePrivateProfileString'
.../lib/libmyodbc5.so: undefined reference to `SQLRemoveDriver'
.../lib/libmyodbc5.so: undefined reference to `SQLWriteDSNToIni'
collect2: ld returned 1 exit status
make: *** [demoodbc] Error 1

This shared library file was not in the distribution. Any idea where I can =
get it?

Thanks,

Mike


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas, TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com
GXS Blog
[cid:image001.gif@01CBFA97.320587A0]


--_000_825744553010424695E4355C4DD3FDBD128B39AE41AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:schemas-microsoft-com:office:s=
marttags"> et=3Dus-ascii"> d medium)"> nk=3Dpurple>

Re: Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

On 14/04/11 17:35, mike.rawlins@gxs.com wrote:
> Hi,
>
> I have an ODBC application on LINUX that needs to access databases on o=
ther machines using ODBC. I=92ve downloaded the myodbc driver tarball for=
LINUX. I have a demo program that works with other drivers, but when I t=
ry to link to just the MYSql ODBC drivers I get the following:
>
> make
>
> g++ -g -m32 -o demoodbc -I../include demoodbc.c -L../lib -lmyodbc5 -lc
>
> /usr/bin/ld: warning: libodbcinst.so.1, needed by ../lib/libmyodbc5.so,=
not found (try using -rpath or -rpath-link)
>
> ../lib/libmyodbc5.so: undefined reference to `SQLSetConfigMode'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLValidDSN'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLInstallDriverEx'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLGetPrivateProfileStrin=
g'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLRemoveDSNFromIni'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLPostInstallerError'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLGetConfigMode'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLWritePrivateProfileStr=
ing'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLRemoveDriver'
>
> ../lib/libmyodbc5.so: undefined reference to `SQLWriteDSNToIni'
>
> collect2: ld returned 1 exit status
>
> make: *** [demoodbc] Error 1
>
> This shared library file was not in the distribution. Any idea where I =
can get it?
>
> Thanks,
>
> Mike
>
> Mike Rawlins
> Sr. Software Engineer
> Chair, ASC X12 Technical Assessment Subcommittee
>
> 18111 Preston Road, Suite 600
> Dallas, TX 75252
> +1 972.643.3101 direct//
>
> mike.rawlins@gxs.com
>
> www.gxs.com
>
> GXS Blog
>
> GXS_2color_pos
>

You need to install the unixODBC driver manager. Depending on your linux =
distribution you might be able to install it as a package in which case l=
ook for unixodbc-bin or something like that. It will supply libodbc.so an=
d libodbcinst.so.

Martin
--=20
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

Martin Evans wrote:

"You need to install the unixODBC driver manager. Depending on your linux d=
istribution you might be able to install it as a package in which case look=
for unixodbc-bin or something like that. It will supply libodbc.so and lib=
odbcinst.so."

Thanks, that's a start, but in running a search and looking over the downlo=
ads I can't see anything like that. Might it be available under a differen=
t name?

If it helps, I'm building the application on a machine that does not have M=
ySQL installed. Do I need it, or can I just build with the ODBC drivers and=
the driver manager that you reference?


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas,=A0TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com=20
GXS Blog

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

Martin Evans wrote:

"You need to install the unixODBC driver manager. Depending on your linux d=
istribution you might be able to install it as a package in which case look=
for unixodbc-bin or something like that. It will supply libodbc.so and lib=
odbcinst.so."

And I responded:

Thanks, that's a start, but in running a search and looking over the downlo=
ads I can't see anything like that. Might it be available under a differen=
t name?

If it helps, I'm building the application on a machine that does not have M=
ySQL installed. Do I need it, or can I just build with the ODBC drivers and=
the driver manager that you reference?

Resolution:

It looks as if this is a generic Linux package and not specifically a MySQL=
package. I'm working with my systems admin to get it installed.

When all else fails read the directions (INSTALL in this case).


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas,=A0TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com=20
GXS Blog



-----Original Message-----
From: mike.rawlins@gxs.com [mailto:mike.rawlins@gxs.com]=20
Sent: Thursday, April 14, 2011 12:02 PM
To: myodbc@lists.mysql.com
Subject: RE: Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

Martin Evans wrote:

"You need to install the unixODBC driver manager. Depending on your linux d=
istribution you might be able to install it as a package in which case look=
for unixodbc-bin or something like that. It will supply libodbc.so and lib=
odbcinst.so."

Thanks, that's a start, but in running a search and looking over the downlo=
ads I can't see anything like that. Might it be available under a differen=
t name?

If it helps, I'm building the application on a machine that does not have M=
ySQL installed. Do I need it, or can I just build with the ODBC drivers and=
the driver manager that you reference?


Mike Rawlins
Sr. Software Engineer
Chair, ASC X12 Technical Assessment Subcommittee
18111 Preston Road, Suite 600
Dallas,=A0TX 75252
+1 972.643.3101 direct
mike.rawlins@gxs.com
www.gxs.com=20
GXS Blog

--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dmike.rawlins@gxs.c=
om


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg