IDE :: Using SQLExpress Server In A VB Project 2010 B2?
Jan 5, 2010
Visual Basic Project VB 2010 B2 does not allow you to select the SQL server without specifying a local file attachment while Visual Web Developer VWD 2010 B2 does give you the option to specify either.The Enviroment VB2010 B2, OS VISTA Business, SQL2008 Express SP1 with SQL Server Management Studio.
1) In order to access the SQL server enable the TCP/IP, NamedPipes and SQLbrowser on the SQL Server.
2) The VB Project requires "imports system.data.sqlclient"
3) Using SQL Server Management Studio or VBcode in the VB Project create a Server DataBase called "dbName"
4) Using SQL Server Management Studio or VBcode in the VB Project create a Server DataTables
5) The following code updates the SQL server DataBase name dbName from the projects DataSet.
Private
Sub updateDBase(ByVal dbName As String, ByRef aDS As DataSet)
'CODE to access SQL database directly
'Before an Update sqlCommandBuilder creates
[code]....
View 3 Replies
ADVERTISEMENT
Oct 23, 2009
I have created a windows exe project called MyCalculator,I have added setup deployment project.I have also added a class project and added a class called Sqlclass, code in this class is stated below
Public Class Sqlclass
Public Sub New()
Dim myProcess As New Process
Dim SqlArguments As String
where to call the above class in deployment project so sql server installed automatically using the above parameter.check the above weather it is correct. After installation will the folder sqlexpress2005 remains?
View 2 Replies
Oct 19, 2011
i'm using windows 7 home . and i want start sql server 2005 (SQLEXPRESS) with VB2005. but i can't find command about this thing
View 1 Replies
Feb 11, 2011
My app currently uses both SQLExpress and SQLCE, depending on the choice of the user.In my database class I have non query command objects for the CE connection and non query command objects for the express version.
Essentially, this is duplicating code as Parameters.Add etc. has to be repeated on both objects.Is there a way just to add do it once on a common object?
Dim MyConnection As SqlConnection
Dim MyCEConnection As SqlCeConnection
Dim MyNQCommand As SqlCommand
Dim MyCENQCommand As SqlCeCommand
View 2 Replies
Jul 15, 2011
Iam using this code to add text to sql 2005 table
Dim SavInto
As
New SqlClient.SqlCommand
[Code].....
now how to add date from DateTimePicker1 to sqlExpress in vb.net2005 using this code?
View 1 Replies
Aug 26, 2010
I'm so glad I found this forum. I have been trying for days to connect VB.NET Express to SQLExpress using a very simple, one-table database just for testing with no luck. Then I found this forum and the FAQ and used the template for binding a VB Form to SQL and with a few slight modifications and had success.
I'm connecting using the default instance of SQL (no user instance) and after substituting the the "user Id=" and "password=" section of the connection string with "Integrated Security=SSPI" I was finally able to get data returned from SQL server into VB in a Grid Control.
Now for my question. It's a general thing. Yes, I got that to work but in a complete database scenario, would the connection to the database be done in a Public Sub and left open throughout the duration of the GUI interface (passing in the user ID and password as needed) ..until the user logs off? In other words, the template example closes the connecttion immediately after retrieving the data from the database - and I realize this is an example of simply connecting. So, What is the usual scenario (in the real world for connecting and keeping that connection open for the duration of a user session. Where in the VB app should the connection string really be placed and the connection.(close) be placed?I'm not looking for an extremely detailed answer, just an "in general" scenario.I tend to dive in head first and so, I truly look for answers elsewhere before posting a question but haven't really found an answer to this exact question.
View 8 Replies
Aug 20, 2010
I have several programs I have written for my music studio/production company. Many dealing with inventory, customer DB etc. All of my programs are in VB6 and I have started to convert them all to VB.NET. I am getting proficient with VB.NET and connecting to DB using the very simple and generic connection strings, Example:
dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:/develop/Customer Tracking/resource.mdb"
con.ConnectionString = dbProvider & dbSource
[Code]....
As you can see I am using a basic MSAccess DB and I want to get away from this and start using SQLExpress,
connect to a standard SQLExpress DB? (when I loaded SQLExpress I took the defaults...)
View 1 Replies
Jun 29, 2011
I'm setting up a home database. I'm using sqlexpress. I want to use a vb.net programme to manage the database and currently added the database to my data sources. How would I create data for the tables? ( Tables are already set up )
[Code]...
View 1 Replies
Aug 6, 2008
I'm trying to export a table called material from a sqlexpress 2005 .mdf file called mydatabase to a csv file programatically in vb2008. i was looking at bcp and the shell command to call it, but simply can't get it to work - i'm calling it like so:
Shell("bcp mydatabase..material out 'c: est.txt' -c -T -S .SQLExpress")is there a way to do this without the shell? i would think it would be a little more professional looking for the app as a whole...
View 2 Replies
Jun 2, 2009
I have done this to save it:
Protected Sub AddClient_Click(ByVal sender As Object, ByVal e As EventArgs) Handles AddClient.Click
[code].....
View 5 Replies
Aug 9, 2008
is there any way to attach a sql mdf by filename but actually make the database name something else?
the problem i'm having is that my connection string attaches the database just fine, but it gives the database a name of it's full path on the hard drive when i pull it up in SSMSE. ie. "c:program filesmy programmy database.mdf" is shown as the name when i do a sqlcmd and issue a select name from sys.databases
the snag is being hit due to the fact that i'm trying to do a "bcp in" and because a: there are spaces in the database name, and b: there's the .mdf extension also added to the database name that when i run my bcp in command it errors out, even if i use the -q option of bcp.
if i start SSMSE and right click the database and rename it, bcp works great - so my question is, how do i correctly format my connection string to attach to c:program filesmy programmy database.mdf, yet have it attach the database as "mydatabase" for use in bcp statements?
i've been to connectionstrings.com and they only cover the standard connection strings
in summary - i want to attach an mdf file programmatically and specify the name that ssmse see's it as....
View 1 Replies
May 28, 2010
Has anyone else had issues with Visual Basic 2010?My visual basic program has been running fine for months but recently every time I try and load a project (any project) the program freezes, then I have to close it down and reload, every time I load Visual basic for the second time I get the following error:
HTML
An error was encountered while opening associated documents the last time this solution was loaded. Document load is being skipped during this solution load in order to avoid that error.Plus when trying to run a project in debug it takes ages to load (around 5 minutes) this has only started happening recently, projects were loading in seconds.
View 9 Replies
Jun 24, 2008
I'm currently designing a client application that connects to a SQL Server 2005 database. My app is being used to display data, allows users to run reports and stats on the data. It is being developed using VB2008. Within my VB2008 project, the connection string to the DB is made via SQLEXPRESS.
The road block that I'm running into right now is that it only allows me to connect to a local DB file (.mdf) only. I tried to connect to a different DB file on a server within the same network domain, and it generated the following error:
"The file "U:Data.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file U:Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." (where U: is a mapped network drive).
Below is the actual connection string in my code:
"SERVER=.SQLEXPRESS;AttachDbFilename=U:Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
The intention is to have the DB reside on a server, where there is another application that runs as a service to collect the data and then populates this DB. Then my app would just connect to the database, and allows users to run reports based on the data in the DB.
I heard that this is the limitation of SQLEXPRESS: it will not allow connection to a remote database. This is true? If so, is there anyway that I can get around this limitation?
The main reason that I chose SQLEXPRESS in the first place is that because of the licensing issue. The company that I work for do not want to make the users of our software app have to purchase additional license for the full-blown SQL Server Enterprise edition. I also heard that SQL Server Enterprise edition does allow you to connect to a remote DB (.mdf) file.
View 7 Replies
May 8, 2010
I am trying to follow an example in the VB 2010 book and the author has set up the local server using a named instance of SQLEXPRESS and uses mixed mode authentication with a sa login and wrox as the password the code is then
[code]...
I am using the Express server initially set up for windows authentication (pubs is one of 6 databases on it) but no matter what I seem to try I can not connect
[code]...
View 1 Replies
Apr 12, 2010
I am trying to display a list of databases contained in sqlexpress, in a listview. my current code reads:
[Code]...
This will show up as column headers, but I can't get them to show in only one column so that I can have the user select the database that they would like to work with.
View 3 Replies
Sep 30, 2011
A colleague has written a useful tool. He wrote it as a standalone tool, but it works even better as an includable dll, though it needs a bit of other functionality for it to be a really good drop-in component. What I am wondering is whether a project can be compiled as both an exe and as a dll?
There are alternatives, such as having a dll version and an exe version, since the dll version needs to include a few different methods that the exe version doesn't need, but this alternative sucks, since it would mean changing two sets of code.
Another alternative is to build the dll, then change the exe to be a project that references the dll....and does nothing other than calling one method in the dll. That kind of sucks, too, but not as bad.
I want to be able to use his module in some of my programs, and it really should be built as a component rather than a standalone app, but I want to know whether there are other options that I haven't considered.
View 2 Replies
Jun 21, 2010
i just want to conect my project to sql server database.
View 11 Replies
Jan 6, 2011
I need a simple embedded database for a relatively small database size (< 100MB, but in most cases < 20MB) and maximum 1-2 concurrent users/connections on average. It must be able to protect/encrypt it's data with a login.
View 4 Replies
Aug 11, 2011
i was create the .exe of vb.net project with sql server in backend. when i install it any other computer that time it is not connect to the data base. whta i do for that.
View 1 Replies
Jul 27, 2010
So I want to test one of my Functions in my Web Project, but it's not actually connected to anything in the project yet (someone else is working on that part). The Function takes in an "ID" field, goes off and does some queries and gets some data, performs some calculations on it, and then writes a bunch of lines to a FileStream and returns that stream. I pretty much just want to test it by having it write the file to my own computer locally, and working with that file directory after the Function completes.
So my question is mainly:
1) How do I call this Function just for testing purposes so I can test all the queries/calculations/File writes, etc without it being connected to another part of the application just yet.
2) How can I change the 'Return fs' for the FileStream to write to my own computer locally to view the file that has been written.
View 2 Replies
Sep 13, 2009
i had finish my vb.net project. But i dun know how to upload in server company .
View 1 Replies
Nov 22, 2010
I have a VB.NET project in Visual Studio 2010 for an Excel Add-In.I use the "My" namespace,and in general it seems that the "My Project" folder contains configuration information about the project.My problem is that I need to change the name of this folder, because my version manager system won't accept spaces in file or folder names.Edit: There is a hacky way to do it, by renaming the folder and changing all references in the .vbproj file.However, the may work for a command line generation, but it won't work the next time the project will be opened in Visual Studio. The IDE will create a new "My Project" folder, and complain that it can't find the settings in it.
View 3 Replies
Mar 30, 2010
I have recently learnt vs '05 and am creating a project in vb.net '05.my question is-During project development, we connect it to MS SqL server 2005 express installed on my system and it works.( I use add datasource wizard,add sqldataadapter,add gridview control,generate dataset,connect dataset to gridview method). But after the project is finished and we create its executable, the project will be run on adiffrent machine with a different server name and hence a new connection string will be required.
How can i make my project detect server details and connect to it, at runtime ? because the user is only expexted to start the server and open my application.the app must connect to the new server on its own. If anybody has an answer or if you know some resource where i can find it, please post here. Any suggestions are welcome.
View 1 Replies
Mar 7, 2010
I have an ASP.NET project which is a front-end to a database. In addition to the large tables, the DB contains a few small tables to help normalize the larger tables with common values. I have a VB.NET project which loads the smaller tables into memory, using "Shared" (i.e., "static" in C#) member variables, and uses them. I have a call to load the tables in Global.asax - Application_Start. This works for a while. That is, Application_Start runs when I first run my project, loads the cached values, and will correctly keep them in memory for a while.
What I'm seeing (when running my project via Visual Studio 2008 Debugger, hosted locally) is:
A) The Application_Start code will run more than once. Not in a row, but after the user has navigated to some other pages, I'll see (my breakpoint in) another call to initialize the cache, coming form Application_Start. Is it expected?
B) The "Shared" variable that was set to True when the cache was initialized is now False again (which should only happen when the class is first loaded). Similarly, all the data that was chached is no longer present. That is, it looks like VB is unloading all the Shared members. Is this expected?
View 1 Replies
Dec 20, 2011
i am trying to publish a vb.net project that has is connected to a database. the project can be published and installed and runs fine without the data base part. i get following error message: System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
i assume that it simply cant find the database. where do i need to adjust the database file settings to make this work.
View 3 Replies
Jun 3, 2010
I have made a project in vb.net 2008 and used sql server 2008 for database and how to make the setup that need to be deploy on those system which do not have sql server on their system .
View 9 Replies
Nov 24, 2010
Tell me if I want to run a project that is created in vb.net 2010 and uses a backend SQL Server 2005.........how many changes can be done in a project to run on another computer....?what connection string I can write for it.......?which software do I need to install on the other computer to run a project on it.......
View 1 Replies
Nov 1, 2010
In asp.net web site project , i have created a .vb class file in App_Code folder. In that class i have created a Shared SubRoutine , in that code i want to use Server.Transfer method to transfer control to another web page .But Server property is unavailable in that code. Where is problem ? can anyone explain this.
View 1 Replies
Jun 6, 2012
The situation: when i build my project (or publish) Visual Basic 2010 makes and exe and a couple ddl files. when i run the project with the .exe and the other files the program works perfectly.
My problem: I want to share it with friends and it is just a verry little program ( a n internet radio) so i want it to be 1 .exe with out any other instalation needed so i can easly share it to anyone who wants it. when i make an even smaller program and Debud->build it, it is only 1 exe and no instalation needed. so is there a way to make my program to 1 exe only?
View 4 Replies
Feb 29, 2012
An error that arises when I take a vb project Visual Studio 2010 that works on my local machine to a server. How precisely would I work around it?
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Source Error:
Line 24: ASP.NET to identify an incoming user.
Line 25: -->
Line 26: <authentication mode="Windows" />
Line 27: <!--
Line 28: The <customErrors> section enables configuration
View 1 Replies