I have small application in vb.net
I have one table in msaccess, which is having around 20,000 records,
now, I want to insert these records to remote server of mysql,
I tried as below code, it takes around 3-4 hours to insert data, dst in code is having all records from ms Access
[Code].....
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 have developed a frontend app using VB 2010 which is to connect to a remote MySQL server. My server has an internal IP address of 202.56.20.72 and an internal IP address of 192.168.20.44.
When I use the internal IP in my connection string and connect over LAN, the whole thing works fine. But when i changed the IP to the external address and tried to connect to the server over the internet, I get an error something like 'Failed to connect to MySQL server for user 'user'@'localhost', [using Password=NO]. This means that for some reason, it is not connecting to the server at all.
I have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that "Access denied for user 'lukefrost'@'%' to database 'PHCAdminSystem'". However it will allow me with the same logon credentials the other ways explained above. Can anyone help me with what the problem might be?
View 1 RepliesI am probably beginner to intermediate at coding now, and want to make an application that interacts with a mysql database on my website.The application would be a Windows 7 App (Windows Forms) and i would like to contact the MySQL database and search and insert etc into it.The problem is my MySQL only allows contact from certain IP address (which you can add, but i cannot add "all")I am looking for advice on methods i could use to interact with the Database on my website, from an application which could be used by multiple users anywhere in the world.
View 6 RepliesI 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 want to restore an simple .SQL file,
The MySQL Server is Protected with password and is an remote Host
I have an issue with my code. The application interacts with a MySQL database on a remote server, I have access to this server. When my app is running the insert into code I m getting this error: "Conversion from string "INSERT INTO phpvms_fsspireps(pil" to type 'Integer' is not valid."
The variable which holds the Inser Into string, during break point debug gives me this: ""INSERT INTO phpvms_fsspireps(pilotid, code, flightnum, depicao, arricao, route, route_details, distance, aircraft, flighttime, flighttime_stamp, landingrate, submitdate, accepted, log, load, fuelused, expenselist, source,
[code]...
And this is my code.
Dim conn As MySqlConnection
Dim cnString As String
cnString = My.Settings.constr
[code]...
the DB spec:
Total DB size: 190,1 MB
Total Tables: 106
and the table specs. The titles are in Greek but I think you can understand it from the data. [url]
I'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
View 3 RepliesOk where am I messing up here, I had this working to a local SQL 2005 instance. However I am unable to get this to work to a remote SQL instance. Why?
[Code]...
I'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.
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I used the following code to insert data from my VB.NET into the MySQL database.[code]..
View 2 RepliesI succeed withe the linking and display the data from MySQL DB but the problem is within the DML Commands ![code]...
View 2 Repliesi am doing a project for my schooli am having difficulties in inserting data in mysqland also inserting multiple data in just a submit button
View 1 Repliesi have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 Replieshow to add, insert, delete and search data in vb 2008 using mysql databases.
View 1 RepliesI use to do programs in VB5 and haven't touch VB for years, and now i just started to pick it up again, VB2010. my problem is getting data from my MySQL Server (local)
i was able to create my Data Source successfully.. however, when i click and drag my CUSTOMERS table to my form the datagridview shows nothing. I read a few online tutorials and they all said that's all i have to do not working for me..i have 9 records in the table already but nothing is showing..
I'd like to save data to a text file on a remote server I have. There are no security issues here, just the method.
Dim FILE_NAME As String = "123.456.789.012/variables.txt"
If System.IO.File.Exists(FILE_NAME) = True Then
Dim objWriter As New System.IO.StreamWriter(FILE_NAME)
[Code].....
I know it's not the most secure way of doing things, but the end data has to be in the txt format, otherwise I'd have used MySQL.
I developed a project in VB.NET In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.
In my CPanel I added Host from the Remote Database Access But I can't communicate with WEB MySQL Server.
[Code]...
i'm working on an e-voting system for my thesis... but i'm having problem on how to output the data in all the rows in the database in a check box. so it means that the number of checkbox is equals to the row of the table. i manage to output only one data from the first row but i don't know how can i output all the succeeding rows.
this is my code so far
Private Sub LoadCandidates()
SqlString = "SELECT * FROM candidate"
'Function for searching by candidate ID number
[Code].....
I developed a simple examination system with registration forms. I used VB.Net as the programming language. I haven't tried manual coding for my problem yet.Anyway this is a project for the company from which I am an intern. The plan is to get every client pc to have this examination/registration application and this application will send the personal info and the score to a central database(server pc).I used MySql as the dbms and developed the application on the same machine which means that the Database server I used is only on the local host.
Now I was about to try to implement the application to one client pc(as a beta test) and installed the necessary files(.net framework) and I also installed MySQL Server(and workbench) in the server pc.When I run the application in the client PC it didn't detect/connect to the ServerPC's MySQL server instance and therefore was not able to record the dummy values I input in the client application. Take note I changed the connection string of my app to point to the ip address of the serverPC.
Should I install the MySQL Server(and Workbench) to every ClientPC so that I can create a server instance that uses the REMOTE HOST option and configure it such that it will connect to the SERVERPC's Database?How should I setup the server so it gives access to the application I installed in all clientPCs?
I have a VB.net app (which I will turn into a webform soon), my app generates a datatable of values (3 columns and on average about 1000-3000 rows).What is the best way to get this data table into an SQL Server? I can create a table on SQL Server no problem but I've found simply looping through the datatable and doing 1000-3000 insert statements is slow (a few seconds). I'd like to make this as streamlined as possible so was wondering is there is a native way to insert all records in a batch via ADO.net or something.
View 2 RepliesI'm trying to insert data onto a SQL server database. The Database connects up fine and retrieves data but I'm having difficulty inserting new data. [code] The query works if I run it through the table in database explorer and value of dim h shows 1 (rows affected). However, nothing gets updated.
View 13 Replieshow to insert some data on SQL Server database?i've tried this code, but it not works for me..here's the code:
Dim constring As String = "Data source=.sqlexpress;attachDbFilename=|DataDirectory|Database1.mdf;integrated security=true;connect timeout=30;user instance=true"
Dim connection As SqlConnection = New SqlConnection(constring)
[code]....
I just re did my question and added a few other scripts needed to pull everything together This is the small script I am using to receive the post and push the data into the SQL Server (2008 if that matters):
[Code]....
how to insert and update data into cache database which is setup as a linked server on sql server 2005.I mean to say insert / update query statement.
View 2 RepliesI would like to import the excel in to the sql server using vb.net. how can i do it? Another question is how can i execute the DTS using vb.net
View 6 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
INSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
[code]....
In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?