How To Start MS Sql Server 2008 Installed With Vb Express 2008
Nov 28, 2009
I 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.
I 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?
I 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!)?
I'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?
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.
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.
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db connecting to SQL Server 3.5 compact db and connecting to SQL Server db file.
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
Here 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.
I 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.
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here 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.
I am complete newbie to VB express. I have created a simple windows form that opens programs using menus and so on.Works great using the Process.Start on windows apps (word, excel, etc.) but I have some very old programs that run in DOS I am also trying to open that do not work when using the Process.Start method.
I am able to get the command prompt box to open up and in the title bar it shows the path of the .exe program I want to open but the actual program is not opening.
I am trying to deploy an application that uses SMO on a workstation without SQL Server installed on it. The instance the app is connecting to is SQL Server 2008. The application is failing with:Could not load file or assembly 'Microsoft.SqlServer.Replication, Version 10.0.0.0, Culture=neutral,PublicKeyToken=89845cdc8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.
The assembly in question is in the same path as my application as well as system32. I am running this on a Windows 7 64 bit box. I have run SQL Native Client, CLR, and SMO MSIs from the 2008 SMO redist download page.This app worked fine when connecting to SQL Server 2005.
I'm not sure if I should post this on this thread or in the Database section but I'm using VB2010 so I posted this unto this. I have a fresh installed VB2010 and a Microsoft SQL Server 2008 R2.And I can't seem to connect my database to VS2010. I've been searching the net but I can't seem to find the solution to my problem.
I have attached my SQL Server Configuration and the error message I got in VS2010.
The code below checks whether IE enhanced security configuration installed or not on a server. this works for server 2003 but doesnt work on 2008 r2. it returns IE enhanced security configuration installed response when i know and have checked that its not.[code]...
how I can start a program with Visual Basic Express Edition 2008? I mean do you have any code I can use as a base to start another program? If that made sense.
I'm, following the tutorial on creating your first program in Visual basic. I'm instructed to start a new project, and select windows form application. When I hit okay I get the following error:"Could not load file or assembly 'Microsoft.Build.Engine, Version 3.5.0.0, culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified."
I have a windows 7 computer with vb 2008 express on it. it works really well, except only one thing. when I try to debug an application ( usually windows forms), it produces a run-time error saying: Error while trying to run project; unable to start debugging.
I 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.
I am new to VB 2008 and ADO .net and Sql Server 2008 (Management Studio). I am working through a book about professional vb programming. I have downloaded the sample Northwind database and have connected and used this database without any problem. I wanted to connect to my database that I created but to no avail.
I'm having access problems. It appears that the permissions are granted for users to select, update, but, in running the program, debug stops at the open line and can't access the database. The connection string is: "Data source=.SQLEXPRESS;AttachDbFilename=C:Program Files (x86)Microsoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATACustomer1.mdf;Integrated Security=True;User Instance=True". The error message is: Access is denied. By the way, these are all express editions.
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.
I want to connect visual basic 2008 or 2005 to sql server using connection string or something elsejust like in VB6 I'm using a connection string but here at VB express i dont know =(Is there a way just like in asp.net to have connection string using?
I'm trying to make a connection to SQL Server 2008 express Using this code
Dim Ordr As String = "Select * from Orders" Dim con As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _ "Initial Catalog=Orders") Dim com As New SqlCommand(Orders, con)
[code]....
I get this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server