My question is how to link database from MySQL2005 with the interface created in Microsoft Visual Studio 2010 Express?Is it possible to link the database into my interface?
View 2 RepliesI am trying to follow this userguide url... to basically build an application that will allow users to connect to my database, from an exe file. I'll try to explain as best i can. The plan is, users will launch an exe file that i have built in Visual Basic(VB) 2010 Express. When they launch the application they will see a 'login screen'.I am following the example guide (see link above), and will customise it once i can connect to the database. For some reason whenever i connect to the database it gives me two errors, the first is if i use the 'debug' mode in VB to test the script (note it doesn't produce any build errors), the second is if i build the application and run it as my users would.
1)Error Connecting to Database:Access denied for user 'mike'@'92.**.**.***' (using password:YES)
2)Error Connecting to Database:Unable to access any of the specified MySQL hosts..The ip address starred out (*) is my local machine ip address.The server is the server in which my Database runs on. 'mike' is a listed user on my 'user' table, the password i use is the password assigned to this user on my table.
3)I've rebuilt the whole VB project, but still no joy, wern't expecting it to as there were no errors generated.
4) I've read, but don't really understand that it could be something to do with my database not being able to be controlled remotely, only locally. I started digging into 'Access Your MySQL Server Remotely Over SSH', didn't really know if i was going completely off the mark, it didn't mention needing to do any of this in the guide i've been following, but just a thought. It might be the case as i've tried to access my database through a programme called MySQL Administrator. I punch in the host,username etc and connect to my database, for some reason it won't allow me to add new users, could this be because i can't control my database remotely? Would this stop what i'm trying to do working?
5) When trying to install the MySQL.Data.dll file i had great difficulty in choosing one and finding it, adding it to my project using the 'Add reference' in VB. Finnally got it how it should be (i think), installed MySQL.Data.dll Ver 6.1.2.0 into my project.
The project must have different user and each has username and password will be saved in my database but only the admin can add users.
View 5 RepliesI wish to using Microsoft Visual Basic 2008 Express Edition to link with DeviceXPlorer OPC Server. But, I found out that in VB6 a function is called LinkTopic, LinkCode, LinkMode that I cant find in Microsoft Visual Basic 2008 Express Edition . Is it Microsoft Visual Basic 2008 Express Edition do not have this function or the name is different?
View 4 RepliesI 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 ?
link, from where I could download VB.NET 2005 Express Edition? All I see on the official site is 2008, which is not what I need
View 5 RepliesI'm coding a personal auth system using MySQL and I have made it using MySql.Data.MySqlClient but when I build the final version people required the MySQL.Data dll to run the application
Is their way of not requiring this or another way to linkup?
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 Replieshope I am not too short in this question but I am quite pissed off here
View 1 RepliesI am trying to figure out how to connect to a MySQL Database and manipulate it using VB Express 2008
View 6 RepliesHow to upload text file and microsoft office file to mysql database using open file dialog.
View 1 RepliesI am trying to connect my application to my database that's hosted on my website through another host. I am using the System.Data.SqlClient Namespace, and I have tried about every connection string possible, and I either get a long delay (About 30 seconds) before the main form displays with a warning in the Console box or it just gives me the warning and loads fast. Either way, it's not connecting.
code:
The x's represent just a masking. The server value is the ip address of my website. Basically, I am wanting this app to connect to my database of my website and it will be used to compare login information as well as the status of the logged in account (blacklisted, active, or needs to be activated).
I am Using Visual Basic 2010 Express. And the Express Version Does Not have a MicrosoftReportViewer Facility. But is there an Alternative that can be used. I know Monies have to be made But Surely there should be an alternative For the Microsoft Visual Studio/Basic 2010/2008 Express User.or is there another way to create a reportViewer in Visual Studio/Basic 2010 Express. I have Downloaded the MicrosoftReportViewer Redistributable from
[URL]
and I run the setup but it does not work. I know there are other apps that might help me like crystal report. But I want to just use Microsoft version as it is a Microsoft Program.
When i try to install Visual Basic Express 2010 and Visual C++ Express 2010, I get this error:Setup could not install the following component:Microsoft Visual Studio 2010 Express Prerequisites x64
I'm on Windows Vista Things I've tried: Deleting contents of %temp% folder
[Code]...
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesI've been reaserching for 3 hours on how to save data and retrieve data in mysql database I am using vb.net 2010 it would be nice if someone will post some codes or links
View 7 RepliesI am getting the following compilation errors from Microsoft Visual Basic 2010 Express on the first line of my code:
Error 1 Newline in constant C: cdotnetdevsrcvbmain estHelper.vb 1 1 Component Sources
Error 2 Too many characters in character literal C: cdotnetdevsrcvbmainRtestHelper.vb 1 1 Component Sources
The first line of my code is simply:
' Copyright 2011
It is generating the same compilation error for all my comments. Does anyone know why MS VB Express 2010 is acting this weird? Comments in visual basic are supposed to start with a single apostrophe so I don't understand this weird behavior.
I have version VisualBasic.2010 Express Edition , but this version Does not have the choose Microsoft SQL Server (SqlClient) when open vb.net choose : add new data source and choose database and add connection Does not have the choose Microsoft SQL Server (SqlClient)
View 1 RepliesI've been working on my game for a while, in a non-online multi-player state it is complete. My goal is to add LAN or Internet Play support.My game is coded in Microsoft Visual Basic 2010 Express, It relies heavily on timers.Currently you play against the AI, and there is a Local multiplayer mode, using mice, controllers or the keyboard.At the moment, it is a two player, (Or 1 player against the AI) game, from my understanding the standard Client-to-Server option wouldn't very efficent, the best choice would be a peer-to-peer system.That being said, a lot of the stuff could be done client side, like for instance, the particle engine and Dynamic Rendering.[code]
View 1 RepliesHere is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesI am unable to access the TableLayoutPanel feature inside the toolbox in Microsoft Visual Basic Express 2010, I was wondering if this is a feature that is excluded from this package or is it something that I need to download.
View 1 RepliesI have been reading about ADO, SQL, datasets, data adapters etc and have gone into information overload. My next step is to create a simple data file of my own that I can manipulate, update, sort etc in VB Express. Do I need another piece of software? I read about MySQL, which I understand is primarily used to access databases on the net, but can that be used to create a simple local data file on my PC? Can you simply hard code something in VB Express?
View 6 RepliesI am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesI'm using Visual Basic/Studio 2010 Express to run my VB program using MS Access database. I'm going to convert the Access database to a SQL Server Server Express data base so I downloaded SQL Server 2008 R2 Express onto my pc with Windows 7. The installation went fine and I actually converted my Access database to SQL server. I did not change anything in my VB program.My problem: When I run my normal program with the Access database (no changes), I now get an error when it executes the following code:
dr = cmd.ExecuteReader.
I get the error System.Data.OleDb.OleDbException was unhandled;
ErrorCode=-2147467259; Message=ODBC--connection to 'SQL ServerBilotta-pcsqlexpress' failed.
[code]....
It appears the ODBC is looking for the SQL server eventhough the program is pointing to the MS Access db. How do I get it to NOT look for the SQL db? Is there a default setting for the
I am trying my hands on VB.net and is trying out a small application which includes a survey form. The form contains radio buttons and when the respondent clicks on a radiobutton, digit '1' should be placed into the relevant field of the database.I have established a dataset and tried doing it but not sure how to do it because the book (How to program Visual Basic.Net by Dietel) does not teach us that
View 1 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 can i get one record in my MYSQL database what command should i use like this one in visual basic. How should i do these in vb.net?. I want to total the amount of items stored in my MYSQL database and show it in my listview. . . .I just want to get one record and get their values is their a command that i can do that?. . . .
this my code in vb using MS ACCESS
While rst.EOF = False
If txtpcode = rst!pcode Then
rst!stocks = Val(rst!stocks) - Val(txtqty)
[Code]....
I am doing a simple registration form in visual basic.net 2005, this form contains the general information about the person, in this form it includes uploading/inserting images for the record. Here is my project, on MS SQL,i can insert and retrieve images easily but when i switch my database into MySQL i encounter the problem that i can't insert image to my database. Can anyone provide me a sample code for inserting and retrieving image from a table on MySQL database?
View 15 RepliesI've been using ms access bfore but want to upgrade coz the company im working in is getting bigger. With almost 10,000 new clients added every week. Im afraid access can't handle it anymore. So im planning to create a new database. Im really new to this SQL Express but have knowledge in sql using vb codes. Is it easy to be used as backend database?
View 6 RepliesOne of the things I'm trying to do is work out the total profits for a company, reading from an access database comprising of two linked tables. All the information needed for the calculation in question (Fees, Sold/Bought?, Cost/Income) are found in one form (Financial) and I want to read this information and carry out the required calculations within a sub.
Here is the calculation in Pseudocode I wish to do:
Do
If SoldBought = Sold then
Total = Total + Cost/Income - Fees
Else: Total = Total - Cost/Income
Read Next Record
Loop Until End of Records
[Code] .....
Unfortunately, I encounter an error with the above. I get the following error;
"There is no Row at position 0".
How I could get this in motion - I've been stuck in a rut for days trying different things out and I've come to accept that I can't do this alone.