switched to TCP connection and got problems

[Marc]

I switched from named pipes to TCP which works for most of the pages but a
bunch of my pages don't work now. I seem to have problems retrieving
multiple recordsets and returning a value from a SP? Is there a setting I
missed?

Thanks.

[Marc]

This works:
objdc.open "DSN=OT", "the username", "the password"

This doesn't:
objdc.open
"Provider=SQLOLEDB;Server=127.0.0.1;database=OT;ne twork=DBMSSOCN;uid=the
username;pwd=the password"

"Atrax" <atrax@dontspamatrax.co.uk> wrote in message
news:O3ys5PSRDHA.1324@TK2MSFTNGP11.phx.gbl...

> > Is there a setting I
> > missed?

>
> can't tell from here - got any more info...
>
>
>
>
>
> ________________________________________
> Atrax. MVP, IIS
> [url]http://rtfm.atrax.co.uk/[/url]
>
> newsflash : Atrax.Richedit 1.0 now released.
> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!