473,231 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SqlConnection.Open() Hang

Hi,

I am using .NET 2 (beta2) and are having problems with using a SqlConnection.

I have created a test application that opens a sql connections, gets some
basic data and then closes the connection.

When i run this application as the administrator it works fine. However if
i run the application as a standard user the application hangs indefinatly on
SqlConnection.Open().
I dont get any time out, no exceptions nothing. It just hangs there.

I have tested this on many computers and the same happens.

My main issue is getting this to work on Windows2000 Server (Sp4).

thanks

Arran
Jul 21 '05 #1
2 4233
Although u'v not mentioned, i guess u'r using Windows account informations.
If its not an issue try SQL-Server login info. If you can't change login
procedure then u'v to look into the permission stufs of the windows users
who'r being restricted.

--
Regards
Atanu
"ar**********@online.nospam" wrote:
Hi,

I am using .NET 2 (beta2) and are having problems with using a SqlConnection.

I have created a test application that opens a sql connections, gets some
basic data and then closes the connection.

When i run this application as the administrator it works fine. However if
i run the application as a standard user the application hangs indefinatly on
SqlConnection.Open().
I dont get any time out, no exceptions nothing. It just hangs there.

I have tested this on many computers and the same happens.

My main issue is getting this to work on Windows2000 Server (Sp4).

thanks

Arran

Jul 21 '05 #2
Sorry i forgot to say, for the connection i am using SQL Auth not windows auth.

The test application works fine for a administrator just not for a normal
user. I have tried to give the normal user full access to the Register &
File system (just as a test) and that did not work.

I also made the user a Power User and that did not work either. If i make
the user a administrator it works fine.

"Atanu" wrote:
Although u'v not mentioned, i guess u'r using Windows account informations.
If its not an issue try SQL-Server login info. If you can't change login
procedure then u'v to look into the permission stufs of the windows users
who'r being restricted.

--
Regards
Atanu
"ar**********@online.nospam" wrote:
Hi,

I am using .NET 2 (beta2) and are having problems with using a SqlConnection.

I have created a test application that opens a sql connections, gets some
basic data and then closes the connection.

When i run this application as the administrator it works fine. However if
i run the application as a standard user the application hangs indefinatly on
SqlConnection.Open().
I dont get any time out, no exceptions nothing. It just hangs there.

I have tested this on many computers and the same happens.

My main issue is getting this to work on Windows2000 Server (Sp4).

thanks

Arran

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Donnie Darko | last post by:
I'm trying to understand SqlConnection(), SqlCommand() For example. I use SqlConnection() as a parameter when I create a new SqlCommand. Then I open SqlConnection(), then I execute the...
4
by: arran.pearce | last post by:
Hi, I am using .NET 2 (beta2) and are having problems with using a SqlConnection. I have created a test application that opens a sql connections, gets some basic data and then closes the...
4
by: The Coolest Dolphin | last post by:
Hi all, I have a question/problem concerning usage of my sqlconnection throughout my program. In my main form (frmMain) I defined an sqlconnection (I've set the connection public so that I can...
11
by: Bob | last post by:
In our new .NET web applications, we try to limit the use of SqlConnection to just one instance per page, even if there are multiple accesses to various queries. The thinking behind is that this...
4
by: Steve Richter | last post by:
I really miss c++ .... I have an SqlConnection object within my Web.UI.Page object. The thinking is that the connection to the database server is opened once when the page starts to do its...
2
by: arran.pearce | last post by:
Hi, I am using .NET 2 (beta2) and are having problems with using a SqlConnection. I have created a test application that opens a sql connections, gets some basic data and then closes the...
4
by: Victor | last post by:
Hi Guys I have a problem here. I want to improve the performance for a website. When I looked into the system, I have found that the system made the "SqlConnection Object" static. That mean only...
5
by: fniles | last post by:
I am using VB.NET 2003. When using SQLClient.SQLConnection with SQL 2005 database, 1. connection pooling is automatically used, right ? I mean, in the connection string I do not need to explicitly...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.