Thanks Brian,

I will read those articles. 

But, If ever you find any URL, can you post it?

Bye

Carl

You should read an article writen by: Erland Sommarskog:

http://www.sommarskog.se/dynamic_sql.html

I think you will find interesting informations on using dynamic sql and sp_executesql.

Hope it will help.

Carl

Hello Sukhoi,

you can also consult the otn (Oracle Technology Network) forums at this adress:

http://forums.oracle.com/forums/index.jsp?cat=1

A lot of info there...

Hope it would help.

Carl

Hello Noel,

Thank's for your answer.

I applied sp3a on my server (not on client side). Also I grant execute on this proc to public but the error still arise.

But my question...

Ouups, s'cuse me for the typo error:

Should have read:

SELECT COUNT( DISTINCT [FieldA], [FieldB], ... ) FROM Table1

Carl

I everyone,

Just want to add this:

The use of this method:

SELECT COUNT( DISTINCT [FieldA] ) FROM Table1

Will always work if you have one column. But, of course, won't work if you...

Thanks for your comments on this thread Tymberwyld.

Carl

Tymberwild,

If it is well implemented, it should decrease performance for sure, but it should not be human perceptible.

Oracle behaves that way for a long...

Hello Everyone,

M.A.R.S. (Multiple Active Result Set) on one connection comming with ADO.NET 2.0 should resolve my concerns.

"The new version of ADO.NET shipped with Whidbey has some great features and...

Peter,

Thank's for all your research. It is very appreciated.

For now we will make some tests with the Getchars method of the SqlDatReader that is not supposed to make conversions.

Best regards,

Carl

Hello Brian,

I was very surprise that there were so few people that were seeing the new Snapshot Isolation Level as a "Must have" feature or as an "Important" feature.

Maybe people...

Peter,

Since now what I said is about what we are reading from the server but we have the same requirements for the strings we are writing to the server: we...

Peter,

I have read those topics from MSDN yesterday, thank you nevertheless.

What I can see is that I can affect System.Globalization.CultureInfo.InvariantCulture to the Locale member of a Dataset. But we don't...

Pêter,

I just want to add that we don't use DataSets, we just use SQLDataReader.

Regards,

Carl

Peter,

I'll try to be clear...

We use ADO.NET only in our own database acces layer, this database access layer will be in managed c++ but the applications that uses this database...