Create A SQL Server Database Using Database Explorer?
Nov 18, 2009My question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesMy question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesI am using VS2010 and have been watching and learning from Beth Massi's great videos. I have built some test apps using her example of (under Server Explorer) - right clicking on "Data Connections" and selecting "Create New SQL Server Database, and in the server name just like she does, I type ".SQLEXPRESS", fill in the "New Database Name" and fill in my fields, build my tables, build a simple little windows form app. add new data source, etc. and everything works great. Then I try the "Add Connection" option again under Server Explorer and use the default (for me) of "Microsoft SQL Server Database file(Sql Client)", fill in a database file name (it creates a new one for me), "Test Connection" works, build my tables etc, and then build a simple little windows form app. add new data source and everything is great once again. Except I am not sure what is actually happening between these two options. Under the "Create New SQL Server Database option I see (in Server Explorer) a "myapp.dbo". Where is the actual database file? Under the "Add Connection" I see a "myapp.mdf" file in the Server Explorer. Also what happens when I "Publish" (deploy) my app? When I look under application files under Publish, I see the .mdf file listed as "Required" under the "Add Connection" option, but with the "Create New SQL Server Database" I don't see any database files listed? What is the difference between these two ways of creating a database for a VB Windows Forms Application?
View 3 RepliesI am using Server Explorer in VS2010 to connect to an Access 2007 .accdb database. I started getting 'No error message available, result code:E_UNEXPECTED (0x8000FFFF). However, my program runs from Debug and accesses the data.My connection string is Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:MypathDatabase1.accdb. I exited my project and created a new project and tried to add a connection. I could not connect to Access 2007 or Access 2003 databases (.mdb).I had to exit VS2010 and start it again before it started working again.
View 3 RepliesThe above is more or less the complete question. I have created a table in the VB 2010 Database Explorer but I cannot for the life of me work out how I can get this copied or created into the underlying server. It is not appearing in the underyling serverand when I run the code of course I ge "invalid object <tablename>" I have data as well in the table that appears in Database Explorer. I think I have missed something fundamental in my overall conception of using VB 2010 Express with SQL Server Express in that I don't know if I have a local copy (that isn't then mirrored on the server), or what (the ____ have I got)? An article that explains the overall relation of Database Explorer to the underyling Server would be great as well
View 8 RepliesI'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
create an SQL Server (express) database (.mdf).
most of the example in the walkthrough make use of the pre made northwind database(.mdf)
i will use the database that i will make to get connected from my application. the connection would client-server and what i have noticed, that this is possible if your database is an SQL version with extension filename of .mdf.
Or if its possible to create this database just using the Visual Studio 2008 Pro(90-day trial)
Using Visual Studio .NET 2008 or 2005, is there a way to automatically generate properties for each column in an SQL Server database table? I am assuming other code-generation software exists that will do this. I know with Visio I can connect to my database and it will generate diagrams by table, this would be similar to that.
View 6 RepliesI have Visual Basic 2010 Express and SQL Server 2008 R2 (not Express) installed on my Windows 7 machine. In Visual Studio, I am attempting to create a Data Connection to a database in SQL server. Server Mgmt Studio is not running. When I attempt to add a connection in Database Explorer, to the AdventureWorks _Data database, I get the message "This file is in use. Enter an new name or close the file that's open in another program." There are no programs running except VB, except maybe for the SQL Server engine running the background.Please note that I can open and access tables within a database in code
within Visual Studio, I just can't add a connection in Database Explorer.Am I doing something wrong? I've been very frustrated on this issue for a long time
I was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference?
View 2 RepliesI have a problem with attaching sql server database to an installer file.
View 1 RepliesWe would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 RepliesI've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
View 16 RepliesI am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It should also automatically load available servers and domain login by default.
View 11 RepliesI recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
I work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.
View 1 RepliesI have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesI have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
View 2 RepliesIS there any chance that I can connect to AD using database explorer solution in VS 2010 Pro.I know I can add that by code but it will be so easier if I can use database explorer.
View 2 RepliesIs there a database explorer in VB 2010? if so, where is it?
View 2 RepliesWhen I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
I am creating a Reporting program in VB 2008. The first issue that I want to correct is in VB 2008 there is a Database Explorer. But whenever I try to create a new Data Connection in the Database Explorer it does not give me the option to connect to Oracle. How do I get my Oracle Database in the Database Explorer tab. All it gives my options for are Microsoft based database applications.
View 3 RepliesSo Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
How do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
I create my database with SQL server management 2005 Express and i must connect my application elaborated with VB.NET2008 express when i go Tools-connect to database a window appeeas;it demands to set database name But the problem is: i create my database with windows authentification and i don't know the path of the database
View 1 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI've been messing around trying to get an INSERT statement to work, and because of this, it has created lots of records in my database that I dont need or want.
The problem is, when I open up the table by right clicking on it in the database explorer and selecting "Show table data", I click on the record I want to delete and the following error comes up in a message box[code]...