Re: DTS and MSDE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Allan,

I'm not sure I follow you about the runtine w/ MSDE 1.0. The packages are
running per the dtsrun utility (command prompt). I have one pkg that does not
have any global variables. The remaining do. However, I receive the following
error msg:

Error #: -2147467259
Error Desc: [DBNETLIB][ConnectionOpen(Connect()] SQL Server does not exist
or access denied
Error Source: Microsoft OLE DB Provider for SQL Server.

The above error is not appearing the in the vb app (removed error handling).
Also, the odd thing about this error is, I'm able to run the stored
procedures in the dts pkg's via osql.exe w/ no problem. That is, e.g. osql -S
<username> -P <password> -d <DBName> -q "EXEC Get_MyData @parm1='something'".
The data is returned w/ no Connection problem. I do the same w/ dtsrun /S
<username> /P <password> -N <pkgname>.

The pkg's w/ the global variables can't be executed properly because I can't
the use /A switch.

I've even used the "sa" login to execute the dts pkg and still receiving
connection error.

any help is appreciated.

jim
"Allan Mitchell" wrote:

Hello Jim,


So you are using SQL Server 7?

Only the runtime is installed with MSDE 7. How do you know the package runs
or think it runs?




--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Hello,

I have vb (6.0) app that attempts to execute a couple of dts packages.
The pkg's merely does some data retrieval and pumps the data into a
text file (.dat). The app runs fine on the machine that have sql
server (7.0) installed. However, on the machine w/ MSDE the app
appears to be executing the pkg but the text file is not being created
or the data is not being stored into file.

Not sure why this is happening.

any help is appreciated.




.

Relevant Pages

  • Re: how to see the list of all the function names?
    ... > I know "man sqrt" will give me the information about the function sqrt. ... 'rpm -qi $pkg' on a few packages to find where they put ... On my MandrX ...
    (comp.os.linux.misc)
  • Re: [HEADSUP][CFT] pkgng beta1^Wbeta2 is out
    ... add -n to pkg create to avoid packing already packed packages ... Fix rc script handling ... safer sbuf usage (this fix ia64 support) ...
    (freebsd-current)
  • 30 day Line Chart showing totals of 3 fields per day
    ... I have a table that has 3 date fields that are tied to a pkg no. ... Each day the packages move thru the completion process the next date field ... they match the log showing what is open, ...
    (microsoft.public.access.queries)
  • Re: A problem about pkg_deinstall
    ... pkg_deinstall -R deletes packages depended recursively. ... for example,i installed pkg A,it depends on pkg b,c,d. ... Problem with today's modular software: ...
    (freebsd-questions)
  • OPENXML
    ... does MSDE supports OPENXML and what do I need ... to make it work (other packages, ... Carlos ...
    (microsoft.public.sqlserver.msde)