Click here to Skip to main content
15,906,296 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Resizable font Pin
Cedric Moonen27-Mar-03 3:51
Cedric Moonen27-Mar-03 3:51 
GeneralRe: Resizable font Pin
Iain Clarke, Warrior Programmer27-Mar-03 4:21
Iain Clarke, Warrior Programmer27-Mar-03 4:21 
GeneralRe: Resizable font Pin
Cedric Moonen27-Mar-03 4:24
Cedric Moonen27-Mar-03 4:24 
GeneralAutostart Pin
Jump_Around27-Mar-03 3:08
Jump_Around27-Mar-03 3:08 
GeneralRe: Autostart Pin
Pavel Klocek27-Mar-03 3:16
Pavel Klocek27-Mar-03 3:16 
GeneralRe: Autostart Pin
Pavel Klocek27-Mar-03 3:20
Pavel Klocek27-Mar-03 3:20 
GeneralRe: Autostart Pin
Jump_Around27-Mar-03 4:11
Jump_Around27-Mar-03 4:11 
GeneralExecute a DTS in SQL7 Pin
JPortugal27-Mar-03 3:07
JPortugal27-Mar-03 3:07 
Hi all gurus!
I'm a C# junior progr but dont know anything about C or Visual C ( funny isn't? ).
Well, i must do aplication just to execute a DTS in a Labeled Server. No fancy error message things. Just execute, since this apl will be trigged by a job. I've search the web for some info about this, but only came with http://sqldev.net/dts/ExecutePackage.htm, but i cant override the fatal error C1083: Cannot open type library file: 'C:\MSSQL7\BINN\dtspkg.dll': Error loading type library/DLL. I've register this dll again and checked the rll. But the error continue. I'm using w2k logged as Adm.
<br />
#define STRICT <br />
#define WIN32_LEAN_AND_MEAN <br />
#define INC_OLE2 <br />
#define UNICODE <br />
#define _UNICODE <br />
<br />
#include <windows.h> <br />
#include <stdio.h> <br />
#include <tchar.h><br />
#include <comdef.h> // COM Compiler support for _bstr_t<br />
#include "execpkg.h"<br />
<br />
#import "C:\MSSQL7\BINN\dtspkg.dll" \<br />
no_namespace rename("EOF", "EndOfFile") <br />
<br />
INT _tmain(INT argc, TCHAR* argv[], TCHAR* envp)<br />
{<br />
    HRESULT hr;<br />
    if SUCCEEDED(hr = OleInitialize(NULL) )<br />
    {<br />
try<br />
{<br />
    HRESULT hr;<br />
            _Package2Ptr spPackage;<br />
            if (SUCCEEDED(spPackage.CreateInstance(__uuidof(Package2))))<br />
            {<br />
                try<br />
                {<br />
                    _variant_t v; // VarPersistStgOfHost<br />
                    hr = spPackage->LoadFromSQLServer(<br />
                        _T("(local)"),             // _bstr_t ServerName<br />
                        _T(""),     // _bstr_t ServerUserName<br />
                        _T(""),     // _bstr_t ServerPassword<br />
                        DTSSQLStgFlag_UseTrustedConnection,   <br />
                        _T(""),     // _bstr_t PackagePassword<br />
                        _T(""),     // _bstr_t PackageGuid<br />
                        _T(""),     // _bstr_t PackageVersionGuid<br />
                        _T("Teste"),                  // _bstr_t PackageName<br />
                        &v);     // VARIANT* pVarPersistStgOfHost<br />
                    hr = spPackage->Execute();<br />
                    hr = spPackage->UnInitialize();<br />
                }<br />
                catch(_com_error pCE)<br />
                {<br />
                    spPackage.Release();     // Free the interface<br />
                }<br />
            }<br />
        }<br />
        catch(_com_error pCE)<br />
        {<br />
<br />
        }<br />
<br />
        OleUninitialize();<br />
    }<br />
    return (0);<br />
}<br />


I need some help, please.
Tks all

J.Portugal
GeneralRe: Execute a DTS in SQL7 Pin
Anders Molin27-Mar-03 11:22
professionalAnders Molin27-Mar-03 11:22 
GeneralRe: Execute a DTS in SQL7 Pin
JPortugal27-Mar-03 21:46
JPortugal27-Mar-03 21:46 
GeneralRe: Execute a DTS in SQL7 Pin
JPortugal31-Mar-03 1:40
JPortugal31-Mar-03 1:40 
QuestionHow to get the default browser and its's path ? Pin
vikramj27-Mar-03 1:37
vikramj27-Mar-03 1:37 
AnswerRe: How to get the default browser and its's path ? Pin
Iain Clarke, Warrior Programmer27-Mar-03 4:26
Iain Clarke, Warrior Programmer27-Mar-03 4:26 
AnswerRe: How to get the default browser and its's path ? Pin
valikac27-Mar-03 8:30
valikac27-Mar-03 8:30 
AnswerRe: How to get the default browser and its's path ? Pin
vikramj27-Mar-03 18:06
vikramj27-Mar-03 18:06 
GeneralChoose language Pin
Paolo Vernazza27-Mar-03 1:26
Paolo Vernazza27-Mar-03 1:26 
GeneralRe: Choose language Pin
vikramj27-Mar-03 18:11
vikramj27-Mar-03 18:11 
GeneralRe: Choose language Pin
Paolo Vernazza28-Mar-03 3:57
Paolo Vernazza28-Mar-03 3:57 
GeneralPointer to pointers Pin
jyngem27-Mar-03 1:22
jyngem27-Mar-03 1:22 
GeneralRe: Pointer to pointers Pin
HJo27-Mar-03 4:38
HJo27-Mar-03 4:38 
GeneralRe: Pointer to pointers Pin
Iain Clarke, Warrior Programmer27-Mar-03 4:42
Iain Clarke, Warrior Programmer27-Mar-03 4:42 
GeneralBig prime numbers Pin
Jump_Around27-Mar-03 1:19
Jump_Around27-Mar-03 1:19 
GeneralRe: Big prime numbers Pin
Alastair Taylor27-Mar-03 1:49
Alastair Taylor27-Mar-03 1:49 
GeneralOwnerdraw menus and SetWindowsHookEx Pin
_Theo_27-Mar-03 0:49
_Theo_27-Mar-03 0:49 
GenerallParam member of HDITEM structure Pin
JensB27-Mar-03 0:06
JensB27-Mar-03 0:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.