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 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 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 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'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 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 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 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 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 RepliesIm trying to connect to a remote mysql database, and im having alot of crazy issues, i have checked connectionstrings.com for information, im used to doing this in vb6, but times are changing and im trying to rewrite my apps for vb.net. anyone able to help with the new connection string to get it setup so i can connect to a remote database? i already installed and added mysql.data MSI isntaller on there and its version 6.0.4 i beleive, how can i make this thing connect to the database now?
View 24 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 trying to access server database from a remote computer in lan-based network using this connection string "Server=192.168.10.2; user id=user; password=pass; database=sample_db" .. but it can't open a connection.. I don't know what to do, I tried searching for this but no luck.
View 3 RepliesI'm trying to build an application so that the user can see table entries in a mysql database. I'm programming this in visual basic. How can this be done?
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 a website www.aybydinnovations.com.I setup a new mySQL Database into my webserver.I am developing vb.et application that will connect into that database from my webserver.
Here is my codes:
Imports System
Imports System.Windows.Forms
Imports System.Net.WebRequestMethods
Imports MySql.Data.MySqlClient
[Code]...
So, what I'm trying to do is to connect to a remote database using the MySQL connector. Dim c As New MySqlConnection c.ConnectionString = "Server=" & URL & ";Database=" & "" & ";Uid=root" & ";password =" & "" c.Open()I know the connection string is correct. I can access the phpMyAdmin through a web-browser just fine. For some reason however trying to open the connection throws an exception 'Unable to connect to any of the specified MySQL hosts'. I tried disabling the VS debugging process, as I thought maybe it's blocking my MySQL access for some reason, but no.
[Code]...
I am making a VB.NET application that can download/backup the database that is currently on a remote server. I have Remote Server IP,Username,Password and Database name. I am also able to connect to it. But I don't know what to do after connecting to it. I don't know what all files are need to be backed up. (I think database and log file both must be backed up, I am not sure).
View 1 RepliesI have a database in MySQL server called MD
View 2 RepliesHow to use MySQL database instead of SQL Server 2005 in asp.NET 3.5 ?
And how to create the membership tables in MySQL database as in ASPNETDB.MDF
how i can migrate a sql server database to mysql? I have an app (developed with VB 2003) that it works with a big DB SQL server. But the user wants to migrate to MySQL.
View 11 RepliesWorking in VWD 2010 Express I have an aspx.vb file with the following connection string:
Protected Function getPasswordLength() As Integer
Dim conn As New SqlConnection("Data Source=localhost;database=MyDB;Integrated Security=true")
Dim cmd As SqlCommand = conn.CreateCommand()
[code]....
This works when the code is on the web server / which is collocated with the SQLServer.However, when I want to debug, I have to copy to the server. I would like to be able to "debug in place" on my development machine and only copy files to the production machine periodically. Technically the production machine is not in production at the moment, but that's beside the point.Anyway, I followed the following instruction: [URL] I can now see the remote database, functions, etc. on the other machine (from the VWD running on the development machine). However, I thought I should then be able to execute this same code locally on the development machine using ctrl-F5, but I get the following error:
**Server Error in '/' Application.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)**
I 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 want my vb application to communicate with a MySql database on server on a LAN. What connection string can i use? Also, what syntax can i use? My application is installed on many computers in LAN with one central MySql database. I want all data to go to the database.
View 1 RepliesI have a database in MySQL server called MD
Server: Local host
User: root
Pass: wccmd12
port 3306
How do I connect to this database in vb.net?
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 am using Visual Studio 2010. I want to do database connectivity using VB.Net and MS SQL Server 2005. I know 1 way of doing this. Following are the steps...
1. Create a new Data Source Using Data Sources Window.
2. Select the appropriate view like details view/ data grid view for that data source
3. Drag that data source on your form and connectivity is done. Also all the controls are created by the visual studio.
This feature is really cool but I want to learn database connectivity by pure coding without using such advanced features. Also is it possible to do connectivity from a class library ?
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].....