VB6 sp5 DTS-Script to active X-Script

Alexander Rank

unread,

Nov 14, 2001, 10:20:10 AM11/14/01

to

Hallo,

i developed a program which read from a dbase-file write to a sqlserver7.
And i saved a dts-packages to an activeX-script, and i create a setup-file
in VB, so when im install this setup and will run the program the error 429
occurs. I know there is any missing registration, but which one. This
dts-activeX-Script was create in SQL Server 2000 and should be run on SQL
Server 7 , can somebody give me a solution

thx alex

--
Mit freundlichen Grüssen

Alexander Rank

Computer Raithel GmbH
Klaus Conrad Str. 22
91533 Wernberg - Köblitz

Tel. 09604 - 92250
Fax. 09604 - 91252
Email: Alexand...@komMA-Software.com
Internet: www.komma-software.com

Euan Garden[MS]

unread,

Nov 15, 2001, 2:08:51 AM11/15/01

to

Are you trying to redist DTS? If so then you need to follow the instructions
in redist.txt on the cd. Have you checked that the package generated from
SQL2000 runs on SQL7? There are different COM interfaces used so they may
not work on 7.0. Also DTS generates VB code not VB Script, you need to edit
the code to get it to work.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

Hello, I'm the humble disclaimer. Nobody really likes me. I'm used to being
ignored and maligned - I still get the job done. If you cared enough to read
me, you'd learn that this posting is provided "AS IS" with no warranties,
and confers no rights.

"Alexander Rank" <alexa...@raithel.de> wrote in message
news:O0ul3CSbBHA.1488@tkmsftngp02...

Alexander Rank

unread,

Nov 15, 2001, 4:58:12 AM11/15/01

to

Hallo Euan,

I saved a DTS Package into a VB module1.bas and edit the module after insert
in my program. It will work if there is a sqlserver local on the machine.
And it won't work there is no sqlserver on the machine. does it comes that
there are needed a lot of DLL by passing on. Because it occurs the error
'429' can't create object.

"Euan Garden[MS]" <euang....@microsoft.com> schrieb im Newsbeitrag
news:uO3n3RabBHA.1984@tkmsftngp03...

Euan Garden[MS]

unread,

Nov 15, 2001, 3:22:54 PM11/15/01

to

Read my post, you have to follow the instructions in the redist.txt that
tell you how redist DTS.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

Hello, I'm the humble disclaimer. Nobody really likes me. I'm used to being
ignored and maligned - I still get the job done. If you cared enough to read
me, you'd learn that this posting is provided "AS IS" with no warranties,
and confers no rights.

"Alexander Rank" <alexa...@raithel.de> wrote in message

news:#8XGlzbbBHA.1472@tkmsftngp05...