Execute DTS from VB app on Win 95

[plsh]

Hi there,

I have found numerous articles about how to execute a DTS that sits on a SQL Server 2000 server. The code I have working fine on my development box. Problem is when I deploy it and try and run the exe on a Windows 95 box it crashes with error 429 active-x can't create object, more or less along those lines. I found a listing of dll's and rll's that have been recommended to be included in the package but this still doesn't help. Can it have something to do with the operating system, like I said it is a Windows 95 box but developed on a Windows 2000 box?

Any help would be great, I am going mad.
Thanks

 

[tb]

Try installing DCOM98.
(Don't know if it will work for win 95... )

You can also kick off a DTS through a stored procedure.



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[plsh]

Hi tb,

I tried your suggestion but unfortunately it didn't work. Anyone got any other ideas? The stored procedure section, to be honest I would prefer just to access the DTS directly from VB, and not create extra work. May have to do this in the end, but for now I would like to try and get the DTS running directly from VB.

Cheers

 

[tb]

Do you have all the files listed in the link below and installed to the specified directory?

http://www.sqldts.com/?225

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[tb]

Another thought ...SQL client tools setup

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[plsh]

Hi tb,

I have loaded all the required dll's rll's and so on according the the site. I have tried to load the SQL Client on the box but it won't give me the option. Is there a way to load the client tools without going through the CD menu that pops up? Like I said before I can do it on my development box, win 2000, but not on the required box, win 95.

 

[tb]

Sorry, have asked around and it seems that you can only load the client tools via the cd..

Anybody else have any ideas?

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[plsh]

Hi tb,

Figured out how to load SQL Client using the CD but in unattended form, it let me do that.

This is how:
I found out. In the root of the CD there are scripts that can be run. The script to run the SQL Server Client installation is sqlcli.bat. Open it and follow the changes that need to be made, it installs the client in unattended form.

Unfortunately that didn't help my cause as executing the DTS from VB still does not work. Any other ideas by any chance?

Cheers

 

[tb]

We had a similar problem about 6 months ago, in addition to that we had SQL DMO in the same project ... but all of the above solved the problem (which in the end they decided to install and run from the server - go figure)

Is there no chance that you could upgrade the 95 PC to 2000?

Then alas, my only suggestion is that you kick off a stored procedure to do the trick ...

Cheers


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[plsh]

Hi tb,

I don't know what is wrong with the freeking thing. Unfortunately network guys aren't keen on upgrading the PC for some stupid reason. Anyway, can you post an example of how to execute a DTS from a stored procedure.

One thing extra though. I am using DTS global variables, can I pass a variable to the DTS from the stored procedure and how do I pass the variable from the VB app to the stored procedure?

Thanks

 

[tb]

Hi there,

You can just do a google search - you'll find plenty exapmles...

I found a few ...

http://www.sqldts.com

http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

http://www.allisonmitchell.com/Articles/ImportAllFiles.htm

http://www.databasejournal.com/features/mssql/article.php/10894_1459181_2

Good luck,


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[Glasgow]

I may be on the wrong track here - but how is the DTS package stored? Is it within the database itself? Would it help if you stored it as a .bas instead then cut/pasted the generated code into your VB project?

 

[plsh]

Hi Glasgow,
The DTS is stored on the server. It does quite a few things, import from Excel, manipulation, export to Excel, and some other stuff and tyhen eventually into the database. Is it possible to change it to a .bas and still do this? How?

 

[Glasgow]

If you open the package in Enterprise Manager, then do Save As and select 'Location' as Visual Basic, it'll shove it all in a .bas you designate. I assume that there are no limits to functionality - i.e. it will work whichever format you save it in. I may be wrong but worth a try perhaps.

 

[plsh]

Hi Glasgow,
Made the .bas and it works well on my development box but again not on the Win95 box. Still comes up with error 429 Active X component can't create object.

 

[Glasgow]

Too bad. This is annoying - I am desparately trying to remember why we made a conscious decision NOT to support Windows 95 with our SQL Server app. We start with 98. Am I right in thinking that this is a Windows 95 client only - i.e. the database resides elsewhere?

Did you pursue the DCOM suggestion? There is a DCOM95 for Windows 95 I believe.

 

[plsh]

Yup, the database sits on out Win 2000 server and the client that is accessing the db is a Win95 box. I have installed DCOM as well as the latest MDAC.

 

[Glasgow]

I've remembered - I was thinking of the SQL Server 2000 Desktop Engine which isn't supported under Windows 95 - i.e. it cannot host the database which is not your problem.

Sorry, I'm not sure I can help you with this much further.

 

[tb]

Plsh,

Found this thread ... might shed some more light on kicking off the DTS from a stored proc

thread183-588474



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[plsh]

Hi there,

Thank you to all of you for your help. Ended up upgrading the PC to Win XP, loaded client tools and all works well now.

Thanks again.