473,802 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Exclusive connection MSSQL2000

1 New Member
Hi all!
Can anybody help me on how to obtain an exclusive connection on sql server?
Thanx!
Nov 23 '06 #1
1 1511
sashi
1,754 Recognized Expert Top Contributor
Hi all!
Can anybody help me on how to obtain an exclusive connection on sql server?
Thanx!
Hi there,

Make sure no other users have access to the particular database you wish to connect. Good luck & Take care.
Nov 23 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
6609
by: Mario | last post by:
Witam! Mam problem z polaczeniem sie z baza danych po TCP/IP przez port domyslny 1433, nie mozna sie telnetowac ani nic z nim zrobic, poprostu niezyje. Port jest zamkniety i nijak nie moge go zmusic do jakiejkolwiek komunikacji nawet po localhoscie. Skaner portów wykrywa go jako zamkniety. Czy wiecie moze jak ten port otworzyc i zmusic go do komunikacji z baza danych? OS win2k3, MSSQL2000 Server. Pozdrawiam Hello!
1
3685
by: CJJ | last post by:
hi Folks, I am opening my access database file (Access 2003) from a C# application. The connection string specifies mode=Share Exclusive The intent is that the application have exclusive access to the database file. No other instance of MS Access or this particular C# application (or any other app) should be able to open the access database file concurrently.
0
1424
by: Marek Wierzbicki | last post by:
Drodzy czytelnicy listy Szukam specjalisty znającego się perfekcyjne na MSSQL2000. Interesuje mnie wiedza typu "inside", czyli struktury plików itp. Konkretnie chodzi mi o organizacje wewnętrzną stron w pliku i możliwość gubienia ich przez MSSQL i ewentualne czyszczenie takich stron. Interesuje mnie raczej wiedza niecertyfikowana przez Microsoft, stąd status MVP nie jest w tym przypadku żadną referencją Prawdę mówiąc najlepszy byłby...
1
1966
by: malini.vinod | last post by:
Hi guys, I have a vb application that uses Jet.Oledb with DAO 3.51 over an MS Access database. New enhancements being done to this application is done in C#.Net. The vb application thus hosts the .net components.Normally the vb portion uses the dao connection, and the ..net portion of the application uses ado.net oledb connections. Now the problem is that there are certain features for which the database needs to be opened in an...
9
2487
by: forje | last post by:
Hi all, How to make a session "exclusive"? When one attempts to open a new session either he's warned and asked to wait or any other openned session is closed. The need is to force only one user at the same time. I'm currently using the database but also looking at a php only solution. Thanks in advance. -- Forje
9
2303
by: =?Utf-8?B?aXdkdTE1?= | last post by:
Hi, im making an AIM like server using TCP sockets, however i found a big issue. when a socket is connected to (socket.EndAccept(ar)), its already bound to a Port. since its bound, i cannot change its access to non exclusive, but i need this port to still be open because i may need another socket to connect on this port as well. how can i achieve this? -- -iwdu15
0
1234
by: comp21 | last post by:
Hi, Now, I have retrieved or imported data from excel spreadsheet to vb6 application. Now I want to compare this part of data with the one already existing in mssql2000 server(table name being same). If some data which is there in excel spread sheet not to be found in mssql2000 server then those data has to be stored in a seperate table in mssql server. Can anyone please help me with the code....
3
1813
by: Erwin Moller | last post by:
Hi Group, I developed a intranet site using MSSQL7/win2000 some time ago. The target environment used MSSQL2000/8. We were (almost painlessly) able to import the db-scheme and data from 7 to 8. (Bravo MSSQL) Now I need to do some upgrading on the application and I would like to have a copy of the database from MSSQL2000/8 to MSSQL7. Is that also possible?
6
4727
by: =?Utf-8?B?RyBIdXN0aXM=?= | last post by:
I am creating a new MS Access DB in code, which works fine. I then try to open it & set a password. I keep getting an error that the DB is already open by my machine's Admin account. In reality it is not actually open. Here is a look at my code for creating & then setting the Password. Dim ADOXcat As New ADOX.Catalog sCreateString = "Provider=" & Provider & ";Data Source=" & DatabaseFullPath Try ADOXcat.Create(sCreateString)
0
9562
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10538
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10285
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9115
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7598
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6838
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5494
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4270
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2966
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.