from vb.net code i try to remotely connect to mysql server :
Dim conn As New MySqlConnection
Dim comand As New MySqlCommand
Dim myconnstring As String = "server=192.168.1.100" _
[Code]....
I get Timeout I/O operation. With mysql front i can connect without problem.I closed windows firewall.
How to connect to MS SQL Server 2008 remotely? I have the following code but I can only connect to the server under the local machine network.
[Code]...
I 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?
What 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
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesI want to use datasources or something to connect VB to mysql db and execute a querry with the information filled in and standard information.
i know how web scripts work with mysql but in VB i cant find any tuts anywhere about mysql and vb
I'm having a problem connecting to a MySQL server over two different trusted domains.We're developing an app for internal use and have been using MySQL till now. It's a desktop app written in vb.net.Up until now all the users were on the same domain and there were no issues. Just recently there was an higher-level decision to split users in 2 different domains for various reasons.The problem is that users from the new domain cannot access the server. If that helps, I was told by the administrators that the users from both domains are trusted. Both machines are running Windows Server - 2003 and 2008.The server port is open, the grants are all in there(base_class@%) but upon attempt access denied for user base_class@datablock2.
View 3 RepliesI have a database in MySQL server called MD
View 2 RepliesI have created a server-client application in Vb.net with back end Mysql .In client while am trying to run its showing the following message
"Unable to connect to the specified MYSql hosts"
i want to connect to mysql located on my website's server in visual basic.
View 1 RepliesUneable to connect to BBDD MySql in Virtual Server with Parallels Plesk Panel.
Does any one know how to connect to a Parallels Plesk Panel Server (my host is 1&1)?
I have a client that wants to connect to his MySQL database using Dial-up/Modem connection. All i know is a phone number. I will be using VB.NET 2005 for this project. We also have a LAN Connection setup to other computer, but some of this computer only uses Dial-up to connect. The LAN connection works fine because i can just use the Local IP to create a connection string.But my problem is how do i get to connect to a remote server using a Dial-up? I know building a connection string require an IP to connect. Do i need to get the IP after a dial-up connection is connected or to i need to use different approach? I have a server and i have 10+ clients, the server has a T1 connection + a dial-up modem installed also.I created a POS system to all the clients, Some clients uses dial-up some uses LAN. What the server do is all the records of the clients POS will be sync to one database on the server in one table. If i'm in the server and and i selected a station/client and click SYNC button all the records on that client will be sync to the server.
View 2 RepliesI have a programmer who is using VB and LINQ; and I have a MySQL database that is running on a linux server. My programmer tells me that:he cannot connect to the MySQL database via LINQ if he was able to connect then it would require all sorts of rewriting I don't know anything about LINQ but I thought it was an ORM. As such, any DB server that is supported should work just fine? Right? OK, so maybe it's not an ORM... maybe it should generically connect to ODBC and render similar results?
View 1 RepliesIs possible for vb.net to create an oledbconnection based on a url?
We have a program that uses ms access as the back end database, which is stored on a local server. The issue we are having is that our office is split in two locations. The remote users are having unacceptable speed issues since they have to communicate over the vpn. Im trying to find a way to either place the database somewhere that is quickly accessable to both offices, or to create a copy of the database on the remote server and somehow sync the two databases periodically.
I am trying to remotely connect to servers on a network. However, an exception occurs and I can never connect. The code I am using to connect to the servers does work because I have had someone else test it. The exception is shown below. Is this a setting with VB or with my computer?
System.Runtime.InteropServices.COMException was caught
ErrorCode=-2147220308
HelpLink="C:Program FilesPIPCPISDK..Helppisdk.chm"
Message="The specified time is invalid "
[code]....
I have a server and a client working with sockets. I run the server at my laptop, sending its internal IP to my Hotmail account and I run my client at my desktop. I enter the internal IP and connect fine! But when I tried to connect with my cousin's PC, which is not in my network, I entered its external IP and the client couldn't connect.
Here is the code for the Server (consists of 2 forms):
Form 1 (Server):
Imports System.Net
Imports System.Net.Sockets
Imports System.IO
Imports Microsoft.Win32
Imports System.Net.Mail
[Code] .....
How to connect mysql to visual basic 2008?
View 2 RepliesMy remote MYSQL allows remote connections so I should be able to connect to it via a VB code.
View 12 RepliesI want connect to MySQL without any AdoDB and those things.I want make program where must to be logged in before it opens.
View 6 RepliesI want to connect to an MySQL database on the website, I want to write and retrieve information from that database into a table on my program.
Can anybody link me to a tutorial on how to do this? Or give me some insight, I'm relatively new to Visual Basic (7 months) and I'm not exactly sure on how to do this.
I've installed MySQL .NET connector but it's not shown in data source options to connect in Visual Studio Express Edition.
View 2 RepliesI create an application in VB.net which connects to MySQL, deployed it to 10 computers. 8 of them worked perfectly, 2 of them gave me the error:Unable to connect to any of the specified MySQL hosts.What was different with those 2 computers? Is there any setting I need to do on the MySQL server itself? Anything I need to change/update on those two computers?
View 4 RepliesSo, 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 have a .dll file ( MySql.Data.dll ) that I'd like to be able to open, view and possibly edit the database but I can't find any examples or documentation on doing so.
[Code]...
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
We have a VB.Net application which works fine in our tests in different Windows XP SP3 machines. However there is one machine in which is displaying this error:
Unable to connect to any of the specified MySQL hosts
Using the mysql command, we can successfully connect to the database. We already checked for any other application or firewall that could be blocking the connection but it seems fine. We also reinstalled the system (no errors during the installation) but the MySQL error message doesn't change.
The system settings are exactly the same as in the other computers. We are using "localhost" as server in the connection string. The "hosts" file has its default values (nothing strange in there).
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]...
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 RepliesI have a VPN server Hosted in 80.234.49.64
For Incoming Connections I have to Login Remotely(RDP) & add User Manualy(username & password)
I Just want to do it remotely(adding users for incoming connection) Through an application. which i want to write in vb.net
I am working this little project where i need to ping some servers remotely. there's three of them. I need o ping them and per say while they're being pinged to have a command window open with the pinging process going to keep an eye untill it can ping successfully.And since this is for all three servers how do i create a program where it will have all three servers being pinged? [code]
View 6 Replies