Re: [opendbx] Compiling OpenDBX with Microsoft SQL Server in windows

[OpenDBX d. l. <lib...@li...>]

Norbert: I think we are in problems ahhaha. I have been looking in internet
and I found some interesting tips:

It seems firsts SQL server versions (before SQL Server 2005) support and use
dblib as client library. I saw mssqlbackend.h and I realize that you use
that library. The problem is that Microsoft doesn't support dblib since SQL
Server any more. I mean, DBLib is still supported but It is and has been
deprecated and the libraries are no longer
shipped and must be acquired from an alternative source.

In addition, SQL Server 2005 support for client applications using
DB-Library is limited to Microsoft SQL Server 7.0
features. A future version of the SQL Server Database Engine will drop
support for connections from DB-Library. It is recommended not not use
DB-Library or Embedded SQL to develop new applications.

SQL server 2005 and 2008 include support for OLE DB and ODBC accessed
through a single .dll called: SQLNCLI.dll, this file and its support files
are redistributable.

Do you know something about this? I guess it a lot of work to create a new
mssql backend that uses OLE DB.

I will try to download from somewhere dblib and try it with sql server 2005.

many thanks,

Mariano


On Fri, Aug 22, 2008 at 4:28 PM, Mariano Martinez Peck <
mar...@gm...> wrote:

> On Fri, Aug 22, 2008 at 3:39 AM, OpenDBX devel list <
> lib...@li...> wrote:
>
>> Hi Mariano
>>
>> > configure:27178: checking sybfront.h usability
>> > configure:27195: gcc -std=gnu99 -c -g -O2  conftest.c >&5
>> > conftest.c:80:22: sybfront.h: No such file or directory
>> >
>> > Is this correct? I mean, sybfront.h is for sql server or sybase ? Do you
>> > know where it should be that file ? Do I need to install something extra
>> ?
>> > I have installed this:
>> >
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=4c6ba9fd-319a-4887
>> >-bc75-3b02b5e48a40&DisplayLang=en
>>
>> Does this package contain the SDK for development?
>>
>
> Now. You were right. Then I installed the SDK. I can see sqlncli.h,
> sqlncli.lib and all the things I need. I also send to ./configure the
> CPPFLAGS and LDFLAGAS but I still have the same error.
>
> Obviously, I don't have sybfront.h. But I have quetions:
>
> 1 - Is that message right ? Why not conftest.c:80:22: sqlncli.h.h: No such
> file or directory ?
>
> 2 - How does openDBX know the name of the .h and .lib of each backend ?
> which file ? I mean, I want to be sure which file openDBX is trying to find
> for each backend.
>
> 3 - If SQL Server changes that file don't you have to change openDBX ?
>
> many thanks,
>
> Mariano
>
>
>>
>> According to this URL
>> http://msdn.microsoft.com/en-us/library/ms131291(SQL.90).aspx<http://msdn.microsoft.com/en-us/library/ms131291%28SQL.90%29.aspx>
>> Microsoft could have renamed the file to "sqlncli.h". Is it available in
>> one
>> of the directories installed by the package?
>>
>>
>> Norbert
>> --
>> OpenPGP public key
>> http://www.linuxnetworks.de/norbert.pubkey.asc
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the
>> world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> libopendbx-devel mailing list
>> lib...@li...
>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>
>>
>