Re: LoadFromSQLServer won't work......
From: Danijel Novak (danijel.novak_at_snt.si)
Date: 01/07/05
- Next message: ryanlence: "Re: Operating System Command (CmdExec) will not run from Job Agent"
- Previous message: Danijel Novak: "Re: error on DTS scheduling"
- Next in thread: Darren Green: "Re: LoadFromSQLServer won't work......"
- Maybe reply: Darren Green: "Re: LoadFromSQLServer won't work......"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 Jan 2005 14:21:25 +0100
Hi,
What OS are you using on servers?
If it is Win2003 try disabling Named Pipes as Win2003 doesn't have them
anymore.
Danijel
<jdionne@idealconsulting.com> wrote in message
news:1105072447.885610.48440@z14g2000cwz.googlegroups.com...
>I have a VB.NEt Winform app deplyed on ServerA. I have a DTS package
> on ServerB. When I try to load the package with:
>
> package.LoadFromSQLServer(serverB, uid, pwd,
> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , packageName)
>
> Where serverB, uid, pwd are variables set in the program and are valid,
> I get this error
>
> Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
> exist or access denied.
>
> Which makes no sense because I'm using SQL Authentication and I am
> 1000000000% sure the uid and pwd are correct. Am I missing something?
> My VB app runs fine on the sql server but not anywhere else and I need
> to run it elsewhere against the db.
>
- Next message: ryanlence: "Re: Operating System Command (CmdExec) will not run from Job Agent"
- Previous message: Danijel Novak: "Re: error on DTS scheduling"
- Next in thread: Darren Green: "Re: LoadFromSQLServer won't work......"
- Maybe reply: Darren Green: "Re: LoadFromSQLServer won't work......"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
