Calling A DTS Package From VB

Calling An Oracle Package.Procedure Works But Calling A Function In The Package Does Not ?
Hi,

I am trying to call a function in a package in Oracle, from VB. I am using the traditional ADODB with connection, command and parameter objects. The function has 6 input parameters and it returns a string value.

We have no problems reaching the similar Procedure under a package, but when it comes to accessing the function, it gives errors. I got "no descriptor found", after some changes "object stored Procedure does not exist" .

Any suggestions on how differently to access a function within a package as opposed to a procedure ?

Thanks,
Arch

---

Calling An Oracle SP That Is In A Package
Hi,

I have a SP that is in a Package and need to call it from VB.

What I have so far is calling a SP that's not in a package :

OracleSPCall.CommandText = "WS_OLY_Reset"
OracleSPCall.CommandType = adCmdStoredProc
OracleSPCall.Execute

Can someone tell me the syntax for calling a Procedure in a package.

Thanx



Bill Paton
william.paton@ubsw.com
http://www.neptune400.co.uk/

Check out www.deepturtle.ch

---

Trouble Calling Oracle Package Using RDO
The code below is not running for me. It's using RDO to access an Oracle Package. Does anyone know what's wrong with it? I would appreciate it if anyone who knows how to fix this problem contact me at bruce.yang@merrillcorp.com.

Thanks.

Public oConn As rdoConnection
Public rstBoxes As rdoResultset
Public rstBoxes1 As rdoQuery
...

Set oConn = New rdoConnection
With oConn
.Connect = "DSN=DCSRENEW;DATABASE=DCSRENEW;UID=DCSRENEW;PWD=DCSRENEW;"
.CursorDriver = rdUseNone
.LoginTimeout = 5
.EstablishConnection (rdDriverNoPrompt)
End With

................

Dim mySQL As String

mySQL = "{call DCSRENEW.process_bates_num.Get_Bates_number_Range(?,?,{resultset 100,
OUTBATESNUM})}"
Set rstBoxes1 = oConn.CreateQuery("", mySQL)
rstBoxes1(0) = txtDocID.Text
rstBoxes1(1) = txtpackageID.Text

Set rstBoxes = rstBoxes1.OpenResultset(rdOpenForwardOnly, rdConcurReadOnly)


Errorr:
Run time 40002
OUTBATESNUM must be declared..

**note** the out parameter OUTBATESNUM is declared in the store procedure "Get_Bates_number_Range",
and that store procedure has 2 in param & 1 out param.

---

Package & Deployment Hangs At Loading Package Types
Using VB6 on Vista. I haven't used my package and deployment for a while but today I recompiled my application and tried to ceate a new package for deployment. It got as far as "loading package types..." and quit. I reinstalled the program a couple of times without success. I noticed at the top of my 'Add-in Manager' there is an item that says "<MISSING>AFVBAddinConnect" if that makes any difference. Hopefully, someone has a solution or reason why this is occurring. Thanks.

Jim S.



Edited by - jschuchert on 8/17/2008 7:05:58 AM

---

Oracle Package.Procedure Works But Package.Function() Does Not ?
Hi,

I am trying to call a function in a package in Oracle, from VB. I am using the traditional ADODB with connection, command and parameter objects. The function has 6 input parameters and it returns a string value.

We have no problems reaching the similar Procedure under a package, but when it comes to accessing the function, it gives errors. I got "no descriptor found", after some changes "object stored Procedure does not exist" .

Any suggestions on how differently to access a function within a package as opposed to a procedure ?

Thanks,
Arch



Edited by - Archvile on 9/14/2004 3:07:01 PM

---

Package And Deployment Wizard Not Generating Package
Hi,

I am trying to generate a package, for a Visual Basic application I wrote, through the Package and Deployment Wizard utility. PDW seems to work great until it gets to the last step. When I click the "Finish" button, instead of generating the package, with its setup and library files, it bombs out/exits without giving any clue/error message why.

I would appreciate any help you could give me on that.

Thanks,

TM

---

Package &amp; Deployment No Error But Package Not Create
I tried to package my vb program but after i have completed the package and deployment wizard, the wizard just exited without creating the installation package for me. I have check the folder, it only create the setup folder and support folder without files. please advise what could be wrong.

I have tried using the package and deployment for another VB Project without any problem.

---

Package 'cannot Find File' - L:Package\@test.exe
Hi,

I created a package for my software (written in VB6), but when I try to install, it tells me that a file: L:Package\@test.exe cannot be found (L:Package is the location of the package). Test.exe is supposed to be built into the package, but I get this error. Also, when it tries to remove the installed files, it just gets stuck and crashes.

Anyone got any ideas? - a quick reply would be greatly appreciated.

---

How Can I Change The Package Size Of Winsock Package.
I have a satellital connection. That´s requieres one maximun package size, the server send a notification of this to the client, but the client forget this.
I need read this notificartion and change the maximun package size!!


TIA

---

VB Package Using Package And Deployment Wizard
I am trying to create VB Package using Package and Deployment Wizard.
Earlier I have created Package successfully
But recently I have installed .Net in my system. From onwards I am getting
“The exception unknown software exception (0xc06d007e) occurred in the application at location 0x7c59bbf3� error while creating VB application package. This is coming at the end of process.

But still I am getting Package. But while installing this package this is giving following error.
“The operating system is not presently configured to run this application�.

I have created this package on Win 2000 operating system.

Please help me. This very urgent.
Thanks,
Kumar

---

Calling C++ DLL - Invalid Calling Structure
First i got a could not find entry point in DLL error. i fixed that by specifying ordinal numbers in the VB app. now when i run the program i get an invalid calling structure error and then VB Studio crashes. I think the crash is do to the threading and debugging at the same time. i have heard about problems with that. how do i fix the invalid calling structure error.

HEADER ------------------
#ifdef DLL_EXPORTS
#undef EXPORTMODE
#define EXPORTMODE __declspec(dllexport)
#else
#undef EXPORTMODE
#define EXPORTMODE __declspec(dllimport)
#endif

EXPORTMODE bool StartThread(int nTime, int nInterval);
EXPORTMODE void StopThread();

SOURCE---------------------------
#include "stdafx.h"
#include "header.h"

BOOL APIENTRY DllMain(HANDLE hModule, DWORD ul_reason_for_call, LPVOID lpReserved)
{
switch (ul_reason_for_call)
{
case DLL_PROCESS_ATTACH:
case DLL_THREAD_ATTACH:
case DLL_THREAD_DETACH:
case DLL_PROCESS_DETACH:
break;
}

return TRUE;
}

EXPORTMODE bool StartThread(int nTime, int nInterval)
{
return true;
}

EXPORTMODE void StopThread()
{
}

---

Execte DTS Package From VB Doesn't Run &"Execute Package&"
Hey!

I am executing a DTS package from VB. This DTS package has an Execute Package task which executes a child package. Or it should do!! When running from Enterprise Manager the two packages run successfully. When I try to execute them from VB it appears to run successfully, but it is only running the top package.

Any ideas?

---

Install An MSI Package In An MSI Package.
I'm using Microsoft Visual Studio Installer 1.1 which I find easy to use. But unfortunately it's limited. It doesn't have something like installing additional features. And by installing additional features, I mean to say like a prompt for users if MDAC would be installed or something else. I found an article in MSDN which encapsulates the installation of MDAC. Or more to say, run the MDAC_TYP.exe from the MSI package. Now I want to know if there's also a way to run an MSI package included in an MSI package. In other words, run an MSI package (mostly third party) then run my MSI package to install my application. Is this possible?

---

Calling A DLL Function...is This A "calling Convention" Problem?
Hi All, I'm not sure if this has been covered in another thread. I'm trying to call a function in a DLL that was written in C++ and its saying it can't find the entry point, I've got the case and spelling correct.

Heres the C++ example code of how to call it:
LONG DLLFUNC RotorRadioConfigure ( HWND, HANDLE );

and heres my VB code:

public Declare Function RotorRadioConfigure Lib "rr.dll" HWND, HANDLE) as Long



I've also tried using ordinal calls:

public Declare Function RotorRadioConfigure Lib "rr.dll" Alias "#1" (HWND, HANDLE) as Long




But, I don't know which ordinal number to use, I've tried #1 to #8, then VB crashes, there are about 15 functions in the DLL.

On each ordinal call, it just says invalid calling convention.

Any help?

Scott.


---
Freeware VB programs at http://net23uk.freeservers.com

---

Calling A Sub In The Calling Program
Can a sub form call a sub/function in the calling program?

I want to refresh some details in the calling program BEFORE the called program exits.

Thanks

---

Best Way To Package??
Yippee.. I love an opportunity to sound like a newbie.

I am about to distribute a VB app to an office, and I have been using the standard Package and Deployment plugin to do it. However, I feel this setup process leaves a lot to be desired, like unable to place Shortcuts anywhere, and seemingly no other customization options for the installing party. What options are out there and what is considered the "best way to go"? Any help on this will be greatly appreciated! Thanks in advance!

---

Package
I have a project that i've finished. I've build the package. the project have an access file withe a jet ole connection.
I install the package sucessfully, but i can't open the game, and show the next message:
run time erro 2706 ADO could not find the specified provider.

What files i have to include in the project??

---

Why Is The Package So Big?
why when using package and deployment wizard the resulting package files are so big even though the size of the project itself won't exceed 2 mb?

---

DTS Package From VB
Dim objPkge As New DTS.Package
Dim strPkge As String


strPkge = "a_dts_package"
With objPkge
.LoadFromSQLServer "aserver", , , , , , , strPkge
.Execute
End With

This gives me the error 'my login name' is not associated with a trusted connection.

The Application is already connected to an SQL Db there is a global object available, and there has already been activity on the Db at this point. Is there any way to tell the dts package to use the existing connection rather than try to create a new one. I am using NT authentication.

Any advice would be greatly appreciated.

---

Package With DLL
Hi.

Is there a trick or something special to do to create good dependency with a DLL added to a project ? I'm using an external DLL and it work really fine on my computer with VB. The problem is to make it work on other computer.

I've tried in the packaging to make it shared or not, registered or not. To save it into the installation directory or in the Windows Systems directory. In all case, the function that use the DLL doesn't work on other computers.

Does the fact that the DLL is written in C affect my VB project ?

The "Depends" tools that come with VB indicate dependency about the dll with Kernel32.dll, user32.dll, crtdll.dll, ntdll.dll and gdi32.dll. Should I add those file into the packaging ? I've tried it too but without success...



Thanks

---

Package Dll
Hi Guys

Ok at the moment in my vb project im using .bas files but these functions are really handy so i decided i'd try and create a .dll file.
The thing is if i package this project using the "Package and Development Wizard" will it register my .dll on the end user's computer. And if it doesnt is there any easy way of doing it besides going around to each individual computer and typing
"regsvr32 c:windowssystemfilename.dll"

Or should i just stick to my .bas file and include it in each project.

thanx
shane

---

Package
If i make with package & dep wizzard a install for my database after installing on a other dir as c:program filesooksdb it cannot find the database how can i fix it that
vb automatic finds my db.

---

Package
I tried to reference "Microsoft VBScript Regular Expressions" which is located in "c:winntsystem32vbscript.dll2" and my code work perfectly with this reference. However, when I package, it complain that the file "2" is missing. Do you have any idea with this?

---

Package
how do you package up an application to install
on another computer. In particular how do you
resister .ocx files etc
many thanks....

---

Dts Package
hi people, i have a DTS PACKAGE wich several tasks:

1) Creates a new table (a temporary table)
2) Exports data from a Text File to the new Table created before.
3) Proccess the info stored in the temporary table to do some inserts,
updates and deletes in other tables.
4) Deletes temporary table.

It works great but any time i want to execute it in a different database (same server!)
i have to change some properties (manual):
* Database name in the connection Object.
* The complete table name ([databasename].[dbo].[tablename]) in the destination property in the object 'Transform Data task' (it means where the data from file must be exported to..)

i wanted to know how to set a global variable for DATABASENAME at DTS package in order to not to change that 2 properties manually.

Sorry, my english!
Tanks in advance!

---

Dts Package
A few questions...
I have a DTS Package:
1) how to execute it from query analyzer?
2) inside package i execute a stored procedure...how could i send parameters to that Stored procedure from outside package?

Thanks in advance!
Bye

---

Run A DTS Package???
Does anyone know how to run a created SQL DTS package from VB?

Thanx in advance.

---

Sql Dts Package
Hi people! I have a simple question.... I have a DTS Package and i need to execute it from a stored procedure but i dont know how!
Any help?
Thanks in advance!

---

Package
hi all, i have created package for my vb project in windows 98. when i try to install that package in another system which does not have Visual Studio. i am encountering en error that "ActiveX component can't create object" error is coming.. plz help me to resolve it

---

What Is A CRM Package?
read topic

---

Using DTS Package In VB
hi guys. its been long time away from forum

i have a vb app which created database option . i was using


Code:
ShellandWait "osql -S "
..................


and it works fine but if any error occurs i cannot trap it or handle it
i was looking for alternative.

i am using DTSpackage i saved the package as vbmodule and using it. i need to use the event.

so my code code goes like this...



Code:

Option Explicit
Public WithEvents goPackage As DTS.Package

Private Sub goPackage_OnError(ByVal EventSource As String, _
ByVal ErrorCode As Long, ByVal Source As String, _
ByVal Description As String, ByVal HelpFile As String, _
ByVal HelpContext As Long, _
ByVal IDofInterfaceWithError As String, pbCancel As Boolean)
Dim sMsg As String

sMsg = "EventSource: " & EventSource & vbCrLf & _
"ErrorCode: " & (ErrorCode) & vbCrLf & _
"Source: " & Source & vbCrLf & _
"Description: " & Description & vbCrLf & _
"HelpFile: " & HelpFile & vbCrLf & _
"IDofIFWErr: " & IDofInterfaceWithError
MsgBox sMsg, vbExclamation, "OnError"


End Sub

Private Sub goPackage_OnFinish(ByVal EventSource As String)
MsgBox EventSource, vbInformation, "OnFinish"

End Sub

Private Sub goPackage_OnProgress(ByVal EventSource As String, _
ByVal ProgressDescription As String, _
ByVal PercentComplete As Long, _
ByVal ProgressCountLow As Long, _
ByVal ProgressCountHigh As Long)
Dim sMsg As String

sMsg = "EventSource: " & EventSource & vbCrLf & _
"ProgressDescr: " & ProgressDescription & vbCrLf & _
"PercentComplete: " & (PercentComplete) & vbCrLf & _
"ProgressCountLow: " & (ProgressCountLow) & vbCrLf & _
"ProgressCountHigh: " & (ProgressCountHigh)
MsgBox sMsg, vbExclamation, "OnProgress"
End Sub


Private Sub Command1_Click()
MainSub "khalik"
goPackage.Execute
goPackage.Uninitialize
End Sub



and in module... i am assinging the dts object to form public variable

Code:
Set Form1.goPackage = goPackage



seems there some problem the app get hang it happens all the time i have tried several way but havent found a way out...


in simple terms i need to create database for my app with table and all that stuff and shd be able to handle the errors if any...

shd be a different way out

---

To Package...
My client vb application uses crystal reports. I store ALL the reports in a seperate folder ironically called "Reports".

My question is..when I package my application do I just add the complete folder of "Reports"? Meaning when the application is installed on the end users pc..in some file say:

C:ProgramFilesMyApp..

Then will the reports be in:

C:ProgramFilesMyAppReports??


Thanks

Jon

---

Package ....?
i have seen several gurus saying P&D is good.. works well.. i see several threads posting problems with it... mostly i have used P&D and very rarelly i use to get some problem..

but this time my boss what me to work on wise... i am no wise enough to work on it.... did any one worked on it and how diff is it with P&D and can i get some sample stuff to start fast...

things have to be done fast on fly....

---

DTS Package...
hi

working on telecom project i need to load data from txt file to database and process.. so i have design a DTSpackage to do that work fine on my pc when i create a setup package and install on user side the Activex object cannot be created.

any Idea what all file need to be included

---

Package
can anyone help me?
how do i package my software into an installer kind of thingy? i know Visual Studio has a tool but my program incorporates a few standalone EXEs . can i include those as part of my package too? please help

---

Package
u can use package & development wizard

just give it the name of ur project

---

COM+ Package
Hi all,
Any one knows which the most commonly used Authentication level and Impersonation level in COM+ Package

---

Package
the problem is i need to create a new package, uninstall the existing one at clients m/c., and reinstall it each and everytime at client's machines even for a small change in the application. how can we prevent this? is there any way to do like developer 2000, making executables for each form? will it be advisable?

---

CD Package
Is there a way to install your program on a CD so the customer does not have to install it they just run it from the CD?

---

VB Package
I have created a VB application. And used VB packaing tool to Create a setup for that program. All this was done on VB 6 on win 2000 Professional.
When I run my set up on a clean PC ( win 2000 installed and no VB installed at all), it gives me an error 'some system files are old. Setup cannot continue'
Can any one tell me why this happens and whats the workaround for that ?

---

Package
I'm trying to package my program but I don't know what dependancy I need to include.

inet1
timer
progressbar
commondialog
frame
imagebox
menu
commandbutton
combo1
sstab

---

How Do I Package The Exe?
I have never deployed a project into production before. It made it out of QA, but the dude that does that has Visual Studio on his machine. How do I package my exe so that it works on boxes that are running NT 4.0 workstation but don't have VB or Visual Studio on them? I know tha this is a real basic question and any help is really appreciated. Thanks.

---

Package
When I package my project into a single cab, I get four things in the folder. A folder called support, a zip file, a setup, and a word doc. I want to e-mail my program to someone, but I thought I was supposed to sent the zip file. I can unzip it, but when I run setup, I get "Invalid command line parameters" for an error. I can run the other setup that is not in the zip. How am I supposed to do this? What am I supposed to send, the setup and the zip. I thought I sent just the zip before and it worked, but not now. Any know what I am supposed to do?

---

Package
Hi All,
How to include an another setup file while creating a package in VB 6.0
Rgds,
Kalpana.

---

DTS Package
Hello all

What is the best way to call a DTS Package saved in the SQL Server (SQL v.
7.0 SP 4) from a VB (VB v. 6.0 SP 5) Application.

---

DLL 4 CD Key For Package
Hi there,

I am using Installshield Express 5.0 to make a package(Set up creation ).I want to provide a CD key...
for that ,in the 'Installation Designer' tab, under 'customer information' i have the following options-
serial number template
serial number validation
validation function
succes return value

I want the Cd key to be something as : AD34-AY23-XX26..
but have no idea as to how to create a DLL for that and to use it for this purpose...

This is very urgent for me...and i shall be highly indebted . if u can send across any code snippet for help..
any suggestion in this regard will be helpful...

thanking you all in anticipation

Regards

---

Package
<html><div style='background-color:'><DIV class=RTE>
<P>Hi,</P>
<P>I am trying to create a setup package for my application, but I get a message that tells me that a certain dll file (msstdfmt I think) has problems with it's dependencies. Still I can continue but in the end I cannot run the setup because of the same file. What do they mean by dependencies?Should I find this dll somewhere, is it broken?</P>
<P>Thanks, Roxy.</P>
<P><BR> </P></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMBENUS/2734??PSG575">Exp ress yourself instantly with MSN Messenger! Download today - it's FREE!</a> </html>

---

DTS Package
Hi,

Can someone tell me if (and how) can I execute a DTS from a store procedure or, if this is not possible, how can I call (execute) a DTS from Visual Basic.

Other question... Is it possible, from Visual Basic to CREATE a DTS package in SQL Server?

Thank you,

Sergio Oliveira

---

DTS Package From VB
Hi,

I've created a VB package, and trying to run it from a VB project.  Works fine on my PC with SQL Enterprise Manager installed, but not on another developers PC.

I've looked on t'internet, and TEK-TIPs and tried registering DLLs.

I've tried both ways in the code - creating a DTS Object

e.g. Set oPkg = CreateObject("DTS.Package")

and also executing a stored procedure which has the command to run a DTS Pckage

i.e Select @CommandLineVarChar = "DTSRun.exe /S XENAAS_P800_0010 /E /N  RMBWST_FIN_COPY_TEST  /R"

But neither work, and it doesnt give an error - even stepping through the source code doesnt help.

Any suggestions please as its driving me MAD!!!

Thanks in advance
Rob

---