C# - Using SQL Server DB Over A Network?
Feb 16, 2012
I want to use my SQL Server DB over a network. I have setup server client applications.The thing is for my current DB, I need to give it to server administrator who attaches the DB to SQLExpress instance and only then my network computers can access that.My question is, is there any way that my vb.net application could attach this DB through code at runtime, and DB gets all rights that are necessary to access it over the network?
I can attach DB using Create procedure but for this I need to know the sa password. Is there any way that I could achieve the same goal without sa passord and sa intervention?My only purpose is to enable my DB to be accessible over the network with all read /Write rights.
View 1 Replies
ADVERTISEMENT
May 29, 2012
I have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 Replies
Nov 2, 2011
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
View 1 Replies
Aug 18, 2009
Here is my idea so far: I have a bunch of computers connected in a local network. One of them is a MySQL server, one will have a vb.NET program wich will act as a "second server" and the rest will be different clients. What I want to do is that the "second server" will send out some kind of message or network package to some of the clients in the network, and they will execute a code based on what message it is, or what kind of package it is. I'll give you a simple example:
[Code]...
View 6 Replies
Jun 6, 2011
PLEASE I HAVE OVER TEN CLIENT COMPUTERS. AM DESIGNING AN VB.NET WITH MSSQL SERVER 2005 EXPRESS APPLICATION THAT THE CLIENT CAN CONNECT TO THE DATABASE ON A ON COMPUTER.HOW DO I DO THAT.#ie vb.net + sql server network application
View 1 Replies
May 30, 2012
I have designed a project that connects to MsSql Server 2008. The local machine that I use to create the software is able to connect to the database but when I try connect from another machine remotely, It doesn't find the server.This is the connection string I'm using Dim Connection As New SqlConnection("Server=MyServer-PC;Database=MyDatabase;Integrated Security=True")
View 3 Replies
Feb 11, 2010
I want to connect To Database sql server via Network [code]...
View 2 Replies
Jul 18, 2012
how to find the list of SQL servers on the local machine...and not the network...
I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name....
View 4 Replies
Sep 17, 2010
My ASP.NET 4.0 Web App is unable to access Network Printers, while debugging on VS 2010. It can access local printers. Seems like it may be a permissions issue. Since VS2010 Debugging runs on ASP.NET Development Server, it must be running under the account I used to log into Windows, right? Does that user need to be added as an Admin in that printers users? Is there any account that I can impersonate to get this working?
View 2 Replies
Jun 22, 2010
I use Microsoft Visual Basic 2008 Express Edition and I am begginer in computer networks. I want to make two PCs communicate via network using server/client I followed the example from this site: [URL] (VB.NET TCP Client/Server Socket Commmunications) When I run the applications server and client in one computer then is possible the client to connect with server.
[Code]...
View 2 Replies
Aug 3, 2011
I'm having a issue connecting to a SQL server from a network drive. [URL]But i'm not sure how to give my assembly a strong name?
View 6 Replies
May 30, 2011
I'm breaking my head over the next problem. I have 2 applications (client/terminal). the client reads out the webcam and generates an image. This image needs to be send to the terminal which can accept multiple clients. At the terminal all received images are placed in an ordered panel. The purpose of this application is to monitor multiple webcams.What i can't get to work is how to send it on the client side and receive on the terminal side.
[Code]...
View 21 Replies
Oct 26, 2011
Greetings, I'm a little bit confused about SQL Server Compact behavior.I have a small app that uses a small sdf file located on a network share.The problem is that while the app itself is working perfectly well using the connection string that points the location of the sdf file on a network drive, when I try to open the same sdf using the Server Explorer I get this error:
SQL Server Compact does not support opening database files on a network share.Obviously, if the app IS working it does indeed support network shares, then why Server Explorer cannot open it?
I copied the database file to a local drive but it's not very convenient. What might be the problem?
View 3 Replies
Sep 14, 2010
I am after some code that read several mailboxes on a particular server on the network and bring me back the date of the last mail within each one. Is this possible ?
View 2 Replies
Mar 14, 2010
I have a client/server chat application which I made . My question is how do I make the application work not only Locally but On any other network. I tried putting my IP in the part of creation of the client socket .
View 2 Replies
Jun 8, 2011
I want my vb.net application to access the sql database from another network segment.I have two network segment, the application program that I made is in 192.168.7.xx segment and the SQL Server 2005 Enterprise Edition is in 192.168.1.xx segment but that application program cannot access the sql server unless I make them in the same segment.
View 1 Replies
Jul 14, 2010
I am using Microsoft visual basic 2010 and SQL server 2008.I develop a small database application and it run well on my pc.I built and distributed the application to other pc on the same network, but when I run the application from other pc I got error message like this:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)[code]
View 2 Replies
Jan 3, 2010
I work as an IT Administrator and manage a few Servers, Routers, VPN Connections over a number if locations. What I am wanting to do is create a vb.net app that will go out and ping say every 2-5mins each of the servers, routers, that are listed and then shows beside the Hostname a Green Circle which means online and if its a Red Circle its offline, and the screen refreshes if their is a problem or a device / service comes back online.
Then if its offline email a particular email address showing the hostname of either the server or router and which location saying its offline. If possible to make it easier to change the devices to show possible have a txt file or something like that with the Hostname, IP Address, Location.
View 2 Replies
Aug 10, 2011
I have 2 clients connected via a server program.When 1 client hits an arrow key, a picturebox moves on client1 and on client2.Before adding this network functionality, the picturebox on client1 moved fast with each click.Now, there is a delay of like 2-3 seconds.I know the code isn't optimal, but i'm not a networking wizard.What i'm doing is when pressing a key on client 1, it passes a text to a textbox in client 2 which then has the picturebox move in client 2 depending on the text.The slowdown occurs on client 1, which is odd because the picturebox isn't directly connected to the network code.[code]
View 3 Replies
Dec 27, 2011
I'm trying to access a web server to download a file, but when I run the statement gives me the following WebException:
[Code]...
View 7 Replies
Feb 14, 2012
I am creating a server-client type application that allows the network administrator to perform tasks on remote computers by using TCP sockets (TCPClient and TCPListener).The server application needs to send out a message to a client machine (with client application installed) and from this, the client application will send back the required data (i.e. system info, task progress etc). This part works fine.However, I am having trouble in getting the client application to constantly listen for an information request in the background. It should be listening whenever the application is running. What I want to do is to have an event handler which, when a message comes through, acts upon the instructions to send the relevant information back. The server does not need to constantly listen for data, as it will only receive data after it has sent a request.
View 2 Replies
Aug 23, 2011
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour , First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)But when I was trying the application in another pc (Windows 7 32bit)I got this exception: A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when the app reaches the DataAdpter.Insert(....) It runs without any problem .
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception before .
I tried these things as a solution:
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALISQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
what is the difference between fill and insert? My app. runs smoothly on the original pc ,What should I do?
View 13 Replies
Jan 19, 2011
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...
[URL]
Then following error occurs ....
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network
Interfaces, error: 26 - Error Locating
Server/Instance Specified)
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;
[code]....
...before publishing and uploading my website to webserver ...I m confused the problem is from my local computer or the webserver ....and how to fix this error ?
View 4 Replies
May 28, 2009
Basically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
View 2 Replies
Sep 8, 2011
I have this code:
[Code]...
View 12 Replies
Jun 1, 2010
i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 Replies
Nov 18, 2009
Error message receiving A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The project is written in VB.Net 2008. Production server uses SQL 2008, Dev Server uses SQL 2000. The application has been built and published.
Prod Connection String: strCN = "server=SGMAGNCPQ03.;Initial Catalog=APO_Tax;Integrated Security=True"
Dev Connection String: strCN = "server=S04423711940995.;Initial Catalog=APO_Tax;Integrated Security=True"
The Problem: When I change the connect string from dev back to prod and try to run my app, I get the above error message. If I reboot everything works fine but if I switch the connect string from prod to dev and try to go back to prod, I'm back to the same problem.
View 2 Replies
Nov 18, 2011
I have a .NET 2.0 *.dll that calls My.Computer.Network.Ping(). The *.dll is then run out of an *.exe via AppDomain.CreateDomain() and Invoke(). The problem is that this works just fine under Windows XP but under Windows 7, I get an exception saying that no network connection is available. I tried the Ping() call out of a small console application under Windows 7 and it works just fine.
[Code]....
View 6 Replies
Mar 26, 2012
I am writing some code as part of a framework for opening a file.The file is of custom type and should not be opened by more than one instance of my application. To stop multiple file opening I use a filestream to create a lock file and then keep said filestream open. This seems to work in preventing another instance of my application from opening the file ( as it will fail in recreating the lock stream in the files open code ) but if the file is on a network share and the network drops then the original application also can not access the file any more.The code to get the lock stream is as follows:
Try
' We need to keep this stream alive to prevent other applications gaining access to the lock
mLockStream = New FileStream(mLockPath, FileMode.CreateNew, FileAccess.Write, FileShare.None)[code]....
In this I create the lock stream the first time round and then if another application tries to create it, it throws an exception and stops them from getting any further. This is kind of how it needs to work, unfortunately as I said, if this is done across a network and then the network connection is dropped for some reason then I can not delete the lock stream as I get an IOException telling me a process cannot access the file as it is open in another process ( which shouldn't be happening I don't think).
View 1 Replies
Jun 22, 2011
I have a problem I want to make a server and client where the server is password protected and will make the client display files/folders in a designated folder which will be in the server's current directory and the client will ask what IP and password to connect to and if the password is correct is allows the client to access the files/folders in that folder in C.D. of the server and the client can download any file within the folder by clicking a button, yet don't even know where to start.
View 7 Replies
