There is a lot to understand about connections especially when IIS is involved and you have connection pooling as Antares686 points out. Usually if you have IIS configured properly...

You can try setting the Maximum characters per column to 8192 and see if that will do it. If not you will have to send the output to a...

Sorry been sick with flu for last 5 days.

Make sure you have the latest MDAC.

ADO2.6 may also run with 2.5 not sure.

What error are you getting?

My guess would be that DTS uses OLEDB to access the data? Someone correct me if I am wrong. And maybe the server is not configured in the sysServers...

We have been running tons of apps with mdac 2.5 and sql server 2000 for almost a year and no major connectivity issues

In odbc config where it ask What sql server do you want to connect to? was your srever listed in the dropdown or did you type it in?

Can you...

Nothing neat that I know of

Just raw string manipulation:

declare @string as varchar(50)

declare @strLen as int

declare @delimPos as int

set @string='new york,florida,california'

set @strLen=len(@string)

set @delimPos = charindex(',',@string)

select left(@string,@delimPos-1)

set @string=substring(@string,@delimPos+1,@strLen)

set @delimPos = charindex(',',@string)

select...

If there is a limited number of columns you will use in the where clause you could build a stored procedure and pass in the columnName and value

Then...

A good place to start would be here

Explore

The Explore sample guides a user through the SQL-DMO object tree, displaying the contents of collections and the properties of objects. The sample...

Might be a documentation error. According to the class browser the parameter of the remove method must be a long.

As an alternative replace your line

oJobserver.Jobs.Remove (sDelName)

with

Set oJobserver...

My suggestion is to try to accomplish your goal in query analyzer first. Once you have the sql working copy it into a stored procedure.

In this solution I am assuming everyone has a grade for english

select studentid,class1,grade1,class2,grade2,class3,grade3,class4,grade4 from

(select g1.studentid,g1.class class1,g1.grade grade1,

g2.class class2,g2.grade grade2,g3.class class3,g3.grade grade3,

g4.class class4,g4.grade grade4

from grades g1 left join grades g2

on...

The Query:

quote:

---

SELECT *

FROM tbl1

INNER JOIN tbl2 ON tbl1.key = tbl2.key

WHERE tbl2.filter = 1

AND tbl2.key = NULL

---

October 13, 2001 at 8:39 am