Les problèmes de compilation sont solubles sous deux modifications: on est passé par des pointeurs dans les déclarations
namespace SpecificationChecker
{
using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;
using namespace System::IO;
ref class CInterbaseManagerM
{
private:
static SQLHANDLE* sqlenvhandle;
static SQLHANDLE* sqlconnectionhandle;
static SQLHANDLE* sqlstatementhandle;
static SQLRETURN retcode;
public:
CInterbaseManagerM::CInterbaseManagerM();
CInterbaseManagerM::~CInterbaseManagerM();
static void CInterbaseManagerM::edit( char* final_err_buff);
static erc CInterbaseManagerM::ConnectServer(std::wstring wsUserName, std::wstring wsPassword, std::wstring wsHost);
static List<ElementSemanticM^>^ CInterbaseManagerM::ExecuteSelectRequestAndReadElement(std::wstring wsRequest, unsigned long* dwNbResultFound);
static List<ElementLinksM^>^ CInterbaseManagerM::ExecuteSelectAndLinkRequest( std::wstring wsRequest, ElementSemanticM^ pEnreg, unsigned long &dwNbResultFound);
static erc CInterbaseManagerM::GetWideString(short shIndexField, std::wstring & wsStringValue);
static List<ElementWork^>^ CInterbaseManagerM::ExecuteSelectRequestAndReadWork(std::wstring wsRequest, unsigned long* dwNbResultFound);
};
};
et on a changer quelques types dans le code
if( ErrorCode == INIT_NO_ERROR || ErrorCode == 1)
{
if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, sqlenvhandle))
;
if(SQL_SUCCESS!=SQLSetEnvAttr(sqlenvhandle,SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0))
;
if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_DBC, sqlenvhandle, sqlconnectionhandle))
;
SQLWCHAR retconstring[1024];
switch(SQLDriverConnect (sqlconnectionhandle, NULL, (SQLWCHAR*)L"DRIVER={SQL Server};SERVER=localhost, 1433;DATABASE=COHERENCE;UID=sa;PWD=Admin-123;", SQL_NTS, retconstring, 1024, NULL,SQL_DRIVER_NOPROMPT))
{
case SQL_SUCCESS_WITH_INFO:
show_error(SQL_HANDLE_DBC, (const SQLHANDLE*)sqlconnectionhandle);
break;
case SQL_INVALID_HANDLE:
case SQL_ERROR:
show_error(SQL_HANDLE_DBC, (const SQLHANDLE*)sqlconnectionhandle);
retcode = -1;
break;
default:
break;
}
if(retcode == -1)
;
if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_STMT, sqlconnectionhandle, sqlstatementhandle))
;
}
moyennant quoi le code compile
Mais il reste une difficulté au link:
1>InterbaseManagerM.obj : error LNK2019: symbole externe non résolu "extern "C" short __stdcall SQLGetDiagRecW(short,void *,short,wchar_t *,long *,wchar_t *,short,short *)" (?SQLGetDiagRecW@@$$J232YGFFPAXFPA_WPAJ1FPAF@Z) référencé dans la fonction "void __cdecl SpecificationChecker::show_error(unsigned int,void * const *)" (?show_error@SpecificationChecker@@$$FYAXIPBQAX@Z)
1>InterbaseManagerM.obj : error LNK2019: symbole externe non résolu "extern "C" short __stdcall SQLDriverConnectW(void *,struct HWND__ *,wchar_t *,short,wchar_t *,short,short *,unsigned short)" (?SQLDriverConnectW@@$$J232YGFPAXPAUHWND__@@PA_WF2FPAFG@Z) référencé dans la fonction "public: static unsigned __int64 __clrcall SpecificationChecker::CInterbaseManagerM::ConnectServer(class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >)" (?ConnectServer@CInterbaseManagerM@SpecificationChecker@@$$FSM_KV?$basic_string@_WU?$char_traits@_W@std@@V?$allocator@_W@2@@std@@00@Z)
1>InterbaseManagerM.obj : error LNK2019: symbole externe non résolu "extern "C" short __stdcall SQLSetEnvAttr(void *,long,void *,long)" (?SQLSetEnvAttr@@$$J216YGFPAXJ0J@Z) référencé dans la fonction "public: static unsigned __int64 __clrcall SpecificationChecker::CInterbaseManagerM::ConnectServer(class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >)" (?ConnectServer@CInterbaseManagerM@SpecificationChecker@@$$FSM_KV?$basic_string@_WU?$char_traits@_W@std@@V?$allocator@_W@2@@std@@00@Z)
1>InterbaseManagerM.obj : error LNK2019: symbole externe non résolu "extern "C" short __stdcall SQLAllocHandle(short,void *,void * *)" (?SQLAllocHandle@@$$J212YGFFPAXPAPAX@Z) référencé dans la fonction "public: static unsigned __int64 __clrcall SpecificationChecker::CInterbaseManagerM::ConnectServer(class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >,class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> >)" (?ConnectServer@CInterbaseManagerM@SpecificationChecker@@$$FSM_KV?$basic_string@_WU?$char_traits@_W@std@@V?$allocator@_W@2@@std@@00@Z)
il semble qu'il y ait un assembly qui manque: lequel. Je suppose microsoft.sqlserver.types, mais je ne le trouve pas.
If not, you can locate the assembly manually - it's located in /Program Files/Microsoft SQL Server/100/SDK/Assemblies/Microsoft.SqlServer.Types.dll
Mais cet include ne suffit pas? quel est la dll qui implémente les symboles non résolus? J'ai essayé tous celles qui étaient dans le SDK sans succès.
Jean Noël Martin
