I am finally ready to move off MSACCESS to SQL. All the advice I've received says to go to SQL Express. I am running VS2008 using VB. I have a lot of experience with MS access. My apps are web based and communicate via web services with the clients. All I need is a good starting point, I want to convert my tables to SQL Express. All documentation I've found has been rather disjointed.
View 1 RepliesI am a high school student and i am teaching myself VB, C# and C++... it is a slow process containing mainly trial and error, looking up things online, and when the time is right asking assistance from people who know more then I.
I am currently creating a VB program that creates a database of questions, and the same or separate database. using them questions it can initiate a quiz that will save results in a different database for each student. I am having difficulties getting the code right for reading the databases, and getting it to move to the next portion of the database for each question... a little more info:
Question # = Primary key (there will not be more then 1 of the same # problem)
Question Type = i am using different integers right now to specify if the question is a T/F, Multiple Choice, Open info Et Cetra.... Question Answer = Correct answer Alt answer (x3) = option to add other answers for multiple choice problems...
I don't know exactly how to get it to read a problem and when clicking a next button on a form to have it go to the next question in the database..
I started coding my first "real" stand-alone desktop application in VB 2008 Express. I was led into believing that using SQL Express Compact Edition was the thing to use for my database since it would reside on each PC (laptops) that I installed the program on. I created all my tables and about 6 forms and all was going well until I came to the point where I need to display a grid showing data from multiple tables using what i think is supposed to be a view. Now the problem is that CE doesnt allow views. Here are my questions:
1. Can I convert my CE database file into an SQL Server Express file?
2. Do I have to re-write all my forms that are using the database? I am planning on creating my SQL Server Express database with the same table names and the same field names, data types, etc.
I use Ms VB 2008 express edition with SQL server express. I want to know what is the reference to be added to make a connection the SQL express database?
View 1 RepliesI have an SQl Connection: Con
con.close
after I close the connection I cannot copy the Sql Express Db because it is still in use but I have CLOSED the connection.
I'm searching a free reporting tool for vb.net express. I only want pdf export and the basic functionality of a reporting tool (grouping, functions, lines, etc). I use postgresql server.What free tools are there out?
View 10 RepliesAnyone know of any free reporting tools - I am using vb.net express, which doesn't have any report features with it.
View 2 RepliesI 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 RepliesI'm at an absolute loss here, I've read so many different things.I just want to add new records to a database I created using SQL Server 2008 with SQL statements in Visual Basic Express 2008. But I can't even connect/get it to recognise the database I created.The database name is 'database.mdf' and is situated in the MSSQL/DATA folder. So far I've read I need to use this code;
Code:
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdf"
Conn.Open()
[code]....
What is the best way to set the default value for 'bit' or boolean data types in SQL express? I am using the data base explorer in VB Express 2008 and the only way I seem to be able to do it is by using ((0)) for false and ((1)) for true.
View 1 RepliesI have an access 2003 database. I have VS2008 installed. I had SQL 2008 installed and with the problems upsizing I dumped SQL2008 and installed SQL2005. I would like to upsize the Access database to an SQL Express database. When I open Access 2007 and open database tool to do an upsize, I get ODBC-Failed.
View 3 RepliesI have just installed VB.NET 2003 and I am trying to manage some databases using SQL Server 2005 Express.When I try accessing the database via the data connection tab, I get the following message.
Quote: You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems.
Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected.You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools.I can not add tables or manage data fields. Does anyone know how to get the patch referred to in the message above? I can not find it via google or this forum.
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]...
For years now I have been using access as my database. But with the SQL server Express version around I have been wondering if it is not better to use this instead of access. Note: I only develop applications for small businesses and a limited set of users. So what do you guys prefer and recommend?
View 2 RepliesI have been using Access 200 as my database of choice with Visual Basic 2008 Express.I am trying to start usingSQL Server Express but having a difficult time with it. All of the instrctions I have tri9ed seem to be written for someone who already knows the answers. Here's my problem.I wrote a program using Access, with one table and five queries and it works fine. Using that program as a baseI created an SQL Server database within Visual basic. Naturally I changed my code to reflect SQL rather then OLEDB.When I try to run the program I get an error message telling me that the database is not registered. When I use the SQL Server Management Studio Expres, it shows my database by give a big message that the database is not registered.
View 3 Repliesanyone know a good free reporting tool compatible with oracle database and visual studio express?
View 3 RepliesI'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 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 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'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
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]...
I have this:
Private m_PerformanceCounter As New _
System.Diagnostics.PerformanceCounter( _
"Processor", "% Processor Time", "_Total")
[code]......
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]....
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
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 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 trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
Is VB Express 2010 slower to compile and run that older versions of VB Express? I've installed it this weekend and it seems a little sluggish on my quad core computer with 1 gig of RAM. I have VB Express 2005 installed for my students at school and it seems to fly just fine. Those school computers are older P4s with 512k of RAM.
View 7 Replies