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?
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed