asked on

SQL-DMO link error !

Hi have a problem implementing SQL-DMO in my application.
The linker don't find 2 external symbols : CLSID_SQLDMOServer and IID_ISQLDMOServer.

What is the name of the type library (or DLL) that I must include to my project ?

I am including these 2 files sqldmoid.h and sqldmo.h

The 2 symbols are defined into sqldmo.h

My project is a dialog based application using MFC.

mike_marquet

ASKER

Here's the part that failed :

LPSQLDMOSERVER pSQLServer = NULL;

HRESULT hResult = CoInitialize(NULL);

hResult = CoCreateInstance(CLSID_SQLDMOServer, NULL, CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (LPVOID)*pSQLServer);

mikeblas

Only ten points?

Well, anyway: you need the IDs header file.

#include <sqldmoid.h>
#include <sqldmo.h>

It's not shipped with VC++; it comes when you install the "development tools" during a client install of SQL.

..B ekiM

mike_marquet

ASKER

I have it and include them. The problem doesn't comes from the compiler but from the link.

ASKER CERTIFIED SOLUTION

mikeblas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mike_marquet

ASKER

No it works. But the problem is that when I include this part :

#include <initguid.h>
#include <sqldmoid.h>
#include <sqldmo.h>

in the header, the link don't works. But when I insert it in the cpp file, then it works !!!!!!!!!

I don't know why !

I must include it in the header files, because I have some declaration there.

I have also try to include them in the stdafx.h file but the problem is the same.

It works only when I include them in the same file where the CoCreateInstance is used.

mikeblas

mike_marquet> in the header, the link don't works.

In what header?

What libraries are you specifying to the linker?

What error do you get?

mike_marquet> It works only when I include them in the same file
mike_marquet> where the CoCreateInstance is used.

That doesn't make sense. There must be something that you're not telling me. I'd offer to look at your project, but you've only offered ten points.

.B ekiM

mike_marquet

ASKER

- My project is a MFC Dialog based application.
- The header is the dialog once (MyDlg.h).
- The libraries specified are : odbc32.lib version.lib Ws2_32.lib odbccp32.lib
- The error is :
MyDlg.obj : error LNK2001: unresolved external symbol _CLSID_SQLDMOServer
MyDlg.obj : error LNK2001: unresolved external symbol _IID_IWSQLDMOServer

Netminder