I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 Replies
Please how can i publish an application created in vb.net along with a database which i created in SQL Management Studio?
View 4 Replieswhere that i find the commands for make an silent install of SQL Server Management Studio Express.The same thing i did with sql express 2005:
infoSQLExpress.FileName = DirectoryGet + "appsSQLEX05.EXE"
infoSQLExpress.Arguments = "/qb INSTANCENAME=" + txtInstanzname.Text _
+ " ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity" _[code]......
How do I transfer data from Excel 2007 into Microsoft SQL Server Management Studio Express as shown below? I try copy and list of data in excel as shown in the screenshot.. But when I paste in Microsoft SQL Server Management Studio Express.. Only the first result is past inside..
View 2 RepliesHow can I get the output data of sql procedure from SQL Server to my asp.net[vb.net] page dropdown list?<asp:DropDownList ID="DdLocation"></asp:DropDownList>
View 1 RepliesI'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username"
Here's the code .
Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles btnupdate.Click
Dim connstring = New SqlClient.SqlConnection("Data Source=MISD-
[CODE]...
Using Vb.net 2003 Asp.net 1.1 Sql Server2005 Express Vs.Net 7.1. I have Vb.Net Standard and there is no Web Set Up with this version. I have FTP things along time ago but not asp just basic stuff. I have read about xcopy,copy project, I have XP and IE that I can FTP from. I also have to put a database up from SQL Managment Studio. I need to know HOW WHAT WHEN WHERE on how to do this right. This is an interactive site that I made, very similar to a Forum like this site. Do I just upload the dll.
I don't want my source code available for everyone to see, do I have to obfucate it if I am using [url] as a host. The site can't really be down all the time, I have read that I could work on thesite while it is up but I believe I will have to have all the source files up and open.
I've created a VB.NET Windows Form application which pulls info from an MSAccess database via datasets and tableadapter. When the user makes a change to the data, I use the Update method of the tableadapter to send the changes back to the database. This all works fine in the Visual Studio 2008 IDE, but once the build is done and the application is installed, I run into problems. The application keeps the original data and will not read or write to the database, although any changes I make through the application are mysteriously saved somewhere. If I make changes directly to the database using MS Access - which I need to be able to do - those changes don't show up in the data pulled into the application.
View 13 RepliesI am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
View 6 RepliesI tried attach .mdf file to server via vb.net code for deployment my application .I put .mdf and log in debug folder and I used this connection string.[code]
View 2 RepliesUsing either VB.NET, C#, or VBScript, how can I check if the IIS 6 Management Compatibility feature and its subfeatures have been installed on a machine running IIS 7.x?
View 1 RepliesAttach and detach sql 2005 database
View 1 RepliesI 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.
This is my first try of Visual Basic 2010 Express, though I have 10 yrs+ experience in VBA. I'm running Windows XP SP2 on a desktop pc with following installed: Visual Basic 2010 Express... just installed! SQL Server 205 Express ... been running on pc for 12 months I've created a new DB in SQL for my test application, but have not added any users or permissions to it as I'm using Windows authentication.
I've created a new Windows Forms Solution in VB2010EXP and tried adding a new Data Source for my new SQL DB, but it keeps giving error message about not having rights ot the db. 2 days of searching on the web has confirmed many others with similar issues, but no obvious solution. Eventually I find a few threads about permissions and moving the mdf into the root of the HDD, so try moving my mdf file up closer to the root of the Hard Drive msf was in C:Documents and Settings\_SharedDataApplication_DataMSSQL2005Data now in C:SQL2005Data
[Code].....
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesDo users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
View 1 RepliesI have a vb.net app that is installed on server 2008 and registered as a remote app with approximately 70 users accessing it. There is an issue that when I put a new version of the app on the server, every user must remote desktop in and run setup.exe before the app will update to the newest version. If they try to run it without doing this step first, the app just runs the previously installed version under their login.
View 2 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]...
which version of sql management studio express should i download for visual studio 2010
View 1 RepliesI am calling a stored procedure that calls a bcp command from a visual basic 2005 application to export data to excel. When I publish the app on my machine the procedure works fine. However when I attempt to install on another users machine when I push the button to call the event ..the export does not happen. I am trying to install from a network and the other modules work fine.
View 2 RepliesThis may be a dumb question, but I am stumped. I wrote a simple desktop application in vb.net (vs2005) and published it via the "deploy" method. After I deployed the app and ran the deployment exe - the application runs fine. However, I have recently added some command line switches so I can run the app via a scheduled job. But I cannot find the "exe" file in order to run the application from the command line. Am I missing something or did I deploy/publish the application wrong?
View 1 RepliesI am writing a program to record patient info for a local ambulance company. My problem is when a patient is added it does not write to the SQL server. When I open up the table in the Management Studio the record is not there. Here is the other thing that is weird to me. I open the program, add the patients info, clear the search box, type in their info and the record shows up. When I close and reopen the program I search the same record and nothing comes up. I tried redoing the string command, then thought maybe I needed to use parameters but that didn't work either.
View 11 RepliesI write as a systems administrator and own VS Team 2008 Team Suite. I would want to learn about the features within the package that allow developers to collaborate with other developers either real-time or otherwise.Additionally, I would want to learn about the features that would allow me to assign and monitor the progress of projects.
View 3 RepliesI am new to ClickOnce deployment and at first glance it seems a great way to maintain .Net applications updated with ease. I am developing a simple application that stores information on a mdb database and over some XML files. I understood how to use the "data" folder with ClickOnce and I am developing the part of my application that should migrate the data from older versions after a ClickOnce update. Now I need to debug that part of my code that only runs when the application is in "networkDeployed" mode. So actually I'm doing the following really slow process to test a new deployed version:
publishing the application on a provisional website (I can choose between a faster locale iis site or a real online one) installing the application from the deploying website (the first time) or running the old installed application so it automatically catch new updates and gets updated... running the application
So basically I have two problems here:
the whole process is much too slow :/ I'm running the app as every other app directly from the OS, so I can't access to the debugger...
I am pretty sure that there are better way to test ClickOnce deployed applications...
I want to know how i can add reports either crystal or microsoft to a folder called reports in my application and then for them to be displayed in my menu tool bar under reports and then for them to run once clicked. I know it can be done its just how it is done.
View 2 RepliesI have migrated a VB6 application to .Net which uses the MSFlexGrid in a total of 7 different places on 3 forms.When the compiled application is installed on a non-development PC, one of the forms throws a LicenseException when trying to create the instance of the MSFlexGrid control.The other two forms successfully create and use the MSFlexGrid instances that they contain.The problem doesn't occur when the application is run on a development PC.[code]I have looked at the designer.vb code for the forms, comparing the instances which work with the one that doesn't.In both cases, (working and failed) the same calls are made to the control wrapper (i.e. a new instance is created, BeginInit() is called, attributes are set, it is added to the containing control, and EndInit() is called, where the exception is raised.To reiterate, this is not the 'usual' problem of a missing developer license.The exception is not occuring during development, it is occurring in the application installed in the production setting.
View 1 RepliesI have built a very simple application which has buttons, and dropdowns containing links to intranet/internet sites.As I have no Idea on how to put them into a database for easy maintenance, this app will no doubt cause me pain.Nevertheless.. When I do create a new revised version of the file.. eg 1.0.0.1 how to I go about setting the application to auto check for updates ?
View 2 RepliesI would like to create a desktop shortcut for my clickonce deployed application.The IDE is VS2005 and there is no need for upgrading to 2008 yet.
View 3 RepliesI'm using Visual Studio 2003, and I have a macro similar to this:
[Code]...
The first time use the macro, it works fine. Each subsequent time, even after I detach from the process, the .Attach() doesn't seem to do anything. The same thing happens as I step through the macro... the proc.Attach() gets called on the correct process, but nothing happens. One note: when viewing the process in the Processes window, the Type column for my process shows ".NET, Win32".
