Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.
I try to add Microsoft Rich Textbox Control 6.0 (SP6) control via Project - Components. The control is present in the list of controls. When I tick it and click OK/Apply, I get Object library not registered error: Environment is Windows 7 SP1 x64 with latest updates, VB6 SP6 + KB957924. Richtx32.Ocx is present in C: Windows. All tasks in the package are reviewed for appropriate settings during validation, and all objects in the package are reviewed, including the package, containers, and other components in the package. If there are no problems encountered in the validation phase that would cause the package to fail, the package object proceeds to call the Execute. May 15, 2006 macro and the macro will call DTS. Question: Since I am a developer with SQL Server loaded as well as Microsoft Excel, I only had to select References and check the 'Microsoft DTSPackage Object Library'. When I deploy this spreadsheet to the clients, they won't have SQL Server loaded. They might have just the Client connectivity. I am developing a Visual Basic 6.0 application on a client PC running Windows 2000 SP-4. The SQL Server 2000 database resides on a server running Windows Server 2003 Enterprise Edition SP-1. My VB program will not compile because there is no reference to the “Microsoft DTS Package Object Library” – I think.
Microsoft Vb6 Runtime
All Forums
Development Tools
ASP.NET
VB.Net Running a DTS Package |
|
Vb6 Missing Microsoft Dts Package Object Library Dll
Vb6 Missing Microsoft Dts Package Object Library Free
| Author | Topic | smithygreg
Starting Member
37 Posts | | Posted - 2004-10-29 : 14:17:01 | Hi everyone...I am new to both SQL Server AND VB.net...
Here's my problem.
I created a DTS package basically to just import a CSV file into a table in my database. I want to be able to run this package from my VB.net front end on a client machine. I used some of the sample code that comes with SQL Server and I kept getting errors saying the different DTS Types that I was trying to Declare were not defined.
For Example
Public goPackageOld As New DTS.Package
Public goPackage As DTS.Package2
Would give me 'Type DTS.Package is not defined'
and 'Type DTS.Package2 is not defined'
Well, like I said, I am new at this..I have experience with VBA and VB6, but I am a bit lost here. Are there references I need to load or some include statements missing?
Any help on this problem would be appreciated...
Also, Does anyone know of a good resource for information? I mean, besides these forums.
THANKS!!!
Greg
|
| smithygreg
Starting Member
37 Posts | | Posted - 2004-10-29 : 19:51:03 | Well, I figured it out...Thanks anyway...
I am still interested in any beginner material, books you could recommend
|
| brendalisalowe
Constraint Violating Yak Guru
269 Posts | | Posted - 2004-11-16 : 12:50:37 | You really figured it out? I have been trying forever. Want to help me out a little bit? This is what I have posted, just to give you an idea of what I am doing.
http://www.vbforums.com/showthread.php?s=&threadid=308100&perpage=40&pagenumber=1
Thanks for any help!
Brenda
If it weren't for you guys, where would I be?
|
| AlDragon
Starting Member
12 Posts | | Posted - 2004-12-06 : 23:35:35 | Add reference Microsoft DTSPackage Object Library under the COM tab.
This can also be done in VB6
This will get you started:
Dim opkg As DTS.PackageClass
opkg = New DTS.PackageClass()
'This call will load the dts package from the sql server
opkg.LoadFromSQLServer(Add paramter variables as needed)
Al Franzini |
|
|
|
Subscribe to SQLTeam.com
Vb6 Object Library Not Registered
Resources