Books Online.

It is the compiled documentation for sql

look for

[drive]:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col

could yo define what you mean by workgroup, in terms of the network you are on?

It sounds like the boxes cannot find each other due to some network issue...

can the servers ping each other, and can the one outside the workgroup ping them?

First call is to Enterprise manager, to check the perms for that user, and then compare to the connection string from the web app.

You must use the...

Do you have sql BOL to hand? The 'using format files' page gives you everything you need.

Actually, from the bitter experience of trying to talk an NT4 based sql server into understanding the dates, it must be best practice to be explicit all the time?

Using SET...

IGNORE!

found the answer, though the MS reasoning isn't too good.

6.5 and 7 (had) bug that chopped the string into 256 char chunks, but then had a problem with it.

with 2k...

SQL Server implicitly converts an empty string to a zero - as it says in the answer.

The only bit that surprised me was the acceptance of the implied string as...

As Jeff suggests:

EXEC @hr = sp_OAMethod @object, 'Connect', NULL, 'my_server',

    'my_login', 'my_password'

is the example from BOL, and the second param, where you've got AddLedger, needs to be either a quoted...

"Data type of a Transact-SQL local variable used to store a returned property value or a method return value did not match the Visual Basic data type of the property...

It would but......

The IIS and SQL servers are on the same box, in the same domain and in their previous incarnation (NT/sql7) worked just fine, the only difference being that...

far as I can see, that's what I've been trying to do...

IIS is picking up the user login fine, and all the users are (on the domain) members of the...

Not specifically - but I've solved the problem now by creating a 'standard' login that is then added to the connection string.

I get the feeling that MS don't make...

<quote>I did pass on your suggestion about a profile trace to our systems engineer, but who knows if he will act on it, unfortunately.</quote>

That's not good....

Glad I could help - have been here and there before and learned a fair bit on Sps. The recordset you get back wil be the same as you expect,...