XCopy Deployment Of A VB Express App Which Uses A SQL Server Express Database?
May 13, 2005
It's probably just a case of me not looking in the right place or not seeing the obvious, but does anyone know if a machine with just version 2.0 of the .NET Framework should be able to run a VB.NET Express application which accesses a SQL Server Express database file? Or is there an additional requirement for a non-development machine to have some kind of SQL Server Express runtime component in addition to the 2.0 Framework?It seems to be counterintuitive to expect that a VB.NET application would be able to access any kind of SQL Server data without having some kind of SQL Server host component (Express or otherwise) installed. But then again, it seems just as counterintuitive that Microsoft would require the download and installation of the new framework as well as a separate database runtime in order for the average user to run an application with accesses a local SQL Server Express database.To me, it runs contrary to the whole concept of XCopy deployment to require more than just the application's files and .NET Framework for an application to run properly. But nothing I've read so far explicitly indicates that a user would require anything more than the app files and the framework to run an application which accesses SQL Server Express data. But...I can't get any VB Express applications which uses a SQL Server Express databases to run on any machine that doesn't have SQL Server Express installed.What am I missing?(Apologies if this isn't the right group to post this in.
View 3 Replies
ADVERTISEMENT
Nov 1, 2011
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 Replies
Feb 29, 2012
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.
View 1 Replies
Jun 16, 2011
I developed a windows application that uses a SQL Express database. I created a Setup project as well. When I install the application, the database is deployed with read only rights causing errors in the program. Of course, I manually change the rights to Full Control and the application works great. How do I get the database to deploy with Full Control?
View 11 Replies
Sep 28, 2011
I've developed a database application in VB.Net Express 2010 and am having difficulty deploying it. The only deployment method available to me using the Express version is OneClick deployment. I can't figure out how to include the Access database file in the package.
View 2 Replies
Feb 29, 2012
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 3 Replies
Jan 21, 2011
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.
[Code]...
View 13 Replies
Feb 29, 2012
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.
[Code]...
View 2 Replies
Dec 31, 2007
In the beta version of Beta2 of Visual Studio Professional, when I choose add new connections, I can select a I can select a " SQL Server (SQL Client)" datasource, which works great with my SQL Server Express DB running on the local machine.
In VB2008 Express, though, I can't select a "SQL Server" in the datasource dropdown. I can only try to connect to a Microsoft SQL Server Database File.
When I actually try to connect using the .mdf file that is being managed by my local SQL Server, I get an connection error -- can't make connection to the server (and the usual message about enabling remote connections".
View 6 Replies
Mar 31, 2011
[code]...
I get 'sqlconnection' is ambiguous in the name space 'system.data.sqlclient' What is this confusion? What I am trying is to connect a .mdf (sql server express) database file using vb.net to store and retrieve some date from a table Wot am i missing? I see various examples for this but none working with me? Am i supposed to add some references?
View 9 Replies
Dec 7, 2009
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)
View 3 Replies
Sep 17, 2011
I want to use a connetction string for connect a databse in sql server express by vb.net? My code is : Cn1.ConnectionString ="Data Source=.SQLEXPRESS;Integrated Security=True;Connect Timeout=30;User Instance=True" but i when open then connection i see this error Cannot open user default database. Login failed. Login failed for user 'Shahab-PCShahab'.
View 6 Replies
Apr 14, 2009
I'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]....
View 3 Replies
Jun 11, 2010
I have an app developed with VB .NET as front end and SQL Server Express 2005 Database. Now I want to install it on a server so that other client PCs can access it. My gquestions are:
1. Do I have to install SQL Server Express on the Server before I can install my database on it?
2. Do I have to install Visual studio on the clients before I can install the front end?
3. Is there any online walk-through/tutorial on how to accomplish this (ie, installing a database app on a server and connecting the clients)?
View 4 Replies
Dec 10, 2008
How can I deploy and reference a stand-alone SQL Server 2008 Express database with my vb.net 2008 Express app ?
View 8 Replies
Jun 2, 2006
I have a VB.NET 2005 WinForm app that accesses a SQL Sever Express database.I use the Microsoft Practices Enterprise library to handle my data access with the following appearing in my app.config file.
View 7 Replies
Oct 12, 2010
i make a connection with SQL server 2005 database using Wizard in Express Edition 2008,I have got data in my text field using dataset , but now I want to execute query for insert, select and update but I don't know my connection vaiable and how to execute query and get data .what kind of connection is this Adodb or oledb etc
View 5 Replies
Apr 5, 2012
how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?
View 5 Replies
Apr 10, 2012
I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
View 5 Replies
May 24, 2011
Visual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 Replies
Sep 5, 2009
I'm trying to connect from VB 2008 Express Edition to a database in an instance of SQL Server 2008. Both, VB and SQL Server are running on the same machine. From a VB project, when I try to define a new Data Connection I find just three Data sources available: [Code] I selected the last one but when I browse for the mdf file I cannot select it because it tells me that the file is in USE. I have stopped all the services but still I'm not able to link the database file.
Two questions: 1. Is there a way to connect to the SQL Server Instance and from there to select the desired database? 2. How to connect using the Database file.
View 2 Replies
Aug 15, 2011
i am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 Replies
Aug 4, 2011
im decide to develop Vb .net Application With Sql server Express 2008 ,but microsoft says they limit 4 GB Sze for per DB! So im developing my app for Single user Desktop pc , so what i do when the DB reached to the Maximum size? when the db size reached to maximum size , is it Good thing to create new DB and allow my vb.net application to work with both DB s ?
View 4 Replies
Sep 2, 2009
I use AES encryption in my vb.net 2008 windows forms apps to ....
1. Store user passwords in sql server express database in encrypted form
2. decrypt the encrypted Sql server express connection string password on the fly when connecting to SQl Server over a vpn or direct to web based sql server database
3. decrypt the encrypted ftp site password on the fly when my application connects to my ftp site to upload client's database backups
The issue I have is that the secret key for the encryption / decryption is hard coded within the encryption/decryption functions. So anybody who decompiled my application would be able to generate the same encryption, as they would have the encryption secret key How can you hide the encryption secret key so that if anybody decompiled my app they could not reproduce the decryption function
View 1 Replies
May 10, 2010
The 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 Replies
Feb 26, 2010
I'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 Replies
Jan 16, 2010
what is XCOPY deployment? Is there any thrid party software needed for the XCOPY Deployment?
View 39 Replies
Nov 15, 2010
I have an application in Visual Basic 2008 express that I want to deploy. It has MS Access DB tables and some queries. How can I put this together in the deployment?
View 1 Replies
Mar 12, 2009
I've developed a small application using VB 2008 express and I am trying to deploy it for the first time.I have done this using the options with VB 2008 express and installed onto another PC. I find it has installed using what is termed a user instance which I understand comes with some limitations.I want the option for the application and data base to be multi user in the future. I want to be able to connect to it from Business intelligence for reporting purposes (there is no report viewer control in VB2008 express) and ideally I would like to be able to back it up using SSMS.Does anyone know what the options for deployement are and how to deploy using a "traditional" instance rather than a "user" instance?
View 1 Replies
Dec 1, 2009
I've seen some similar threads on here but no resolution. I have an app written with VB Express 2008 which uses SQL Compact Edition 3.5, the DB that comes shipped with VB Express 2008.
When I publish, I can run the app on my machine (development machine).
When I try and install on another machine, it is giving this error:
object: sql sever compact ADO.NET Data Provider Method: Void ProcessResults(Int32)
[Code]...
View 4 Replies
