I downloaded the free Visual Basic Express Edition to create an application that connects to a Mysql database. I searched for the connection string and found a bunch of different ones.I have no idea which one should I use with Visual Basic Express Edition. I have been using PHP, javascript and mysql for a couple of years, but I have never used Visual Basic and have everything to learn.
View 2 RepliesIm 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]...
What driver do you need to connect vb.net to MySQL?How do I create a Data source to MySQL? am only getting the options for SQL and MS-database! am designing a reg system for a college
View 9 RepliesI installed MS-SQL Server 2005 Express edition at my home and I want to connect my database from office by using VB/VB.net.
View 4 RepliesI want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID
Customer Name
Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.
I am trying to figure out how to connect to a MySQL Database and manipulate it using VB Express 2008
View 6 RepliesI've installed MySQL .NET connector but it's not shown in data source options to connect in Visual Studio Express Edition.
View 2 Repliesi 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?.
will SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 RepliesI'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
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 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).
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 am trying to connect to my remote MySql Database within Visual Studio using the compact framework.
I can successfully add a data source and preview the data within the IDE so assume that the connection is ok regarding Connection strings and remote access.
However, when I attempt to access the data using any run time control I get the following error when the table is loaded using the .fill method.
MySql.Data.MySqlClient.MySqlException was unhandled
ErrorCode=-2147467259
Message="Unable to connect to any of the specified MySQL hosts."
[Code]....
Is it possible to connect to a database on SQL Server R2 Express from Visual Basic Express? I am following a set of tutorial videos done in SQL Server 2005, but cannot seem to connect to create the database. I have created the database in SQL Server R2 Express, but cannot connect. Is there a work around?
View 4 Replieswhen trying to declare variables to access a mdb database using DAO with VB Express Edition 2008 I get this error:
line:
Dim
miodb As DAO.Database
error: Error 4 Name 'OpenDatabase' is not declared.
I have put references to DAO 3.6 Object library Is there anything else I have to do before declaring the database?
My company currently has vb.net 2003. I am tasked with evaluating vb.net 2008. And suggest if upgrading to 2008 edition is necessary or if it will be beneficial. For this purpose I decided to experiment with vb.net 2008 express. I have some questions regarding this.
1) Will vb.net 2008 express edition will give me idea about new features etc. ?
2) If I install vb.net 2008 express edition on machine which has vb.net 2003, will it cause any problems to vb.net 2003 ?
3) If I code in vb.net 2008 express edition, on upgrading will this same code work ?
I'm using Visual Basic 2008 Express and am having problems making an install.It has been suggested that the Express (free edition) only allows you to install only on computers that also have Visual Studio.Do I need the Full version to be able to distribute my application to a variety of computers?
View 2 RepliesI was wondering what people who have used VS Express editions think of them.My wife is thinking about taking a class in VB .NET so I thought maybe it's worthwhile to install VS Express at home for her to get a headstart.
View 4 RepliesI know the express edition of Vb does not give a detailed publish but i want to ask something. I have made program that uses database (Sql), and also my program uses folders (Help, Pictures etc..) I tried to publish my program but the express edition does not have an option to add my folders. So i tried to publish with "inno setup" program. But this time my program does not work in computers which dont have "Sql Server 2008 express". I tried to put "Read me " file, that says "First setup Sql Server 2008 Express from internet then setup .Net Framework from internet then setup the program" but it is so hard for user to do those thing. Is there any way easier? (Does the computer must have Sql Server to work with my database?)
View 1 RepliesI want to use the free express edition but am concerned about limitations. Wikepedia mentions "Limited options for debugging and breakpoints" as one limitation. None of of the other limitations mentioned concerned me.
View 2 RepliesI tried installing VB.NET 2008 express edition and I had to stop it because there was no network connection.Now it just gets frozen half way through the install everytime. Where are the registry values so I can delete them and install the program. So irritating.
View 3 RepliesI am in need of Visual Studio 2003 Express Edition.
Specifically VS2003 C++ Express Edition.
I have a very specific need that cannot be accomplished with VS2005.(trust me...)
If anyone has an old install file for the express edition of VS2003 on their hard drive.
Does anyone know a) if it's possible and b) any sources of information about - writing plugins for the Express edition of Visual Studio?
View 1 RepliesI'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'm doing a project for school (I'm in Year 6, Primary School, Australia) and I'm trying to create a measurements converter with Visual Basic. Unfortunately I have a problem (and no teachers in the school have a clue on how to use visual basic).Basically the program just converts a specified amount of one unit of measurement and converts it to another unit of measurement.A message box then pops up telling the user the answer. Eg. A user specifies that they want 1 mile converted to 1 kilometre a message box will pop up telling them what the answer would be. In this case it would be about 1.6 kilometres.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim double1 As Double = TextBox2.Text
Dim cb1 As String = ComboBox1.Text[code].....
I would like to have one combo box associated with another combo box. When the first one is selected the price is displayed in the next one. The information is got from a txt file and the item name loads in the first combo box and the price loads in the other combo box. What I want it to do is to show the correct price when the first box is selected for the item Here is a copy of my code at the moment. [code]
View 14 Repliesi'm not able to open the project and run the source code of the bellow link to treelisi'm trying to open with vb 2008 express edition and visual studio 2008, and several error are displayed.
View 1 RepliesI just installed Visual Basic 2008 Express Edition with SP1 on my computer.When I first launched it, it directed me to the registering site.
View 1 Replies