I can connect/login to my database, view a formatted table in the current window, however I want to click a button and see a new table set in a new window. Theoretically I should be still logged in/connection information saved but however I get 'unable to connect to database'.
View 2 RepliesI have a MySQL database online. What do I need to connect to it and exchange data?
View 2 RepliesI have a problem here I did make database program for a friend the database is online Mysql I use Visual Studio and put this into setup.exe when he install the program and try to log on he get this error This is my connection to the database
[Code]...
i am getting this error:
Code:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
When trying to connect to my database using the mySQL v5 drivers. I had the version 3.xx working fine until i installed the newer 5.0 drivers....
Code:
conn = New ADODB.Connection
With conn
.CursorLocation = ADODB.CursorLocationEnum.adUseServer
[code]....
But i can not seem to find the "correct" connection string for use with version 5..
how to connect a visual basic front end with a MySQL back end. I am not proficient in VB or MySQL and was not able to find anything on google as a result.
View 1 RepliesI think I already know the answer to this, but just to be sure, is there any way to connect to a MySQL database in VB?
View 4 RepliesI have a VB.NET application and I need it to be able to display rows from a MySQL database. How would I do this?
Update: Another thing that I could do is have the app get a PHP page from the site that shows the DB, and gets the page every 10 seconds or so.
I'm having some trouble setting up a working connection to a mysql database from Visual Studio 2010.After downloading and installing the mysql-net connector, I set up a simple testing database in Xampp and experimented around a bit until I managed to read some values from the database and inserting new ones.I'm trying to access another database on a remote server and all I get is an error message: Unable to connect to any of the specified MySQL hosts.Basically, I'm only trying to execute this code:
Dim con As New MySqlConnection("Server=111.11.111.111;Uid=root;Pwd=mypwd;Database=mydb;")
con.Open()
con.Close()
(server ip looks a bit different of course)When I access my local database, it looks quite similar:
Dim con As New MySqlConnection("Server=127.0.0.1;Uid=root;Pwd=;Database=test;")
con.Open()
con.Close()
Nevertheless, I can access the remote database easily using a simple PHP script... no problems there.
Connecting to a Online MySQL Database using .Net?
View 4 Repliesi got some problems with my connection to a MySQL database so this is my code:
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[Code].....
Ive been trying to connect to the MySQL database located on my website using vb.net 2008 express... i have been failing, when i run my code i have i get the following error,
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
That error comes from this code,
Code:
Dim connectionString As String = "Driver={MySQL};SERVER=coolness.something.com;DATABASE=Citys;UID=admin;PASSWORD=p975311;" '
Dim conn As New OdbcConnection(connectionString)
[code].....
I got this Database that is Online thats hosted through the Website and uses MySQL, and the Tables have some Data I like to Read From. Heres what I got
vb
Public Sub testconnect()
Dim sqlconn As String = "Server=63.247.93.106;Database=viina_schoolbook;User=---; Password=---;"
[Code]....
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'm trying to query an access database, but my query results only display the first cell of the query results.
For example, if I select 3 columns, 5 rows, only Column 1 Row 1 is displayed. Someone mentioned something about EOF but I can't find EOF code for OleDB. Should I be using another type of connection?;
Code:
Private Sub btnGetReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetReport.Click
Dim StartDate, EndDate As Date
[Code]....
i 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]...
Is there any way to have the program still run efficiently when connecting to an mysql database? Would System.Windows.Forms.Application.DoEvents() work anywhere?I have it connecting every 3 seconds on a timer and during that connection the program locks for a second.
View 2 RepliesI'm at an absolute loss here, I've read so many different things.I just want to add new records to a database I created using SQL Server 2008 with SQL statements in Visual Basic Express 2008. But I can't even connect/get it to recognise the database I created.The database name is 'database.mdf' and is situated in the MSSQL/DATA folder. So far I've read I need to use this code;
Code:
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdf"
Conn.Open()
[code]....
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
Not sure where to go from here....
I've used visual basic in office before, but when it comes to writing applications in Visual Studio, my knowledge is fairly limited. I'm unsure on how to set up a connection in my application to connect with a dBase IV database that uses indexes (not sure if it matters if it has indexes or not). I will need to both read and write to this database.
View 2 Repliesi am trying to save image into MySQL database ...is there any easier way to do that ?
View 1 RepliesI am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
i am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesI have a MySQL database I've created for my website, [URL]. I want to query the database, but I am unsure how to connect.
This is the code I'm using:
Code:
Dim sConnection As String = "Provider=MySQLProv;Data Source=my_database;User Id=my_user;Password=my_pass;"
Dim bSuccess As Boolean = True
[CODE]............
The MsgBox() returns a message that says: "Error: The 'MySQLProv' provider is not registered on this local machine". All I want to do is access the table in my database, is it possible? (also, without installing anything additionally?)
Does the .NET framework include ways to access MySQL databases easily?
Im building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
[Code]...
im trying to connect mysql from vb.net in visual basic 2010. i wanted to query the db just to get 1 return is response to my proID once i click the button. it successfully show connection has been establish but i cant seems to run any sql query on it. what might have been wrong? this is the error i got from immediate window.A first chance exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll.lets assume num is 1001 from the keypress event.
[Code]...
i am trying to connect to 10 mysql servers and get aprox. 5000 rows. If i make the test from local network it works but if i take the test using mysql servers (same version) from different city it shows me the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding".[code]
View 1 Repliesi want to make a program that connects to MYSQL and interacts with it (using VB 2008).For Example: i make a program that connects to the database and edits a few things like Row 2 , Colum 5 = 2 for example?
View 8 Replies[URL]
I have some hosting from [URL] so I set up a mysql db there. the actual db info is:
hostname: db2054.perfora.net
db name: db298669245
username: dbo298669245
[Code].....
The error is get is: "Unable to connect to any of the specified MySQL hosts."
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.