Re: 0.83.dev.20100507 and Visual Studio 2010

just copy and past the code in text.
Here is my sample app. Getting the include statements correct is important.


// TestFreeTDS64.cpp : Defines the entry point for the console application.
//


#include <config.h>
#include <stdarg.h>
#include <stdio.h>
#include <assert.h>
#include <stdlib.h>
#include <sqlfront.h>
#include <sqldb.h>


int main(int argc, char* argv[])
{
    LOGINREC *login;
    //RETCODE erc;
       DBPROCESS *dbproc;

    if (dbinit() == FAIL)
       {
            return (-1);
    }

    if ((login = dblogin()) == NULL)
       {
            return (2);
    }

    dbsetifile((char*)"C:\\Users\\Paul\\Downloads\\FreeTDS\\FreeTDS_64Bit\\etc\\freetds.conf");

    DBSETLUSER(login, "***" );
    DBSETLPWD(login,  "***" );
    DBSETLCHARSET(login, "CP1253" );
    if ((dbproc = dbopen(login, "dev" )) == NULL)
       {
            return (-3);
    }

       return 0;

}//end global method main



From: [email protected] [mailto:[email protected]] On Behalf Of Harry Sfougaris
Sent: Sunday, May 09, 2010 2:02 PM
To: FreeTDS Development Group
Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010


Still behaves the same.

Did you get my message with the project?

I got a mail delivery error with 550 Error: illegal attachment type (state 18).



My freetds.log is as follows:

21:00:39.841 1468 (log.c:190):Starting log file for FreeTDS 0.65

      on 2010-05-09 21:00:39 with debug flags 0xffff.

21:00:39.841 1468 (iconv.c:78):Using trivial iconv

21:00:39.841 1468 (iconv.c:197):names for ISO-8859-1: ISO-8859-1

21:00:39.841 1468 (iconv.c:197):names for UTF-8: UTF-8

21:00:39.841 1468 (iconv.c:197):names for UCS-2LE: UCS-2LE

21:00:39.841 1468 (iconv.c:197):names for UCS-2BE: (null)

21:00:39.841 1468 (iconv.c:363):iconv to convert client-side data to the "ISO-8859-1" character set

21:00:39.841 1468 (iconv.c:516):tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

21:00:39.841 1468 (iconv.c:516):tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

21:00:39.841 1468 (net.c:210):Connecting to 10.1.1.11 port 1433 (TDS version 8.0)

21:00:39.841 1468 (util.c:334):tdserror(0000000001CE2590, 0000000001CEDE20, 20008, 0)

21:00:39.841 1468 (dblib.c:7782):dbperror(0000000001CE28F0, 20008, 0)

21:00:39.841 1468 (dblib.c:7835):20008: "Unable to open socket"

21:00:39.841 1468 (dblib.c:4781):default_err_handler 0000000001CE28F0, 9, 20008, 0, 000000013F170F40, 0000000001CEF7E021:00:39.841 1468 (dblib.c:4747):dbdead(0000000001CE28F0) [dead]

21:00:39.841 1468 (dblib.c:7856):"Unable to open socket", client returns 0 (INT_EXIT)

21:00:39.841 1468 (dblib.c:7903):FreeTDS: db-lib: exiting because client error handler returned 0 for msgno 20008



Harry



On 09 Μαϊ 2010, at 8:50 μ.μ., Paul Thurston wrote:



> whoops, found the bug. I forgot to move the Windows-specific headers to the include directory.

>

> Please re-download from http://www.netegrate.com/index_files/download/SqlServer/

>

> Make sure the include statements in your test application read as follows:

>

> #include <config.h>

> #include <stdarg.h>

> #include <stdio.h>

> #include <assert.h>

> #include <stdlib.h>

> #include <sqlfront.h>

> #include <sqldb.h>

>

> Also, please add the path to the unzipped include folder to the config settings in VC10 of your sample application.

>

>

>

> From: [email protected] [mailto:[email protected]] On Behalf Of Harry Sfougaris

> Sent: Sunday, May 09, 2010 12:17 PM

> To: FreeTDS Development Group

> Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010

>

>

> Thanks for that.

>

> This version "breaks" my Visual Studio test app (it crashes upon calling dbopen).

>

> I think it's exactly the same behaviour I was getting...

>

>

>

> I'm afraid it also doesn't work at all from Qt.

>

> It's like it doesn't understand at all these libraries.

>

> Are you really supposed to share libraries between compilers? I'm sure I had read somewhere that this is something that cannot be done (different formats).

>

>

>

> My build output is the following:

>

>

>

> Running build steps for project FreeTDSTest...

>

> Starting: c:/qt/2010.02.1/qt/bin/qmake.exe C:/Users/harry.MISSIRIAN/Desktop/QtTest/FreeTDSTest/FreeTDSTest.pro -spec win32-g++ -r Exited with code 0.

>

> Starting: C:/Qt/2010.02.1/mingw/bin/mingw32-make.exe -w

>

> mingw32-make: Entering directory `C:/Users/harry.MISSIRIAN/Desktop/QtTest/FreeTDSTest'

>

> C:/Qt/2010.02.1/mingw/bin/mingw32-make -f Makefile.Debug

>

> mingw32-make[1]: Entering directory `C:/Users/harry.MISSIRIAN/Desktop/QtTest/FreeTDSTest'

>

> g++ -enable-stdcall-fixup -Wl,-enable-auto-import

>

> g++ -Wl,-enable-runtime-pseudo-reloc -Wl,-subsystem,console -mthreads

>

> g++ -Wl -o debug\FreeTDSTest.exe debug/main.o -L"c:\Qt\2010.02.1\qt\lib"

>

> g++ C:/Freetds/x64/WS2_32.lib C:/Freetds/x64/lib/libTDS.lib

>

> g++ C:/Freetds/lib/FreeTDS.lib C:/Freetds/x64/lib/dblib.lib

>

> g++ -lQtNetworkd4 -lQtCored4

>

> mingw32-make[1]: Leaving directory `C:/Users/harry.MISSIRIAN/Desktop/QtTest/FreeTDSTest'

>

> mingw32-make: Leaving directory `C:/Users/harry.MISSIRIAN/Desktop/QtTest/FreeTDSTest'

>

> debug/main.o: In function `main':

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:60: undefined reference to `dbinit'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:64: undefined reference to `dberrhandle'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:65: undefined reference to `dbmsghandle'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:71: undefined reference to `dblogin'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:76: undefined reference to `dbsetifile'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:78: undefined reference to `dbsetlname'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:79: undefined reference to `dbsetlname'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:80: undefined reference to `dbsetlname'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:81: undefined reference to `dbsetlname'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:83: undefined reference to `tdsdbopen'

>

> C:\Users\harry.MISSIRIAN\Desktop\QtTest\FreeTDSTest/main.cpp:88: undefined reference to `dbuse'

>

> collect2: ld returned 1 exit status

>

> mingw32-make[1]: *** [debug\FreeTDSTest.exe] Error 1

>

> mingw32-make: *** [debug] Error 2

>

> Exited with code 2.

>

> Error while building project FreeTDSTest When executing build step 'Make'

>

>

>

> On 09 Μαϊ 2010, at 4:49 μ.μ., Paul Thurston wrote:

>

>

>

>> Harry:

>

>>

>

>> I've posted a 64 bit build with Buffer Security Check = OFF to

>

>> http://www.netegrate.com/index_files/download/SqlServer/

>

>> Please give it a test when you get a chance.

>

>>

>

>> Thanks,

>

>>

>

>> Paul

>

>>

>

>>

>

>> From: [email protected]

>

>> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Harry

>

>> Sfougaris

>

>> Sent: Saturday, May 08, 2010 6:09 PM

>

>> To: FreeTDS Development Group

>

>> Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010

>

>>

>

>>

>

>>>

>

>>

>

>>> The 32bit libraries that I posted for you are currently in production. This is a known good build.

>

>>

>

>>> This must be an issue in your environment (and in Windows 7, that usually means a security issue).

>

>>

>

>>>

>

>>

>

>>

>

>>

>

>>

>

>>

>

>> Actually, with all my testing I got mixed up, and didn't inform you about your libraries.

>

>>

>

>> Your libraries work from my test app in Visual Studio. They even return data, which is a huge progress for me!

>

>>

>

>>

>

>>

>

>> However, I cannot try them with Qt, as you must have compiled them with Buffer Security Check set to ON.

>

>>

>

>> (Configuration Properties / C/C++ / Code Generation).

>

>>

>

>> That puts a dependency on a lib I can't find bufferoverflowu.lib [I found it in a few places, but Qt says it can't read it]).

>

>>

>

>> Also, I get undefined references to many tds_ functions...

>

>>

>

>>

>

>>

>

>> Thanks,

>

>>

>

>> Harry

>

>>

>

>>

>

>>

>

>> _______________________________________________

>

>>

>

>> FreeTDS mailing list

>

>>

>

>> [email protected]<mailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]%3cmailto:[email protected]%3cmailto:[email protected]>>>

>

>>

>

>> http://lists.ibiblio.org/mailman/listinfo/freetds

>

>> _______________________________________________

>

>> FreeTDS mailing list

>

>> [email protected]<mailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]>>

>

>> http://lists.ibiblio.org/mailman/listinfo/freetds

>

>

>

> Harry Sfougaris

>

>

>

>

>

>

>

>

>

> _______________________________________________

>

> FreeTDS mailing list

>

> [email protected]<mailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]>>

>

> http://lists.ibiblio.org/mailman/listinfo/freetds

> _______________________________________________

> FreeTDS mailing list

> [email protected]<mailto:[email protected]>

> http://lists.ibiblio.org/mailman/listinfo/freetds



Harry Sfougaris









_______________________________________________

FreeTDS mailing list

[email protected]<mailto:[email protected]>

http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds