I've downloaded the ODBC driver and the MySQL driver and installed them on my system (Win XP SP3). However, the only data sources that are showing up when I try to add a data connection are Access & 2 SQL Server objects. Is there something else that needs to be setup in order for Visual Studio to allow additional data sources? I'm currently running VS 2010 Express.
View 1 Replies
i am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 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 have been using the internet to figure out how to INSERT into MySQL database. Im almost there I can feel it. Below is the code I put together, but when I click on the button and check the database to see if the data was inserted, it has not.
Imports System.Data.Odbc
Imports System
Public Class Form1
[Code].....
I'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
I'm working on a MySQL database with a VB.NET front end, and I'd like the installer to first install MySQL and Connector/.NET (if they aren't already installed) and then run a query to load the dump file that I'm including among the program resources.Is this possible, or will I have to instruct my users how to install MySQL and Connector/.NET themselves beforehand?
View 21 RepliesI'm developing a small project (just for learning, I'm not a pro) which involves creating software which could be used by a store owner for invoice generation. It involves storing all the store's products in a MySQL 5.5 database. Visual Studio 2008 is used for front end (Project was started in VS2005, later converted). MySQL ODBC Driver 5.1 is used for connection purposes. I'm still a student and haven't been able to learn .NET yet. So, I used the following link to connect the Database and the interface. I'm able to obtain all the data from the database like 'Product Name', 'Price' etc on the VB's forms through labels.
Now, for the purpose of invoice generation, the data in the labels i.e, 'Product Name' and 'Price' should be added to another table named 'Cart' whenever a button named 'Add to Cart' is pressed. How can I implement it? I mean, could anyone provide me with a code snippet that fetches the data being displayed in the labels and adds it to another table through 'INSERT' statement? P.S Basically what I need is a code snippet in VB that lets me execute an SQL query(any one like INSERT or SELECT or UPDATE) when a button is pressed in a form.
this is code where i want to insert ConnectionString=<%$ConnectionString =""%>[code]....
I can not connect MySql (SQL YOG) at all to this control, this is prob from .net control and not MySqlMark the thread as answered
odbc driver not found unable to connectmysql 5.1 odbc already installed and i have the following code to connect mysql
Imports System.Data.Odbc
Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" + "DATABASE=apdata;UID=root;PASSWORD=acelle;Port=3306;"
[code].....
I have a VB 2008 application that connects to a MySQL database via ODBC using the MySQL ODBC 5.1 Driver. Works fine on XP Pro and Vista Business (both 32 bit), but on my new Vista Business 64 Bit, I get the following error when trying to connect:
[Code]...
I can test the ODBC driver from Data Sources and it works just fine. Here is my DSN:
[Code]...
I 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]...
The company I work for has gone to great expence in getting me Express to code in.Tring to use the datagridview and attaching it to a source has me stumped.I can start the wizard, but it only shows Access and SQL express file locations.I need the connection to get to the actual SQL 2008 database.
View 8 RepliesI am a novice to programming and am working my way through one of the more popular books on VB in VS 2008 Pro. I am havng a probelm setting up to add dataset controls to a form. I can establish a connection to the data base (a dataset is created and I can preview the data), but the table adapters and binding sources are not being automatically added to the form by the IDE. This seems to be verified by the fact that I cannot drag and drop controls from the data source window to the form.
View 4 Repliesfor some reason my "data sources" window is empty when I open my project.Worked last night ,but this morning it's blank.Reads:Your project currently has no data sources associated with it.Add a new data source ,then add a new data source by dragging from this window onto forms or exsisting controls. What happened and how do I get this back to how it was.I can no longer open any project forms.
View 2 Replieswhere can i find data sources tab?
View 1 RepliesI have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1
[code].....
Currently, I am trying to make a table, which retrieves failed products and passed products from an Entity with LINQ.
Lets assume I've done that, but have 2 lists, A regular List(Of String), and a SortedDictionary(Of String, int32) (To hold the product, and the number of times the testpoint has failed).
Now, when I want to output them to ListView, in a Webform, how can I make it, so that List(Of String), will be output on the listview, and the SortedDictionary, be output after the List(Of String)?
EDIT: Although I could just add the SortedDictionary values to the end of the List aswell, but how would I go around doing so? Because I will create a listview with 2 columns, one which holds the descriptive text, and then a List(Of String) value. And the SortedDictionary would follow, requiring two columns.
It's been a long while since I've done any VB.Net coding and need to bind some data to a form. I have multiple tables that share some common primary/foreign keys and need to easily be able to update them.
For example, I have a table with an ObjectID, TypeID, AreaID, and several other fields. When doing my layout, I need the TypeID (found only in the main table) to be a distinct value in a comboBox, and in the ComboBox which contains the Area to be the Area Description (from the main table tied to the Area table via the Area ID).
I designed a form from dragging across tables from data sources. All in all, bindingsources, tableadapters, dataset & tableadaptermanager, I have about 40 objects in the component designer tray.I found out that on a few occasions, Im not able to view the form design because of corruption or something. Sometimes, I even lost a bindingsource object or even a dataset object which caused errors. Has anyone come across such incidents? Is it advisable to have too many objects in the component designer tray?
View 4 RepliesI'm developing a windows forms app, just upgraded it to use .NET 4.I'm VS 2010 ultimate RC.I'm running it in a virtual PC with 2GB of memory allocated to the virtual PC. I have windows 7 32 bit inside the VPC.I'm running win 7 64 bit with 4 GB at the host OS.Have a business DLL with about 300 of typed data tables.NOTE: The data tables are not in DataSets, we have generated the code for the DataTables using our own code generation mechanism.The data tables have been added as an data source (Of type Object)I'm running VS 2008 in my main OS. (Not a VPC)When running VS 2008 it takes 30 seconds to open the Data Sources window, the first time I open it.About 15 seconds subsequent times.Also when on a form and setting a binding expression it takes 10 seconds before the drop down list of available object to bind to comes up.
I have quite a powerful PC (5 experience score) relative to other developers at my company.This performance is a very serious productivity issue and makes developing windows forms apps very tedious.As a result of this VS 2008 is not very popular.The exact same slow performance seems to still exist with VS 2010. (Similar times)It could be the VPC but I don't have a machine to test this on and I don't want to put the RC on main main development machine.Did you expect a lot less than 300 data sources? 300 seems quite low to me for any real workd business application.
im using VS2008.I need to see both the Server Explorer window and the Data Sources Window.However I can see the Data Sources Window and dont know how to get it back.
View 1 RepliesIm currently making a program for a WM6 phone.. however this question applies VB.net programming in general.How do I use the datasources i have in my project... I currently have a datasource and a database file in my project.how do I connect to the datasource do i need to connect? when I deploy my application will my database file be carried over?
View 2 RepliesI need to do in other platforms but seem to be having some issues with VB .net 2008.I have a datagridview bound to an SQL table that has several comboboxes.the rowSource (is it called that still?) for each of the comboBoxes are SQL lookup tables that I've created and based on the the users selection in ComboBox1, comboBox2's datasource may change.What I want is, if the user picks "Dental" from ComboBox1, I want comboBox2 to load Dental plans (Which I have working, no problem here I think).And if they pick "medical" in ComboBox1, comboBox2 loads medical plans in comboBox2 dropDown list, which, again that part seems to be working.If in the first row in the DGV,the user selects "Dental" for comboBox1 and then a Dental plan in ComboBox2,on the next row, if the user inputs "Medical" in ComboBox1, the first rows ComboBox2's "Dental plan" info disappears.
The medical plan can still be selected and displayed in row 2's comboBox2 (so the changing of the datasource is working)If you then click anywhere in the first row, ComboBox2's dental plan appears again but Row2's combobox2 now no longer displays the medical plan.Becuase whatever value you choose, no matter if it's a medical or dental plan, the info gets saved in the DGV bound table, shouldn't it display the saved information from the DGV's source and not the shifting comboBoxes datasources?
I have a VB project with a large number of data sources in the data sources window. While the datasets behave well, the objects constantly expanded themselves to show all the properties. This means a lot of scrolling to find one.
View 10 RepliesIn Microsoft Visual Basic 2005 Express Edition Version 8.0.50727.42 (RTM.050727-4200) and Microsoft .NET Framework Version 2.0.50727.
Right Click Toolbox--Choose Item--.NET Framework Components--Check on OracleConnection and OracleDataAdapter--Ok
Now double click OracleDataAdapter1 in the toolbox.Data Adapter Configure Wizard appears. Click on New connection.Add Connection dialoge box appears.Click on change.Change Data Source dialogue box appears.Here i am getting only 2 items:
1.Microsoft Access Database File
2.Microsoft SQL Server Database File
And in Data Provider combo box; only ".Net Framework Data Provider for SQL Server".I am not able to configure my OracleDataAdapter1 control by choosing above method.Machine have Oracle 10G Client and Server well installed. I am able to use Dim oda As New System.Data.OracleClient.OracleDataAdapter() and it is working fine; but i wish to configure oracledataadapter by using above method. Moreover, it is possible for me to configure oracledataadapter in Web Developer 2005 by above metohd, but not in VB.NET.
I prefer having total control for data access, populating recordsets (now datasets) precisely via a connection string and SQL select (or stored procedure call), etc.Now I wonder whether I really should be using the Data Sources option which just popped up on my radar? From the little I've seen so far, it seems to bind an entire table to a control, whereas most of the time I only need a small number of records from large tables.Before I spend a lot of time investigating, I hope a quick word from you might help me feel happier continuing as I am, or whether I need a kick up the backside towards a Better Way.
View 12 RepliesI've recently started using visual basic express 2008 and am having problems with saving my project. Basically, the data sources keep dissapearing from the project when i have shut down my computer and come back to the project at a later time. This has happened to my project several times now and is getting quite irritating as i don't seem to beable to find a resolution to the issue.I could continue developing my application without having to re write the code constantly.
View 5 RepliesWhen I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?"This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general. The data source in this case is a .sdf SQL CE file.
Question 1: If I say that I want to copy the database to the project, what will happen after I compile the app, where the database will be? (how will I edit it from another app?)
Question 2: If I do not include it, how the data source will still keep linked? Can I link using filesystem enviroiment variables like %ProgramFiles%MyAppDir?
Question 3: Can I just tell it to use a read-only (Just needs to read it) data source on the web, like on an FTP?
I have a winforms app access a database with 6 tables. Out of 6, I am showing 3 tables on three different tabs on my Form. However, I want to do it using a single binding navigator that will use / change the respective binding source dynamically, depending on the tab that is activated by the user. I have separate binding source for each of the three tables.
View 3 RepliesI am using MySQL ODBC 3.51 Driver to connect odbc to MySQl.But it shows the following error.
[Code]...
