I have a copy Oracle 11g which is now fully installed. Will it work with Visual Basic Express 2008 or just Visual Studio 2008 Professional? I have both Visual Basic Express 2008 and Visual Studio 2008 Professional. I really would like to know if it works with Visual Basic Express 2008.
View 2 Repliesanyone know a good free reporting tool compatible with oracle database and visual studio express?
View 3 Replieswill SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 RepliesIs there a way to use VB 2008 Express to connect to Oracle 11? When I go to add new data source I dont see anything for ODBC
View 2 RepliesI was trying to use WebRequest request = WebRequest.Create[URL]..But get an error message! I am trying to use the WebRequest .NET framework class [URL]..How can I enable .NET? Is something wrong with my installation?
View 1 RepliesI am using VB Express 2005 because the machines my applications are running on are more likely to have .NET 2.0 installed. Is there a way to use VB Express 2008 but stop the client asking for .NET 3 3.5 (especially as the functions I am using are pretty basic!)?
View 2 RepliesI'm just starting out with VB and have downloaded and installed VB Express 2008. I'm researching and trying to wrap my head around programming in VB before I start working on any projects. I have a little bit of experience with ASP Classic so some of the syntax looks familiar, but I can't get a handle on database integration. Let's say I am creating an address book. Each installation is a stand-alone (no network connectivity). How are databases used in this situation? Are they built using VB Express and packaged into the installer or can you create them separately (using either Access or MySQL) and then package them into the installer? What is needed to read and write to these databases? Are there extra bits of software that need to be packaged into the installer to allow access to the databases?
What if this application does connect to a centralized database (let's say a MySQL or Access database on a web server). Is the connectivity handled the same way? Sorry for so many questions, but I just can find the answers I'm looking for when searching. I'm not necessarily looking for the actual code to do this, just an explanation of how it's possible (or even a link to some examples/tutorials).
I installed VB Express 2008 on my machine and it went without a redistributable file. It got download during the install. Anyone knows where I can download the redsitributable file from, so I can give it to my students?
View 2 RepliesI recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and
2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
For instance, I was trying to use
WebRequest request = WebRequest.Create("http://www.contoso.com/");
But get an error message!I am trying to use the WebRequest .NET framework class [URL] How can I enable .NET? Is something wrong with my installation?
I have written a program in VB Express 2008 and published it so I can install on another PC. When trying to install on another PC I get the error message "Microsoft.VisualBasic.PowerPack.Vs Version 9.0.0.0 be installed in the Global Cache (GAC) first" I have already installed the .NET 3.5 and the PowerPack but I still get the message.
View 2 RepliesIt says I must use only SQL or Access. That is SQLExpress doesn't work. The test connection does work. Trying to do a quick demo project before I spend big bucks. I cannot get my Access 2003 to register so only have 34 uses left.
View 2 RepliesI have worked with Visual Basic in the past, but never using it with Excel
View 3 RepliesI have downloaded VB express 2008 from Microsoft site on one computer. This computer has access to a wireless internect connection so it was quick to install vb express.
I want to install VB express 2008 on another computer which has access to a dialup internet connection and being so slow i am unable to download it. Is it possible to copy VBE installed on one computer to other computer through a USB drive.
using Vb Net 2008 with SQL Express 2008 R2 in windows forms. that being said, I have a syntax problem in this form, form has 2 texbox an a datagridview and also the 4 components DataSet. BindingSource. TableAdapter, BindingNavigator. When I filter by LastName no problem it work fine (it's a String) but when I try to filter by CustomerID (it's alphanumeric) I get an error "Invalid character" here is part of my code: Private Sub surnameFilterTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles surnameFilterTextBox.TextChanged
[Code]...
1.Establishing a connection to a database(preferably one that is inherit within the project and can travel with it)
2. Setting the correct references to the database ( I tried connecting via JET with windows 7 and I get an error that I cannot use JET)
3. Query the database (Access) with SQL, and return those results to a recordset.
4. Loop through the recordset.
5. close the database connection
6. Open recordset and write data to table.
[Code]...
I got the code from ALLAPI but it gives me errors of declarations that have changed in this version of VB, i tried to update the code but...
Public Class Form1
Const VK_H = 72
Const VK_E = 69
[code].....
I'm developing a windows form app in visual studio 2008 express. I'm usin a sql compact 3.5 database on it through the program, several changes are made to database data, and so, i have on form1_closing event, a code to save the dataset back to database, something like:
Private Sub Form1_Closing(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
[CODE]................
But when i run my program on the debugger, the changes i mkae, don't get saved, are lost...is this a charecteristic of debugger, or is my "saving code" wrong?
I already built the program, and the data is not being saved. how to saving the data ? by the way, all changes to dataset are made something like this:
[code]:......................
I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:
[Code]...
I 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 create a new Windows Forms application and add an AboutBox form which is built-in into Visual Studio. I add a button to Form1 to show the AboutBox when clicked.The AboutBox form has a label with the text "Version" on it. The following code is supposed to add the application's version to that label at run-time:
Me.LabelVersion.Text = String.Format("Version {0}", My.Application.Info.Version.ToString)When the application version is changed in the Publish tab of the My Project form to 2-0-3-6, the version on the AboutBox at run-time stays at 1.0.0.0 (of course after rebuilding).
Even when the application is published to the desktop, it still does not work. It does, however, reflect the correct version number in the title of a subfolder in the Applications folder that is created when the application is published.
I have been able to use my.resources perfectly, no problems at all. all of a sudden, i try to use resource (i have done EVERYTHING EXACTLY the same as the way i have been using for the last 1 and a half years) and i get an error saying the file does not exist. its there, i only need to type my.resources.s and it already selected the resource i want. it says the file doesn't exist. why? also, the resource is called settings.dat. could that be the problem, don't think it is. i even tried a picture, but it still says the file doesn't exist.
It says: Could not find file 'C:Users[username removed]DocumentsVisual Studio 2008ProjectsdiskSaverdiskSaverinDebugSystem.Byte[]'.
I worked out a way around it (i worked out how to use my.settings in stead), but i haven't worked out why my.resources won't work.
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
I will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
I have a Visual Basic 2008 Express Edition application that operates as a front end for iSeries V6r1. The application was developed on a windows 7 machine. Users load the application from a shared folder on a server. Currently, there are 2 Vista, 3 windows 7 and 4 XP users. All had no problem in loading application, all users except 3 of 4 XP users can run the application with no problems. However, 3 of the XP users receive the following error message when they perform any action that tries to connect to the iSeries:
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
All 4 XP users are on same service pack
Im writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
I need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
I�m able to solve points 1 and 2. how to code point 3?
I need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
I am planning to make a setup wizard for my program through visual studio 2010. My program uses SQL databases, and I just wanted to know if there is a way to check if SQL is installed through the setup wizard and if not install it. Or at the very least provide a link to where they can get an easy setup file.
View 3 Replies