C/S and T/S using same DB simultaneously

I have a VB6 application that runs in both a client server or a terminal
services environment. Normally a customer uses one or the other. Is it
possible for a customer to install and run both of these at the same time
meaning they have the C/S connected to some users and the T/S connecting
other users but they both access one SQL server database? I had not
considered this situation before.
BruceL
Bruce,
I don't know why not. Whether the client code runs C/S or T/S is moot to
the SQL Server, since it knows very little about the client. It talks via
the communication protocols and grants rights to 'you', whoever you are.
The main issue is probably: Who are you in each of these environments? Are
you in the same security context, or not? But, however you are managing
access to the SQL Server will control who can log in and what rights are
granted.
RLF
"BruceL" <BruceL@.discussions.microsoft.com> wrote in message
news:268FAFAE-6729-4227-A95E-D60A02AEB119@.microsoft.com...
>I have a VB6 application that runs in both a client server or a terminal
> services environment. Normally a customer uses one or the other. Is it
> possible for a customer to install and run both of these at the same time
> meaning they have the C/S connected to some users and the T/S connecting
> other users but they both access one SQL server database? I had not
> considered this situation before.
> --
> BruceL
|||Thanks for the answer Russell
BruceL
"Russell Fields" wrote:

> Bruce,
> I don't know why not. Whether the client code runs C/S or T/S is moot to
> the SQL Server, since it knows very little about the client. It talks via
> the communication protocols and grants rights to 'you', whoever you are.
> The main issue is probably: Who are you in each of these environments? Are
> you in the same security context, or not? But, however you are managing
> access to the SQL Server will control who can log in and what rights are
> granted.
> RLF
> "BruceL" <BruceL@.discussions.microsoft.com> wrote in message
> news:268FAFAE-6729-4227-A95E-D60A02AEB119@.microsoft.com...
>
>

C/S and T/S using same DB simultaneously

I have a VB6 application that runs in both a client server or a terminal
services environment. Normally a customer uses one or the other. Is it
possible for a customer to install and run both of these at the same time
meaning they have the C/S connected to some users and the T/S connecting
other users but they both access one SQL server database? I had not
considered this situation before.
--
BruceLBruce,
I don't know why not. Whether the client code runs C/S or T/S is moot to
the SQL Server, since it knows very little about the client. It talks via
the communication protocols and grants rights to 'you', whoever you are.
The main issue is probably: Who are you in each of these environments? Are
you in the same security context, or not? But, however you are managing
access to the SQL Server will control who can log in and what rights are
granted.
RLF
"BruceL" <BruceL@.discussions.microsoft.com> wrote in message
news:268FAFAE-6729-4227-A95E-D60A02AEB119@.microsoft.com...
>I have a VB6 application that runs in both a client server or a terminal
> services environment. Normally a customer uses one or the other. Is it
> possible for a customer to install and run both of these at the same time
> meaning they have the C/S connected to some users and the T/S connecting
> other users but they both access one SQL server database? I had not
> considered this situation before.
> --
> BruceL|||Thanks for the answer Russell
--
BruceL
"Russell Fields" wrote:
> Bruce,
> I don't know why not. Whether the client code runs C/S or T/S is moot to
> the SQL Server, since it knows very little about the client. It talks via
> the communication protocols and grants rights to 'you', whoever you are.
> The main issue is probably: Who are you in each of these environments? Are
> you in the same security context, or not? But, however you are managing
> access to the SQL Server will control who can log in and what rights are
> granted.
> RLF
> "BruceL" <BruceL@.discussions.microsoft.com> wrote in message
> news:268FAFAE-6729-4227-A95E-D60A02AEB119@.microsoft.com...
> >I have a VB6 application that runs in both a client server or a terminal
> > services environment. Normally a customer uses one or the other. Is it
> > possible for a customer to install and run both of these at the same time
> > meaning they have the C/S connected to some users and the T/S connecting
> > other users but they both access one SQL server database? I had not
> > considered this situation before.
> > --
> > BruceL
>
>

BulkXMLLoad in a multithreaded server

Hi
Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
mean that SQLXMLBulkLoad may be called simultaneously from multiple threads.
Am I ok do this or should I use some sort of Critical Section to synchronize
the bulk xml load?
Many thanks
JonnySQLXMLBulkload is apartment threaded so you can use in multi-thread
aplications safely but not the same bulkload object in different threads.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> Hi
> Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
> mean that SQLXMLBulkLoad may be called simultaneously from multiple
threads.
> Am I ok do this or should I use some sort of Critical Section to
synchronize
> the bulk xml load?
> Many thanks
> Jonny
>|||Thanks Bertan
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
> SQLXMLBulkload is apartment threaded so you can use in multi-thread
> aplications safely but not the same bulkload object in different threads.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> threads.
> synchronize
>|||Actually, we recently found out that there is possible chance of name
collisions on temp tables that are created for identity value propagation, a
feature which is enabled by setting keep-identity property to False.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...
> Thanks Bertan
> Jonny
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
threads.
>|||arghh don't tell me that! lol
I have to has the keep-identity property as false otherwise my identity
column wouldn't create a new ID?
What's the best thing for me to do in this situation? Not use Bulkload in a
multithread app?
Cheers
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Actually, we recently found out that there is possible chance of name
> collisions on temp tables that are created for identity value propagation,
> a
> feature which is enabled by setting keep-identity property to False.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...
> threads.
>|||In this case, you should make it single-threaded. We're working on a fix
for this for SqlXml 4.0 (which will be available in Sql Server 2005).
Irwin
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d210i6$rll$1$8300dec7@.news.demon.co.uk...
> arghh don't tell me that! lol
> I have to has the keep-identity property as false otherwise my identity
> column wouldn't create a new ID?
> What's the best thing for me to do in this situation? Not use Bulkload in
> a multithread app?
> Cheers
> Jonny
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
>

BulkXMLLoad in a multithreaded server

Hi
Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
mean that SQLXMLBulkLoad may be called simultaneously from multiple threads.
Am I ok do this or should I use some sort of Critical Section to synchronize
the bulk xml load?
Many thanks
Jonny
SQLXMLBulkload is apartment threaded so you can use in multi-thread
aplications safely but not the same bulkload object in different threads.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> Hi
> Is it possible/safe to use BulkXMLLoad in a multithreaded server? It may
> mean that SQLXMLBulkLoad may be called simultaneously from multiple
threads.
> Am I ok do this or should I use some sort of Critical Section to
synchronize
> the bulk xml load?
> Many thanks
> Jonny
>
|||Thanks Bertan
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
> SQLXMLBulkload is apartment threaded so you can use in multi-thread
> aplications safely but not the same bulkload object in different threads.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1c73u$j9g$1$8302bc10@.news.demon.co.uk...
> threads.
> synchronize
>
|||Actually, we recently found out that there is possible chance of name
collisions on temp tables that are created for identity value propagation, a
feature which is enabled by setting keep-identity property to False.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...[vbcol=seagreen]
> Thanks Bertan
> Jonny
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:%23zeEgDBLFHA.688@.TK2MSFTNGP10.phx.gbl...
threads.
>
|||arghh don't tell me that! lol
I have to has the keep-identity property as false otherwise my identity
column wouldn't create a new ID?
What's the best thing for me to do in this situation? Not use Bulkload in a
multithread app?
Cheers
Jonny
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Actually, we recently found out that there is possible chance of name
> collisions on temp tables that are created for identity value propagation,
> a
> feature which is enabled by setting keep-identity property to False.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jonny Wilkinson" <jonny@.nospam.jonnywilk.co.uk> wrote in message
> news:d1m8po$6eb$1$8302bc10@.news.demon.co.uk...
> threads.
>
|||In this case, you should make it single-threaded. We're working on a fix
for this for SqlXml 4.0 (which will be available in Sql Server 2005).
Irwin
"Jonny" <jonny@.nospam.jonnywilk.co.uk> wrote in message
news:d210i6$rll$1$8300dec7@.news.demon.co.uk...
> arghh don't tell me that! lol
> I have to has the keep-identity property as false otherwise my identity
> column wouldn't create a new ID?
> What's the best thing for me to do in this situation? Not use Bulkload in
> a multithread app?
> Cheers
> Jonny
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:udFtrXyLFHA.568@.TK2MSFTNGP09.phx.gbl...
>