Yeah tried registering the DLL on the server. That din't work either...

I think I'll have to resign to the fact that unless I find a way to recompile on the...

Without compiling the DLL in the 64 bit environment, is there no way I can use it?

Don't have Visual Studio on the machine!

Thanks stanx68.......in none of the examples of transactions that I've seen is that apparent...... I guess I need to see some better material regarding trans....

Put a different way, should the COMMIT statement be always mutually exclusive to the ROLLBACK (like COMMIT in the ELSE condition when ROLLBACK is in the IF) ?

Thanks Guarddata!

The later section regarding your template seems to be the solution I need to adopt. I guess I'm still a little confused about the first, simpler question though-

In the...

I've been trying to install the SP3 on my machine- its running into some problems (been trying to install all the packs- for OLAP, desktop and well as the database...

The server properties shows :

Product version: 8.00.760 (SP3) so that's service pack 3 I guess, running on Windows NT 4.0 (1381)

I'm not sure what service pack my client tools are:...

I'm sorry.......I feel sheepish but that din't actually work. The remote server I was talking about is running under a domain account.

When I log into the actual development box (thru...

Thanks a lot!......that seems to be it..

Again, I appreciate your help.

Firstly, Brian .....your article was very good! I'm surprised to be helped by the bigwigs 🙂 (I'm just a rookie u know....)

I'm connecting to a remote development server... do...

jmadren ---- thanks a lot!

CLARIFICATION:

Thanks to the folks who have answered till now! The problem still remains-

Here are some clarifications-

-The settings on my database are US English and date format - so '03/26/2003/ means

26...