Re: [opendbx] Compiling OpenDBX with Microsoft SQL Server in windows
Brought to you by:
nose
|
From: OpenDBX d. l. <lib...@li...> - 2008-08-23 22:10:36
|
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 >> >> > |