LoadFromSQLServer - 'Specified SQL server not found'

[Ollie Riches]

I am trying to start a remote DTS package from code and I am getting the
following error:

Description='[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found.'
Error=-2147467259'
Source='Microsoft OLE DB Provider for SQL Server'

When I run the code from the local machine it works perfectly fine. Anyone
got any ideas?

The code (C# .Net) is shown below:

object obj = new object();
int intCookie;
cpPoint.Advise(PES, out intCookie);
pkg.LoadFromSQLServer(DtsSettingsSection.Server,
DtsSettingsSection.Username,
DtsSettingsSection.Password,

DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
"",
"",
"",
DtsSettingsSection.Package,
ref obj);

// The real work is done here...
pkg.Execute();
pkg.UnInitialize();


--
Cheers

Ollie Riches
http://www.phoneanalyser.net

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

 

[Guest]

Hi

The message is probably correct! The server is not reachable from the where
you are running it from. Check that the network configuration allows access,
e.g if a firewall is blocking the port you are using and that the host is
"visable" from the server, and that you have the appropriate client libraries
configured.

John