DB/Reporting :: Connection To A Remote Database
Feb 17, 2009I have a problem with the connection to my database. It's on a remote server, and this is my code:
[Code]....
I have a problem with the connection to my database. It's on a remote server, and this is my code:
[Code]....
Connection between program and an remote SQL server. most of the hits were on VB6 and as you might see in the title I use VB.NET 2008, so let's begin:
[Code]...
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesI'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases.I've been following this tutorial from page 3 on, as the first 2 pages where on how to initialize a local MySQL database.My MySQL database is on my website, so I thought I had to use the website's name instead of "localhost". Anyways, I now use this code:
Dim connection As MySqlConnection
connection = New MySqlConnection()
connection.ConnectionString = "Server=resload.com; Uid=***; Pwd=***; Database=***;"
[code]....
But it popups (don't now whether that's a real word :p) with the message:Error Connecting to Database: Access denied for user '***'@'my ipaddress' (using password: YES)?
I'm currently designing a client application that connects to a SQL Server 2005 database. My app is being used to display data, allows users to run reports and stats on the data. It is being developed using VB2008. Within my VB2008 project, the connection string to the DB is made via SQLEXPRESS.
The road block that I'm running into right now is that it only allows me to connect to a local DB file (.mdf) only. I tried to connect to a different DB file on a server within the same network domain, and it generated the following error:
"The file "U:Data.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file U:Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." (where U: is a mapped network drive).
Below is the actual connection string in my code:
"SERVER=.SQLEXPRESS;AttachDbFilename=U:Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
The intention is to have the DB reside on a server, where there is another application that runs as a service to collect the data and then populates this DB. Then my app would just connect to the database, and allows users to run reports based on the data in the DB.
I heard that this is the limitation of SQLEXPRESS: it will not allow connection to a remote database. This is true? If so, is there anyway that I can get around this limitation?
The main reason that I chose SQLEXPRESS in the first place is that because of the licensing issue. The company that I work for do not want to make the users of our software app have to purchase additional license for the full-blown SQL Server Enterprise edition. I also heard that SQL Server Enterprise edition does allow you to connect to a remote DB (.mdf) file.
I would like to test a remote connection to a local Sql 2005 Database first thru Hamachi using a small exe that would be set on the client machine to let me know if the connection was successful or not, in the close future the connection would change to be set thru a VPN but for now i would like to accomplish this by using Hamachi software.i want to code the client .NET exe file to connect to the server, Hamachi gives an IP address and hostname once installed on the "server" machine so i wonder how should i include both in the connection string of the client exe file.
View 1 RepliesI am building a database application using MYSQL as the backend. The MYSQL instance will be installed remotely on a share host. I have access to SSL certificates. I'm obviously not looking for any code but, conceptually, how do I go about securing the connection using SSL between my application and the remote MYSQL database?
View 2 RepliesI have an MS Access 2003 database built that resides on a shared network path at the company I work for.The database works perfectly for users connected directly to the company network.However, when a user tries to open the database while connected remotely to the company network (they can still access the shared path), they receive the following error:The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.At the time that they tried it, they were the only person accessing the database.They tried a local copy as well as a copy on the network shared drive.[code]
View 4 RepliesI have just written an application for myself and a few other users to use .rdp to connect to a number of servers, by clicking on the appropriate button. In the full version of the program I have two sets of connections one for when we are inside our vpn, which uses local ip addresses and DNS names; and the other which uses the external IP addresses and DNS names.This works quite well; if the user has stored credentials on their pc for the connection they connect straightaway; and if they don't the .rdp dialogue opens up with the server name/address filled in, ready for them to edit the rest of the required information.The problem for me is that this means I have to code 43 different Private Subs and then link the buttons; and I was hoping that instead of individually coding each connection, I could get the users to:Select by an option button whether the connection was internal or external
View 3 RepliesI am new to Visual basic and am using visual basic 2008 to write programs in, I have setup a database connection and the connection string is currently stored in the settings section of the project.I would like to have a menu item where when the user selects "test database connection" it will run the sub for testing if the database is established.
View 2 RepliesI have a connection string in my app.config:
Code:
connectionString="data source=.sql2008 ;Database=Database1; Integrated Security=FALSE; Persist Security Info=True;" />
How do I change to another database (one of many) without using multiple strings? Can I change while the connection is open?
Code:
Dim myConn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))
I need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?
1.Establishing a connection to a database(preferably one that is inherit within the project and can travel with it)
2. Setting the correct references to the database ( I tried connecting via JET with windows 7 and I get an error that I cannot use JET)
3. Query the database (Access) with SQL, and return those results to a recordset.
4. Loop through the recordset.
5. close the database connection
6. Open recordset and write data to table.
[Code]...
I am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
View 7 RepliesRather than use an Entry name of an existing VPN connection, is it possible to connect to a remote network by creating a temporary connection on the fly by using the remote IP/Host name, username and password?
View 6 RepliesI've created a small DLL, an addin for Autodesk Inventor, this addin saves some information provided by the user and the program to an access(mdb)database.The whole idea behind this is that it allows users to quickly find drawings, assemblies and so on.The DLL works great on x86 systems however it has issues on x64 because I used ado.net.In a attempt to solve it I forced .net to compile it with the target x86 CPU settings.
However using this I'm unable register the dll (C:WINDOWSMicrosoft.NETFramework64v2.0.50727RegAsm.exe /codebase SavetoDatabase.dll )It says its not a proper .net dll file and therefore cannot be registered.
is there any other access-database connection provider (like dao or ado.net) that works on a 64 bit machine? Or do I need to change from mdb databases to another type (like mysql)? because sooner or later all machines its running on will be converted to x64.Or do I need to register the dll in another way?I've also tried to replace the conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 with ACE, with no luck however
I am trying to run an application in VB.net having SQL Express 2005 at back end.it's working fine on stand alone machine but when i try to run in LAN environment i have to manually set the "Locale and remote Connection " and "TCP/IP and Named Piped " option through SQL Server Surface Area Configuration. I am setting the registry value using SQL stored Procedure as below
[Code]...
I wrote a program in Visual Basic 2008 on my laptop that runs windows vista 64 bit, well the program attempts to access an Sql server that I am running on my laptop and it continues to give me the following error:
[Code]...
I have SQL Server 2008 setup to remote connection. and it works perfect. I can access it from public IP address. [code]...
View 7 Repliesi want to validate the connection to a remote db...
i'd like the code to try to connect to the database if the connection was established then show message box if not show form1
Can anyone provide me with some sample code on how to connect to the hosted FTP server, and then connect to the MS SQL database file available there?
View 8 RepliesIs there anyway, in a program, to detect if a program is being run from inside a remote desktop session or if the program is being run normal in .NET 2.0? What I'm trying to do is, I create a timeclock application which will clock a person in and out and keep track. But this particular person, I suspect, is remoting into their computer at work, from home, and clocking in and out.
View 5 RepliesI have configured Sql Server Express on a server, Enabling TCP/IP and Named Pipes to accept remote connections. However when i attempt to connect from VB.net on another PC on the same network I get the following Error: Failed to login user "ServerNameUser".
Can anyone offer some server setting and a ADO.NET Connection string. The attached file has the Sql Server Settings.Attached Files sqlRemoteConfig_Current.txt (806 Bytes, 70 views)
I looking for a solution for how to check if a connection to a remote computer exist or not using vb.net.
I 'm writing a program which will request data from a remote sql server. I need to check if the connection to the remote server exist, before open the connection or run the the sql command.
I Downloaded MySQL Connector (the latest, 6.1.X), and i cant really understand how to use it in VB.Net... I Added it to references. All what I need to know is what imports to use, how to set connection with remote server and how do I select and insert to tables.
View 6 RepliesI built a window's app in VB. The app is made to be used worldwide. The app works fine when it is installed on a computer using the same network than the local machine hosting the sql database. The problem actually, is that, when the app is installed on a computer using a diferent network, the connection fails.
[Code]...
I've came across a little problem with my tcp / ip server. My client can connect to it with 127.0.0.1 ( localhost ), and 192.168.0.X, but every remote connection fails to connect.
Here's the connection rituals:
Server
listener = New System.Net.Sockets.TcpListener(System.Net.IPAddress.Any, Port)
listener.Start()
listenThread = New System.Threading.Thread(AddressOf doListen)
listenThread.IsBackground = True
listenThread.Start()
Client
client = New System.Net.Sockets.TcpClient(IP, Port)
client.GetStream.BeginRead(readBuffer, 0, BYTES_TO_READ, AddressOf DoRead, Nothing)
I'm having an issue here with making a WMI connection to a remote machine using specified administrator credentials.I have the WMI code inside a function, I pass it the computer's name and it returns the WMI information that I am requesting as a string (or in this particular case, an integer) from the remote machine. I'm positive it works, and returns the information I need using specified admin username/password. NOW, the issue I am having is related to (it seems) calling this function from a backgroundworker. [code] "Value does not fall within the expected range." I literally have no clue why this would throw that exception, yet when I call this function from lets say just a random button on my form, it works beautifully. The key here is that I need my WMI requests/processing to run in the background.
View 18 RepliesI have a fat VB.NET Winform client that is using the an old asmx style web service. Very often, when I perform query that takes a while or pass a large amt of data to a web service in a dataset, I get the subject error.The error seems to occur in < 1 min, which is far less than the web service timeout value that I have set or the timeout value on the ADO Command object that is performing the query within the web server.It seems to occur whenever I am performing a large query that expects to return a lot of rows or when I am sending up a large amount of data to the web service. For example, it just occurred when I was passing a large dataset to the web server:System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the rem
View 3 RepliesI'm looking to write a custom program in VB.NET / C++ / C# that would allow me to monitor a system's vitals over a Remote Desktop Connection. I'm only looking for tips on how to implement a connection like this in code (eg. is it just a simple object or call to a WScript function? or is it much more sophisticated?). As to the specifics of operation after making the connection, I have that figured out based on another program which shares some similar features. This doesn't have to go through an RDP connection, I'm definitely looking for better ways. Reason I mention RDP is because I currently do this manually over an RDP connection, but I don't wanna have to constantly open the window.
View 1 Replies