Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Using VB and DTS

Posted on 2009-04-08
8
Medium Priority
?
178 Views
Last Modified: 2013-11-30
Hi
I have a vb application working with DTS.  All works fine when I have SQL installed on a local PC but when I execute the application from a machine that does not have SQL installed it does not load the data and trows a run time error:
Run Time Error '52,
Bad File name or Number

I used VBs package and deployment wizard to set up the application to ensure I had all the dlls.  I reregisterd the dtspkg.dll file but no joy.

Is there something else we need in order to run this?

Any help would be great

Thanks
0
Comment
Question by:ITHELPME
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 8

Accepted Solution

by:
Haris V earned 750 total points
ID: 24096833
0
 

Author Comment

by:ITHELPME
ID: 24097779
Thanks for your help, None of the sites suggested had anything regarding running it from an in-house application as opposed to a vb application

Is there anyting I need to install on the users pc in order to run dts
0
 
LVL 30

Assisted Solution

by:nmcdermaid
nmcdermaid earned 750 total points
ID: 24103107
What do you mean by 'in-house' vs 'vb'? in-house means it was developed in house and vb is just a language.
There is also this page:
http://www.sqldts.com/225.aspx
 
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:ITHELPME
ID: 24105222
It is an application installed witihin the organanisation and vb is the programming language that is used.

When I register the dlls on the machines it gives me an error indicating that they may be corrupt, is there a plcae where I can download the correct dlls and more uptodate onces.

We use Win2k Professional

0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24115012
From a licencing standpoint, you can't just go and register DLL's, you have to buy a licence and install the whole thing.
You would need to register them in the right order (or put them in the same folder as your executable), and you would also need to ensure they suit your OS (x86 or x64)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24124197
>>
Run Time Error '52,
Bad File name or Number
<<
You do realize this error has nothing whatsoever to do with the DTS dll's?  The error is simply telling you that the workstation executing the DTS package does not have access to the file.  So even if we were to clarify that you are allowed to distribute the DTS dll's and how to do it, it would not help you one iota with our original problem.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24124205
And this:
our original problem.

Of course, should have read:
your original problem.
0
 

Author Closing Comment

by:ITHELPME
ID: 31570376
It was the registering of the DLLs

I did not only get run time error this only happend once, the websites were helpful
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question