Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 8th, 2006, 04:08 PM
Registered User
Join Date: Mar 2006
Location: Cincinnati, OH, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default LoadFromSqlServer - Can't establish connection

This may be a stupid question, but do you need to have the SSIS service running in order to use the LoadFromSqlServer method? I have SQLExpress installed on my machine and am trying to code an application to load a package, modify some parameters, then execute it. I don't have the SSIS service on my machine as it does not come with the SQLExpress version of the product. However, I would expect a different message if that was the problem. I have even tried changing the server name in my call to a known server with the service and get the same error. It seems like I have a connection issue rather than a service issue but I don't know how to debug it.

The message I receive is:
method has encountered OLE DB error code 0x80004005(Client unable to establish connection).

The call I make is
p = app.LoadFromSqlServer(pkgName, "jtendam-d\sqlexpress", Nothing, Nothing, Nothing)
where pkgName is a string containing the package I want to load and "jtendam-d\sqlexpress" is the name of my machine and the instance of SS installed on it.

Thanks for any help.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
open connection in another connection adityamadisetty SQL Server 2000 1 May 4th, 2006 04:56 AM
Establish Com link to Webpage Mantis Pro VB 6 3 April 18th, 2005 04:14 AM
How to establish a sql server desktop engine pramos.21d SQL Server 2000 0 March 2nd, 2005 09:50 AM
Trying to establish an ID variable tkdk88 Dreamweaver (all versions) 3 January 25th, 2004 07:31 AM

All times are GMT -4. The time now is 07:51 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.