Re: SQLNCLI is not allowing CREATE DATABASE inside a TRansaction

Thanks for the reply.
But in the real programming world, this is not true.

I can prove that using a microsoft tool or some test program using
OLEDB or JDBC.

Example
If you use RowsetViewer supplied by microsoft,
with SQLOLEDB(my mdac is 2.8 sp1), Inside a trnsaction you can
successfully call CREATE DATABASE.

The same tool if you use with SQLNCLI, it will throw back error
mentioned by me.

The same thing can be reproduced using a java-jdbc program. I you wish
I can post that some test program using JDBC
Behaviour is totally different.

.