How to read data, submit queries from vb application to a remote machine running sql server. note: I have created a complete functional version of a stock control system with the database residing in the local machine. I just need the basic concept of interacting with remote databases that's all. Do we have to use sockets to read/send data ?
View 2 RepliesI'm looking into creating a program which will on program opening connect to a remote mysql database, download the data and store the data into a local file (keeping both in sync is the idea).
Getting a connection to the remote database is my first hurdle, and i'm not suceeding, i know i need to read through more info but if i could get this working it would help me tremendously.
I have attempted to connect using the mysql connector, using the server IP and port number ie. 199.002.999.000:3306 but it doesnt connect, it does connect locally ie. localhost but for some reason it won't connect to the remote server.
My other problem is that i cannot control the mysql server, i.e connections allowed remote etc, i think they're just enabled to accept connections from the server.
Is there a way to run a hidden browser script behind the scenes, download and run the file? I've tried looking for possible ways to acheive this, but have come up trumps so far.
i have a site that is running in php with a mysql db and i want creat a app wiht .net 2008 to return/send values to that database what is the best way to do that? i have think in this options:
[Code]...
I'm currently working on an application written in VB.net using Visual Studio. The app retrieves and updates data from a remote database. While debugging, I updated a particular row in the database and after messing around a bit managed to crash the app. Since then, whenever I fetch that particular row, the data that was previously updated continues to be retreived - regardless of what is actually in the database.
All other rows properly reflect the data in the database and are capable of being updated through the application as they should. However with this one particular row it continues to retrieve outdated data and locks up the application when I attempt to perform an update. Does Visual Studio create some sort of local copy of the database which was perhaps corrupted?
i write a program using vb 2005. This program collects data from Flight Simulator 2004 (altitude, speed, etc). These data should be uploaded periodically (every 10 secs) to a database which is installed to my website. The problem is that my hosting provider doesn't allow remote access to the database. Is there any way to put that data into the database?
ps. The strange with all the above is that i run a shareware program that can upload data collected from the flight to my database by simply adding the database name, user ir and password.
how can i display data from a sql database in a listbox?
View 2 RepliesPrivate Sub frmAttendace51_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'clear data set of any existing data
objDataSet.Clear()
'fill schema
[Code]...
reading and modifying data from database
View 4 RepliesI made a query in MS Access using fields from multiple tables. I want to display stuff from it into a listbox on the form and then I need to save stuff back too it also. But I'm obviously doing something wrong cos I keep getting the error: "The Microsoft Jet database engine cannot find the input table or query 'Today'. Make sure it exists and that its name is spelled correctly." [code] Also, I have written further down objDataSet. Tables("Today's Absentees") and "Today's Absentees" is a query not a table, what needs to be written instead?
View 3 Replies1) i want to make my login page (which talks to a sql table called logins) my first page and it authenticates to that database and doesnt let you in until correct credentials are entered. ? not sure how
2) I have a Checklistbox that is populated with names - ( i want to be able to populate a database called members with those names(Firstname & Surname Only) and from a New members form populate the same members details into the members database this time including address email tel etc etc ....
3) create a delete button that will delete the information from the database and from the checklistbox1 (this is in case the member leaves the club).
4) how do you create trial versions keys etc ...
5) change a progressbar timer to last an 1½ and show hours minutes seconds but once the button is hit to stop the timer it automatically resets to zero.
I'm reading data from a .mdb access database to a form in my app. However the text is sometimes becoming scrambled as shown belowDatabase:Quote:The resistance of a 2.5mmonductor of length 8m and resistivity p = 1.72
View 6 RepliesI'm trying to handle DBNull exception while reading data from database. It's my code:
...
Dim SQLRDAs SqlDataReader
...
val1= GetStringFromDB(Trim(SQLRD("Name")))
val2= GetStringFromDB(Trim(SQLRD("Level")))
[Code]...
But still I get Conversion from type 'DBNull' to type 'String' is not valid. error.
I have login system and also I know how to get 1 exact row from mysql but how can I create a table which will be filled with values from mysql table?
[Code]...
how to perform the database operation such reading data and using them for comparison within the VB programming..
Please guide me with explanation as i have very little knowledge regarding the database operation...
i am using VB.Net 2008 as frontend...and MS SQL Server 2008 (express edition ) as back end...
I have some trouble with opening a excel sheet and getting some data out of it.
I want my program to have a button, when pressed, gives a "select excel file" popup and then load the data from some cells into my sql database.
So, when opening a excel file the program should get the data from cell D3 to D8 and put that into the sql database.
I now have the following, but that will only open the excel file.
Public Class Form1
Dim oConn As ADODB.Connection
Private Sub ConnectDB()
[Code]....
I want read the below remote registry using VB.Net. "SOFTWAREMicrosoftWindowsCurrentVersionInstall erUserDataS-1-5-18Products"
View 4 Repliesi need a way to open a offline registry and read the oem info from it. The registry will be from a a hdd from another pc atached to mine. What im trying to accomplish is open the offline registry and read the model/serial info on it. i am able to read the registry of the booted system but no a offline one.
View 3 RepliesI need to Poll remote machines and list the drives they have mapped along with the path(UNC) of that mapping.So far I got some code that will allow me to Poll my machine not the remote one and instead of giving me the UNC it gave me the share name which code work but is not Ideal.
-----------------code----------------------------
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button3.Click
Dim allDrives() As DriveInfo = DriveInfo.GetDrives()
[code]....
I've been struggling for hours now to get some working code to list the share permissions of a remote share. I've got WMI code which uses win32_share which lists the shares and path and it works great. I"m now trying to add in a routine to get the share permissions as well.I've searched just about every site for some sample code and can only find some C# (I think) code.
string machine = "MachineName";
ConnectionOptions co = new ConnectionOptions();
co.Impersonation = ImpersonationLevel.Impersonate;
co.EnablePrivileges = true;
[code]....
I have a remote text file on http://somewhere... that I need to read into a string variable in vb.net. What is the simplest way to do this?
View 1 RepliesI am trying to read the HKEY_USERS hive of a remote machine with this Class
Imports System.Management
Imports System.Management.Instrumentation
Public Enum RegHive As UInteger
[Code]....
The value of sSubKeyName is the user's SID + "" + Network (e.g. S-1-5-21-1606980848-2025429265-839522115-560021Network). Now under that key are various subkeys containing mapped drive letters. But it never returns anything.
Strangely, if I use the OpenRemoteBaseKey method it works BUT I don't want to use that because using WMI lets me specify alternate credentials and OpenRemoteBaseKey doesn't
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
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 Replieshow to enable remote database
View 2 Repliesprovide with necessary code for connecting the remote database.. the remote database is in access. i am facing problem at defining the connection string. And i am using ado control for connecting the database.
View 1 RepliesI am having a small problem with my VB.NET and VC#.net programs. I am creating a spider program in VB.NET which parses a URL and stores data in my database. The list of URL to be parsed are included in my database. Right now the program is working fine as I am using a local database lying on my hard drive, but I want to use database lying on a remote server (ex. [URL]). How do I do that in VB.NET application?
View 1 RepliesMy client keep on insisting that they want there database to be ms access and not sql server. But they also what to be remotely accessible in there network.
Is it possible to use ms access as a remote database? would the database locked up once a connection is made?
i have written an application in vb.net 2008 that i want to access a remote database.when it tries to connect, this is the error message:[code]
View 2 RepliesI am a long time VB.NET developer but all my work has been on local databases. My employer now wants me to send data to a remote MSSQL Database without exposing the database. So, I think the answer is webservices. Except - I have no diea how to use this? I only know the word from my basic Google searches about this need.What we are trying to do is have a button in Outlook that allows the user to send the email to our CRM database.
I have been able to parse the email fields I need. How do I go about sending this to the database now? I also need to be able to read data from the database, so the user can select which customer to tag the email to.
I have connected VB.net and mySQL on a the same PC before, but I have no Idea how to connect VB.net to a remote PC(LAN)[code]...
View 12 Replies