Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cant run power builder with sql server on network

Author  Topic 

Oladele
Starting Member

3 Posts

Posted - 2011-09-13 : 06:28:24
I am new to sql server. I am connecting a power builder app to sql server 2005, once a client system is connected anothere client system can not log on until the first to log on logs out. Pleaseeeee, any help will be highly appreciated.

Oladele.


Oladele

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-13 : 07:38:36
is this only happen to your Power Builder App ? How about the Management Studio ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-13 : 08:09:45
Database set to SINGLE_USER?
Go to Top of Page

Oladele
Starting Member

3 Posts

Posted - 2011-09-13 : 09:44:39
The sql management studio allows more than one instance of query to execute. thanks for your concern.


Oladele
Go to Top of Page

PHoranSybase
Starting Member

1 Post

Posted - 2011-09-13 : 15:33:05
Sounds more like a blocking issue to me...

Could there be an open transaction that's causing the second connection to block until the first connection is closed?



-Paul Horan-
TeamSybase
Go to Top of Page

Oladele
Starting Member

3 Posts

Posted - 2011-09-14 : 00:05:39
I am connecting to the database through odbc, is there a way to solve this blocking issue please. I need help. Thanks


Dele


Oladele
Go to Top of Page
   

- Advertisement -