IDE :: Access Rights To SQL Express Database With Deployment?
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?
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.
My purpose is to disable all toolstripmenuitems at first and then enable them as per the access rights fetched from the database (sql 2000)[code] i've set an integer value to the tag property of all these toolstripmenuitems like 1,11,111,12,2,3 and so on.[code]
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.
I have created a program to log company and programming information for a radio station, on the test machine it works perfectly when deployed the program cannot read from the database. It creates it fine and can write to it without complaint but when opening the program which is supposed to read information from the database the program crashes, if i ask it to continue then it will bring up the form but nothing which is supposed to be populated by access to the database is populated.ed onto the deployment machine and this does not solve the problem.
this is code relating to the issue:frmMain: ' == frmMain_Load == ' ==================
I have to deploy my VB.NET application, and create a new access database with 5 tables, some filled in with values on installation in a specified folder in the C: drive which also needs to be created. I have found using google havent seemed to work for me. I am using Visual Basic 2008 Express Edition, so maybe I need to use a proper copy of Visual Studio 2008 to do this.
So basically I am looking for a way to create a .exe file that will be used to install my program on a user's computer, and create a folder and database with some values on instalation. Could anyone tell me how I can do this or point me in the right direction? EDIT - Also would you be able to answer this question for me. Will the computer that the program will be installed on require visual studio or any other software to run my program?
I am using the following code and a remote server:
[Code]...
The problem is that the acceess rights are not recognized correctly. If I log in manually with the same credentials then the rights are set correctly. Is there something else that need to be set for this towork correctly? I just realized I clicked VS.net instead of VB.net (moderator move this to correct area.)
W7 isn't letting me delete a dll due to access rights (see FAILS HERE). You see, I need to talk to 2 pieces of hardware (both with same dll name). For XP I have been copying the dll at startup (based on my hw type) without issues.
Public Sub SetCorrectHardwareDLL() Dim dll As String = Application.StartupPath & "vxlapi.dll" Dim vec As String = Application.StartupPath & "vxlapi.vector.dll"
I posted this as a bug on MS Connect and am wondering if anybody else can verify the problem: I been beating my head against the wall for about 3 days and I don't think it is my problem.
Desktop computer - Vista 64 bit Portable Computer - Vista 32 bit vb.net 2010 express on both of them
I can not establish a connection to an Access db (either .mdb OR .accdb) on the 64 bit computer. When I try I keep getting a message that says "Format at the initialization string does not conform to specification starting at index 0." (this was typed not copied). (There are screen shots over on Connect).
I can establish a connection to a "Microsoft SQL Server Compact Edition" (.sdf) database on the 64 bit computer.I can estabish a connection to all 3 types on the 32 bit computer (.sdf, .mdb, .accdb).The 'funny' thing is that if I establish the connection on the 32 bit and copy the program directory over to the 64 bit, the prorgam loads and seems to run fine. But the %$# _(%* Wizard will not run on the 64 bit machine. Runs fine on the 32 bit but not on the 64 bit. Of course I make sure that the db's are in the location where the program expects them to be when I run the program on the 64 bit machine.
One final thing, when I am in the progam created on the 32 bit and running on the 64 bit and I try Data->Add New Data Source->Database->Dataset only two of the three connections show up while all 3 show up on the 32 bit machine. Also the connection string is incorrect for the non-sdf connection. It should include
I am trying to read some data from the MBR using CreateFile, but I cannot get it to work without admin rights. The code I am using is like this: hDevice = CreateFile("\.PhysicalDrive0", GENERIC_READ, FILE_SHARE_READ Or FILE_SHARE_WRITE, 0, OPEN_EXISTING, 0, 0) Is it possible to read data from the MBR without admin rights?
Microsoft Access 2007 A Students.mdb database file Visual Basic 2008 Express Edition. I was informed that one can connect to Access files with ease from the Express Edition and most of the tutorials on the internet also show this however I am encountering a problem.
I open Visual Basic 2008 Express Edition Start a new project, with a form, and then click on the Data window, and add new data sources from the Data menu.
I click on database. The problem starts with the data connection. I click New Connection Change the Data Source from Microsoft SQL Server Compact 3.5 to Microsoft Access Database File and instead of then leading back to the other window (as happens on the tutorials for me to browse for the mdb file). Another window pops up asking me to Add a Connection.
It has the data source listed as Access and asks for a Connection String under the misc section. I type in
CODE:
When I click on Ok I get this error: Format of the initialization string does not conform to specification starting at index 0.
The Test connection button works and says connection success whether the Connection String field is empty or not but when I click OK it still gives me the same error. So I can't leave it blank either
So basically I can't connect to the Access database since I can't change the connection type and it won't just let me browse and add the file anyway.
I am brand new to VB. I am using VB 2010 Express. I have a MS Access database and can read & display the data. However, when I enter a line of code to manipulate the data I get a "read only" error message in the project editor. I have checked the file and directory structures from windows and the command prompt. I have even used the "attrib" command to make sure the file was not read only. Then I put the following code in the form and it dispaly the read only message.
Dim infoReader As System.IO.FileInfo infoReader = My.Computer.FileSystem.GetFileInfo("C:zzz-devaccesswhitneywhitney.accdb") If infoReader.IsReadOnly = True Then MsgBox("File is readonly!") End If
I am using the VB 2010 Express DataSource to connect to the MS Access database and not a connection string in the program.
I'm trying to retrieve data from an Access database - a simple one. (Just a single table with one column) My task is to view these records through a 'ListView'. No need to manipulate or anything. Just to retrieve data with a simple SQL statement and display via a ListView.
I am not able to add records in an Access 2007 database using VB 2010 Express Edition. I have read other posts and followed them but still I am not sucessful. I have the connection to the access database as MS Access Database, therefore it has the OLEDB connection (not the Jet 4.0). I am using the project instance in binding the text boxes to the fieldnames in the Access database. Did I miss something? I am also using Windows Vista Ultimate.
I 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 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?
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?
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)
im using vb express 2008 and have just created an application. i am also using windows xp sp2. when i build the application and it creates the .exe file i can only run the .exe successfully on my own system. when i try and send it to other xp systems, or vista it doesnt work!im guessing it needs specific files to run the .exe on other platforms. someone mentioned that there might be an option in vb express to package up the program so it can be installed and used on other pcs ?
I take it that the 2010 Express version doesn't have a package & deployment, it only does CickOnce? That sucks because I don't like the way it installs. Does anybody know of a free package & deployment package?
I have created a resource directory loaded with 10 mp3 files in it and added it to the resources tab. The problem I am having is when the program is compiled and installed, it does not add the resource directory to the hard drive. I know that resources can be added into the applications files in the publish tab but cannot seem to figure out how to get it listed or added in there.I also took each mp3 and set the build action to Embedded Resource... That didnt help much though.The resource directory i want to include in the deployement is in my bin/debug/resources in the solution explorer.
I've developed an application in VB.Net 2010, Express edition. It uses Word Library functionality to access several .docx and .dotx files.Everything works in the development environment. However, after deployment, my application can't find any of the Word document files. I've added them to the project and to the Resources list under the Project Properties tab.The path I'm using to locate the docs and dots is coded in these ways:[code]Both of these statements work in the development environment perfectly. Not at all after deployment as an app.What can I do to make my application find the Word files after deployment?
when publishing a program is it possible to get it to include or copy over a mdb file and can the setup be made into 1 setup file instead of the "Application Files Folder" and "Program name.application"
Only my local dataset updates when adding, deleting or editing records.The Source Database is supposed to update on issuing DataAdapter. Update(dataset )However, when I check my source database after running the operations it remains the same as the original.
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
I have searched i bit but i dident realy fund what i wanted.I just wondering if there is a simply Toolbox-item or something so i can add MS Access databases into visual basic. if that it possibly ?
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?