Scott, I have no problem with Crystal 10 and a SQL 2005 / OLE DB data source, I can see the databases just fine.

I also have no problem viewing the...

I believe the default schema of the "read only" account is not the same schema where all your tables are loaded. Open the read only user from the Database user...

Tony, check my previous posts on this thread. Setting the isolation level on the transaction (not on the Insert Statement) did the trick.

It seems that the session variable corruption...

No problem. I'm Glad that fixed it. I've got similar systems and it would not be good if my identity values or Session variables get screwed up.

I believe...

Nita, do you have any Views that use Top 100% with an order by clause? The ORDER BY clause in these views is not supported in SQL 2005.

You...

Thanks, I still hoping to hear that you solved this problem. I think Transaction and Iden_Current changes will rule out SQL server as the problem.

If it turns out that this...

Can you provide the connect string that you are using in your application. Send a code sample. - Thanks

vicka, I'd change the proc to what is shown below. Transactions, the Serializable isolation and IDENT_CURRENT should rule out this proc as the problem. Try this out before...

I would find it hard to believe the IIS was getting session variables screwed up, but anything is possible. Look at the datetimes in your order headers table when the...

vica, here's another approach. Look it over and figure out what you'd need in the where clause to make it work.

SP InsertNewOrder:

Begin

Insert into order_table(..) values (...)

SELECT Top 1 YourIdentityColumnName

...

Jeff, from books online I got this:

Assuming that both T1 and T2 have identity columns, @@IDENTITY and SCOPE_IDENTITY will return different values at the end of an INSERT statement on...

Jeff, I've got a couple more questions for you:

1) I belive my earlier statement about the 2 web users sharing the same connection are correct, but I believe the will...

The problem is probably that the web server is using connection pooling and scope_identity will return the last value generated in any table in the current session. (see books online).

Look...

Try to isolate the ODBC issue. Open ODBC from control panel and try to setup a machine datasouce for one of your databases. If this does not work, then take...

No problem Ian, I wear the Developer and DBA hat and have used many of the same techniques, including my own home grown tool. We're in a relatively small IT...