DB/Reporting :: Connection To A Remote Database

Feb 17, 2009

I have a problem with the connection to my database. It's on a remote server, and this is my code:

[Code]....

View 7 Replies


ADVERTISEMENT

DB/Reporting :: Connection Between Program And An Remote SQL Server

Oct 3, 2009

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]...

View 6 Replies

DB/Reporting :: Using Service-based Database As Remote Database?

Sep 20, 2011

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 Replies

Connection To A Remote MySQL Database?

Jun 21, 2010

I'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)?

View 4 Replies

DB/Reporting :: Remote Access Of A SQLEXPRESS Database Using VB2008?

Jun 24, 2008

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.

View 7 Replies

Remote Connection To A Sql2005 Database Through Hamachi/VPN?

Oct 20, 2010

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 Replies

Securing Connection Using SSL Between Application And Remote MYSQL Database?

Dec 27, 2011

I 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 Replies

Error When MS Access 2003 Database Is Opened From A Remote Connection

Apr 6, 2009

I 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 Replies

DB/Reporting :: Rdp Connection String From Database?

Sep 24, 2009

I 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 Replies

DB/Reporting :: SQL Database Connection Test?

May 6, 2008

I 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 Replies

DB/Reporting :: Changing Database While Connection Open?

May 17, 2010

I 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"))

View 3 Replies

DB/Reporting :: Database Connection Default Location?

Mar 7, 2008

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?

View 3 Replies

DB / Reporting :: VB 2008 Express - Establishing A Connection To A Database

Mar 9, 2010

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]...

View 1 Replies

Create An Application That Connects To A SQL Database To Populate A Datagrid - Getting An Error 'remote Connection Permissions' ?

Sep 25, 2009

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 Replies

Connect To A Remote Network By Creating A Temporary Connection On The Fly By Using The Remote IP/Host Name?

Jan 20, 2010

Rather 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 Replies

DB/Reporting :: Access-database Connection Provider (like Dao Or Ado.net) That Works On A 64 Bit Machine?

Jul 8, 2010

I'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

View 1 Replies

.net SQl Express Remote Connection?

May 23, 2011

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]...

View 1 Replies

Remote Connection To SQL 2005

Aug 26, 2009

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]...

View 2 Replies

Remote Sql Server Connection?

Mar 20, 2012

I have SQL Server 2008 setup to remote connection. and it works perfect. I can access it from public IP address. [code]...

View 7 Replies

Validate The Connection To A Remote Db?

Sep 15, 2009

i 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

View 1 Replies

VS 2008 FTP And Remote SQL Connection

Nov 25, 2010

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 Replies

C# - Detecting Remote Desktop Connection?

Jun 10, 2009

Is 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 Replies

Remote Sql Server Connection String?

Dec 3, 2011

I 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)

View 2 Replies

Check If The Connection To A Remote Computer Exist

Jun 4, 2011

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.

View 2 Replies

Setting MySQL Connection To Remote Server?

Aug 7, 2010

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 Replies

Sql Server Connection String On A Remote Desktop

Feb 3, 2012

I 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]...

View 1 Replies

TCP / IP Server - Remote Connection Fails To Connect

Mar 27, 2009

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)

View 7 Replies

WMI Connection To A Remote Machine Using Specified Administrator Credentials

Apr 3, 2010

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 Replies

An Existing Connection Was Forcibly Closed By The Remote Host?

May 19, 2010

I 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 Replies

C# - Program To Monitor Other System Vitals With Remote Connection?

Sep 29, 2011

I'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







Copyrights 2005-15 www.BigResource.com, All rights reserved