Okay I now have the libs being called well kinda.  Attached Is my code that
I am using also attached it the errors I am getting.  I am mainly concered
about the errors pertaining to the libpqd.lib.  The other errors I will work
out with MS!

Thank you all for your help!

-----Original Message-----
From: Jeroen T. Vermeulen [mailto:[EMAIL PROTECTED] 
Sent: Saturday, July 22, 2006 1:46 AM
To: DEV
Cc: [email protected]
Subject: Re: [libpqxx-general] Using lib files in MSVC++

On Fri, July 21, 2006 21:52, DEV wrote:

> I agree with you and do apologize to everyone on the list.

No problem, I'm sure--it's just that without the information, we can't
know how to help!


> The build seems to work because I do end up with the lib files.
>
> I have the lib files linked under Project->Settings->Link

Which lib files exactly, though?  What you show here does not use libpqxx
at all, only libpq...


> #include "C:\Program Files\PostgreSQL\8.1\include\libpq-fe.h"

On a side note: it's better not to write your #include statements like
this.  Better just to "#include <libpq-fe.h>", and then tell your compiler
that it should look in "C:\Program Files\PostgreSQL\8.1\include" for
additional header files.



> When I build the app I get
>
> Linking...
> psqltesting3.obj : error LNK2001: unresolved external symbol _PQconnectdb
> Debug/psqltesting3.exe : fatal error LNK1120: 1 unresolved externals
> Error executing link.exe.
>
> -----------------------------------------------------------------
>
> So I am using the wrong libpqxx lib file and need to rebuild using a newer
> version but I am not sure what version I should be using or I don't have
> the
> lib file being called right when I build the app.

Well, like I said, you don't need libpqxx at all in this case.  But in
either case--whether you use libpqxx or libpq--you do need to link to
libpq.  It looks like *maybe* that is not happening here.  Make sure
you're linking to libpq!  In some cases it may even matter in what order
you link things--if so, libpq should come after your own program on the
linking command line.

Of course it's equally possible that something else is going wrong. 
Windows is a bit different from most other systems when it comes to
libraries--but unfortunately I know very little about that part.


Jeroen



------ Build started: Project: tesing2, Configuration: Debug Win32 ------

Compiling...
tesing2.cpp
Linking...
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isalpha already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _free already defined in 
LIBCMTD.lib(dbgheap.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: __snprintf already defined in 
LIBCMTD.lib(snprintf.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _atoi already defined in 
LIBCMTD.lib(atox.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _malloc already defined in 
LIBCMTD.lib(dbgheap.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _strncpy already defined in 
LIBCMTD.lib(strncpy.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _getenv already defined in 
LIBCMTD.lib(getenv.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isspace already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _strchr already defined in 
LIBCMTD.lib(strchr.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _strncmp already defined in 
LIBCMTD.lib(strncmp.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _fclose already defined in 
LIBCMTD.lib(fclose.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _sprintf already defined in 
LIBCMTD.lib(sprintf.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _fflush already defined in 
LIBCMTD.lib(fflush.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _fprintf already defined in 
LIBCMTD.lib(fprintf.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _realloc already defined in 
LIBCMTD.lib(dbgheap.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: __vsnprintf already defined in 
LIBCMTD.lib(vsnprint.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _memmove already defined in 
LIBCMTD.lib(memmove.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _islower already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isxdigit already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isdigit already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isalnum already defined in 
LIBCMTD.lib(_ctype.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _tolower already defined in 
LIBCMTD.lib(tolower.obj)
msvcrtd.lib(MSVCR71D.dll) : error LNK2005: _isupper already defined in 
LIBCMTD.lib(_ctype.obj)
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _connectDBStart
libpqd.lib(fe-misc.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-protocol3.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _PQconnectPoll
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _PQconnectPoll
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _PQconnectPoll
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _PQconnectPoll
libpqd.lib(getaddrinfo.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-misc.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(thread.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _PQconnectPoll
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _connectNoDelay
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _makeEmptyPGconn
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _makeEmptyPGconn
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _freePGconn
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _internal_cancel
libpqd.lib(fe-secure.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _internal_cancel
libpqd.lib(fe-secure.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-protocol2.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-protocol3.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(inet_aton.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-connect.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _internal_cancel
libpqd.lib(ip.obj) : error LNK2001: unresolved external symbol [EMAIL PROTECTED]
libpqd.lib(getaddrinfo.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(fe-misc.obj) : error LNK2001: unresolved external symbol [EMAIL 
PROTECTED]
libpqd.lib(getaddrinfo.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pg_getaddrinfo
libpqd.lib(fe-misc.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pqGets
libpqd.lib(getaddrinfo.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pg_getnameinfo
libpqd.lib(fe-misc.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pqPuts
libpqd.lib(getaddrinfo.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pg_getnameinfo
libpqd.lib(fe-misc.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pqGetInt
libpqd.lib(fe-misc.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pqSocketPoll
libpqd.lib(noblock.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pg_set_noblock
libpqd.lib(thread.obj) : error LNK2019: unresolved external symbol [EMAIL 
PROTECTED] referenced in function _pqGethostbyname
C:\Documents and Settings\doyleb\My Documents\Visual Studio 
Projects\tesing2\Debug\tesing2.exe : fatal error LNK1120: 20 unresolved 
externals

Build log was saved at "file://c:\Documents and Settings\doyleb\My 
Documents\Visual Studio Projects\tesing2\tesing2\Debug\BuildLog.htm"
tesing2 - 59 error(s), 0 warning(s)


---------------------- Done ----------------------

    Build: 0 succeeded, 1 failed, 0 skipped


// This is the main project file for VC++ application project 
// generated using an Application Wizard.

#include "stdafx.h"
#include "C:\Dev\postgresql-8.1.4\src\include\libpq-fe.h"

#using <mscorlib.dll>

using namespace System;
//using namespace pqxx;

static void
exit_nicely(PGconn *conn)
{
        PQfinish(conn);
        exit(1);
}

int _tmain()
{
        const char *conninfo;
        PGconn     *conn;
    // TODO: Please replace the sample code below with your own.
    Console::WriteLine(S"Hello World");
                        conninfo = "dbname = template1 port = 5435 user = 
www00021";
//                      memcpy(conninfo , dbName, 9);
//                      memcpy(conninfo , " port = 5435 user = www00021", 28);

        /* Make a connection to the database */
        conn = PQconnectdb(conninfo);

        /* Check to see that the backend connection was successfully made */
        if (PQstatus(conn) != CONNECTION_OK)
        {
                fprintf(stderr, "Connection to database failed: %s",
                        PQerrorMessage(conn));
                exit_nicely(conn);
        }
        return 0;
}
_______________________________________________
Libpqxx-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/libpqxx-general

Reply via email to