RE: bug in ODBC driver (and fix) - Mailing list pgsql-interfaces

From Max Khon
Subject RE: bug in ODBC driver (and fix)
Date
Msg-id Pine.BSF.4.21.0101231438330.12474-100000@iclub.nsu.ru
Whole thread Raw
In response to RE: bug in ODBC driver (and fix)  (Mindaugas Idzelis <mai3116@ritvax.isc.rit.edu>)
List pgsql-interfaces
hi, there!

On Fri, 19 Jan 2001, Mindaugas Idzelis wrote:

> The ODBC driver I had problems with is found at:
> ftp://ftp.postgresql.org/pub/odbc/latest/postdrv.exe
> 
> This is apparently revision v06-50-0000. I patched the sources to this
> particular version. I just realized that there is a copy of the odbc driver
> in the postgresql source tree. I'm going to try to compile that with visual
> c++ 6.0 now.
> 
> <time warp>
> 
> Got it to compile correctly, however, it doesn't link correctly. It's gettin
> some unresolved external symbols... by the looks of which look like its
> targeted to the unix platform.
> 
> connection.obj : error LNK2001: unresolved external symbol _htonl@4
> socket.obj : error LNK2001: unresolved external symbol _htonl@4
> psqlodbc.obj : error LNK2001: unresolved external symbol _WSACleanup@0
> psqlodbc.obj : error LNK2001: unresolved external symbol _WSAStartup@8
> socket.obj : error LNK2001: unresolved external symbol _closesocket@4
> socket.obj : error LNK2001: unresolved external symbol _shutdown@8
> socket.obj : error LNK2001: unresolved external symbol _connect@12
> socket.obj : error LNK2001: unresolved external symbol _socket@12
> socket.obj : error LNK2001: unresolved external symbol _htons@4
> socket.obj : error LNK2001: unresolved external symbol _gethostbyname@4
> socket.obj : error LNK2001: unresolved external symbol _inet_addr@4
> socket.obj : error LNK2001: unresolved external symbol _ntohl@4
> socket.obj : error LNK2001: unresolved external symbol _ntohs@4
> socket.obj : error LNK2001: unresolved external symbol _send@16
> socket.obj : error LNK2001: unresolved external symbol _recv@16
> Debug/psqlodbc.dll : fatal error LNK1120: 14 unresolved externals

you should add wsock32.lib to list of libraries your driver will be
linked with. you should also add psqlodbc.rc and psqlodbc.def to your
project. please read readme.txt (it should be in the same directory with
ODBC driver sources)

I have built ODBC driver from CVS tree with Visual C++ 6.0 yesterday
successfully and now Visio successfully reverse-engineers our database
scheme (with foreign keys). That's really cool.

/fjoe



pgsql-interfaces by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Newbe hacker, interface question on includes...
Next
From: Cedar Cox
Date:
Subject: RE: Re: extremely newbie questions