[freetds] 0.83.dev.20100507 and Visual Studio 2010

Paul Thurston pthurston at netegrate.com
Mon May 10 08:46:52 EDT 2010


Harry:

Check the log file in the zip file, you'll see that I am able to successfully connect.
Also, try your hand at adding the patch that solves the problem.

Best,

Paul

From: Harry Sfougaris [mailto:hsfougaris at gmail.com]
Sent: Monday, May 10, 2010 8:41 AM
To: Paul Thurston
Cc: FreeTDS Development Group
Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010

Thank you Paul.
I'm afraid it's not working for me.
I get exactly the same behavior.

Harry

On 10 Μαϊ 2010, at 3:19 μ.μ., Paul Thurston wrote:


Harry:

I found the Windows bug in the FreeTDS Library. This is the same issue I ran into over a year ago.
The problem is that Winsock is not being initialized in FreeTDS v0.82.

I patched the code and have place a good 64 bit build at : http://www.netegrate.com/index_files/download/SqlServer/

By the way, if you'd like to patch the code yourself and do your own build, just do the following:

Source File: net.c

Function: int tds_open_socket(TDSSOCKET * tds, const char *ip_addr, unsigned int port, int timeout)

Add to Line 201:     INITSOCKET();

Best,

Paul


From: Harry Sfougaris [mailto:hsfougaris at gmail.com]
Sent: Sunday, May 09, 2010 3:33 PM
To: Paul Thurston
Cc: FreeTDS Development Group
Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010

Ok thanks.
Just for the record, it's not Parallels.
I booted into bootcamp and got the exact same behavior.


Harry Sfougaris

Sent from my iPhone

On 9 Μαϊ 2010, at 22:29, Paul Thurston <pthurston at netegrate.com<mailto:pthurston at netegrate.com>> wrote:
Harry:

The emulator might be doing something weird to the Windows 64 bit environment; there is really no I can tell for certain.
I'm afraid I can't replicate your environment (all Red Hat Linux and Windows 7 on Intel here), so I’ll end my support effort here.

I'm setting up a local copy of Sql Server 2008 now on my dev box to check out the 64 bit connectivity.
I'll send you note after everything is up and running with 64 bit calls.

Good Luck!

Paul


From: Harry Sfougaris [mailto:hsfougaris at gmail.com]
Sent: Sunday, May 09, 2010 2:29 PM
To: Paul Thurston
Cc: FreeTDS Development Group
Subject: Re: [freetds] 0.83.dev.20100507 and Visual Studio 2010

I coped your exact source (changing my conf file and login, but it still fails.
I have the following in my linker input:
dblib.lib
libTDS.lib
FreeTDS.lib
WS2_32.lib

I trust this code compiles for you fine?
Could it have anything to do that I'm running it through parallels on my MacBook Pro?
I'll try rebooting and testing it now, just in case...

Harry


On 09 Μαϊ 2010, at 9:15 μ.μ., Paul Thurston wrote:





#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<smb://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

Harry Sfougaris





Harry Sfougaris






More information about the FreeTDS mailing list