Create Applications That Connect Using ADO And/or Linked Tables?
Mar 18, 2010
I am very familiar with VBA and have been using access and excel to create applications that connect using ADO and/or linked tables.I'm looking to start developing simple Windows applications for my company using Visual Basic, that will connect to Oracle and SQL Server Databases using ADO. What do I need to accomplish this? If I purchase Visual Studio 2008 Pro, will it come with VB? And do I need anything in addition to this in order to connect to SQL or Oracle databases using ADO method?
View 7 Replies
ADVERTISEMENT
Jun 18, 2009
When 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?
View 1 Replies
Jul 15, 2010
I have an Access frontend with a lot of tables linked through ODBC to a MySQL backend. I have a VB.net application that sometimes adds columns to the tables in the backend, and when that happens, I need to refresh the link to the table in the frontend from the VB.net app to show the new columns.I'll consider just about any solution as long as it doesn't require restarting MySQL or Access, and will allow me to refresh only the links I need to refresh (which I know in advance) as there are hundreds of links and tables in the frontend.
View 1 Replies
Mar 23, 2009
One 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.
View 10 Replies
Apr 14, 2011
I have a system that gathers raw data from electronic devices, uses that data to populate a set of tables and allow uses to add/edit certain data and report on it. (Kind of basic right...NOT) There are 3 applications that I've written that use the same database.
One is a client that is on 3-4 user machines which allows them to see the data that has come in and work with it.
Two a Data-to-Information process program which takes the raw data, checks up certain information and puts the results into the database.
Third is a data gathering app that interfaces directly with the electronic devices and about 10 times per day places the raw data into a single table in the database.
If a user is in the 'client' application the data processing application crashes all over the place:
1. Database file already in use.
2. Unrecognised Database format
3. File locked exclusively by User on PC X.
Almost always on a different line of code and once when I made it retry over and over I managed to corrupt the database and had to Compact and Repair it to fix it. If no one is using the client everything works perfectly. On each client machine is a database with linked tables to the server machine. The machine that is running the Data processing is the server and the processing is using a database in a different folder that also has linked tables.
I have gone through all the recordsets in the Data Processing application and made sure that they are only using ForwardOnly and Read Only. They edit the data only with Insert, Update or Delete queries. I'm about to do the same in the Client Application as it seems to be the one that is locking everything all the time. The client machines haven't crashed on that error at all. Does it matter which version of Access is on the client and server machines? (All the clients have Access 2003 and the server has 2007 but the Database was created in 2003). Should I just convert the Access database to SQL server and be done with it?
View 6 Replies
Aug 1, 2011
I have an VB application that I developed in Visual Studio 2008. The back end is SQL. Application stores quite a bit of information and gets updated daily by users. It also connects to AD to get u/p, adds new accounts in AD and adds mailboxes. Users connect to it through Citrix. We noticed big spikes in memory usage. The executable itself is less than 5Mb; if I run it and it opens main form - memory usage jumps to about 19Mb, open a report - it jumps to 80 Mb. If I open the form that is linked to multiple tables - it jumps to 157 Mb. Once users start pulling new information in, update it and connect to AD or Exchange - it could jump to 250 Mb. Also noticed that if user with read only rights has application opened and idle - memory usage constantly changes with a pattern
like 17Mb - 19 Mb - 15 Mb - 17 Mb and so on. This user wasn't even using computer at the time. In general - what could cause such jumps in memory usage? What is the best way to prevent it? On the server we have Windows Server 2003 SE
View 1 Replies
Mar 24, 2009
i need linked an db like (access 2003) with my app for my webbrowser to save my favorites and history .......tell me why especially used it....any way w8 repliesand i have another question about i built tapped browser but icant linked the webpage download with progress bar.
View 1 Replies
Feb 19, 2008
I have code that connects to queries in an access database.
[code...]
Is the data not filling in because of the schema information not being retirieved? If so, is there a way around that?
View 3 Replies
Apr 9, 2009
I need to load a list of tables and linked tables in an MS Access Database into a combo box. I have this.
vb.net Imports System.Data.OleDb
[Code]...
1. How do I load the access tables and the link tables into my combo without the system tables showing up?
View 7 Replies
Aug 15, 2011
how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 Replies
Feb 25, 2012
I have 5 websites running on same server and I have some sql tables that I access frequently. that was time consuming and by defining them shared I pumped them in memory. So my application is accessing those static data tables from memory quite efficiently.
But I realized I did a mistake and I occupied my memory unnecessarily while I keep same tables 5 times for each web application. Now I need to find the best way to share that table only 1 time. my options are;
1) using a local database - sql CE. my original sql database is on other server. so it makes the access slower but I can add a sql CE database(to be honest I never used it and dont know if it gives me anything) to access only these tables while they have static rows.
2) I read over forums that making a WCF using tcp binding. not sure if it will give me any advantage.
3) windows service: is it faster than wcf? programming is defiantly faster as i have experience with winservice but nor sure about performance.
View 2 Replies
Sep 13, 2009
How can i connect two VB.net applications together so that they can send each other informations ???
View 3 Replies
Jul 25, 2012
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
View 4 Replies
May 14, 2011
I'm supposed to create a linked list and add/remove items with a push/pop. Currently I can only push 2 items and pop one before it stops, and I'm not sure what I need to do to fix that.
[Code]...
View 3 Replies
Jun 11, 2011
I dont know how to link my table to the database yet i already finished connecting to the application itself. i have four fields on the form as well in the database table. that is
1.word
2.lug_trans
3.Eng_trans
4.meaning
the same fields appear in the database tables. i have to fill and hen after extract the data and display it on another form in four labels
View 2 Replies
Jun 10, 2009
I've been trying to connect a MS database to a V.B. form unsucessfully.Actually when i try to do that, i can't connect the tables information to the form or store the information i enter in the form in the MS table.I was doing an exercise here, and to store the information in the table called readers, i typed:
View 1 Replies
Jun 5, 2011
How can I connect two tables from MS SQL Server 2005 using vb.net 2008?
View 5 Replies
Oct 22, 2010
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
View 1 Replies
Feb 17, 2012
Im needing to create a 2 applications that can talk to each other. One wil run on a server as the server application and others will run on workstations as clients. I want them to connect to the server app much like a chat program would work. I want to be able to send commands from the server to the workstations such as reboot, open this file, things like that. I also would like to be able to send the commands backwards to the server if needed as well. i think a chat program could be modified to do this by "watching" the message and if the word "reboot" comes through then the server/workstation would convert that to a command.
View 9 Replies
Jun 21, 2010
i wanna know whether we can create mobile applications for nokia (N series) and install them in the phone using vb.net..i have gone through the smart Device option available in .net and it seems to be valid only for pocket PC's.
View 1 Replies
Mar 26, 2009
I am working in Windows applications. I want to create a Chart for showing results as user friendly. How to create chart in VB.NET or C#.NET for Windows Applications.
View 3 Replies
Nov 1, 2009
I have some experience creating programs that use tcp to transport information from a server computer to a client computer and vise versa. However, I am unable to create udp server/client programs with visual basic.net . My goal is to be able to set up a connection with several computers that can communicate with eachother.Kevin Schaefer "The world is round and the place which may seem like the end may also be the beginning"
View 1 Replies
May 11, 2009
which method is more efficient to use: DataAdapter and DataSet Or DataReader when importing data from a certain database table???
View 6 Replies
Aug 27, 2009
I my opinion i think i should use datasets fully when performing select, insert, update and delete operations to DB. Foloowing this concept, The applications control flow should be:
[Code]...
View 1 Replies
Aug 17, 2010
I am using VB 2008 Express Edition and I need to create applications using the Smart Device template and the ASP.NET Web Site template.
View 1 Replies
Apr 13, 2009
Using: Visual Studio 2005.We are developing three different applications. We currently have 4 different modules that we all share among our applications. When a change is made to one of the modules, we must make changes to the other two modules.If it is possible, how do you (where do you) create a single location for one file to be shared among three different applications? Hopefully this will avoid the unnecessay task of changing a file three times.
View 3 Replies
Feb 12, 2012
Im trying create a small payroll system using VB.Net windows form applications. The problem im currently facing is when im updating the datagridview. But my update doesnt work. IM using dataset and databinding source. I want to udpate the datagrid view and automatically update the database. [code]
View 1 Replies
Dec 31, 2010
I signed up for a free 30 of Azure. I logged in, created a database. I am able to connect (=Test Connectivity). But that's it. I don't see anyway to create tables, etc. Also how can I connect this db to vb.net (I am using vs.net 2010)?
View 3 Replies
Aug 26, 2011
I want to split this up into 3 side by side tables but have been unsuccessful in any of my attempts. Currently it prints one large table. The reader.Read is performing a really simple query that pulls a few names from a table.
Dim htmlString As String = "<table>"
While reader.Read()
htmlString = htmlString + "<tr><td>" + reader(1) + " " + reader(4) + "</td></tr>"
End While
[code].....
View 6 Replies
Jun 5, 2011
Possible to create new tables in my database at runtime. What components will I have to use?
View 2 Replies
