Asp.1.1 - Publishing - Put Database Up From SQL Management Studio
Nov 5, 2009
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.
View 2 Replies
ADVERTISEMENT
Apr 22, 2011
I am using an Access Database with my project. When I publish, all the Forms seem to Publish. Also the database gets published. However, once I install it, there seems to be no connection with the Database.The Forms give me the Oledb error as Im using Access. However, the login form seems to connect with the database. In other words, my applications gets authenticated, but when I try to open other forms, there seem to be an error with DB connection
[Code]...
View 1 Replies
May 24, 2010
Please how can i publish an application created in vb.net along with a database which i created in SQL Management Studio?
View 4 Replies
Mar 9, 2009
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
Jul 6, 2010
I 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 Replies
Apr 17, 2011
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].....
View 1 Replies
Jul 13, 2010
which version of sql management studio express should i download for visual studio 2010
View 1 Replies
May 25, 2012
I have a website hh-alrawi.com, the problem is every time I publish the site the main page (Index.aspx) does not appear, the correct site URL is : http://www.hh-alrawi.com/index.aspx , so I wonder how can i put the main page name after the domain name (Index.aspx) always after the URL, I tried to edit my web config but it's not working, my Web Config :[code]
View 2 Replies
Jul 7, 2010
I 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 Replies
Mar 11, 2010
I 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 Replies
Jun 9, 2011
I got problem in my vb.net program in publishing it. I am using Microsoft Visual Studio 2008, when I publish my program and I got the setup file and when i tried to run into another computer I got some error saying that it cant connect into the database. Actually I used msSQL 2005 server in my VS 2008.
View 7 Replies
Sep 28, 2009
where 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]......
View 1 Replies
May 6, 2011
I've made a fairly good Windows form application to solve quadratic equations, but I am having a hard time understanding the publication process microsoft uses in Visual Studio. I'd like to distribute my programm as freeware on my blog.
View 5 Replies
Jun 22, 2009
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 Replies
Aug 3, 2011
How 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 Replies
Oct 23, 2009
i grow familiar with statements queries of SQL. Now, i have to start writting a store produce and function in SQL Management studio express.
View 1 Replies
Apr 19, 2011
I'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]...
View 1 Replies
May 22, 2009
About publishing my program. there's a lot of files made after publishing unlike in vb6 when i converted it to exe file theres only one file. hmm how can i make just one exe file in vb9 is it possible? another question do i have to install the program after publishing?
View 5 Replies
Feb 16, 2012
Note: This question is similar to How to prevent the copy of XML documentation files in a release mode build?, but it's not the same and the answers there don't apply. Read on to find out why. (Please ask in the comments or in chat if you disagree, I'll be glad to elabroate).
I have a library project (myLibrary) and an ASP.NET web application project referencing this library (both are in the same solution). "Generate XML documentation file" is checked for the library project, because I want to have those nice IntelliSense features while developing.
When I publish the web application (Context Menu on the project/Publish...), it copies only the files required for running the application (no source code, etc.) to some publish directory. That's good. Unfortunately, it also copies the XML documentation file of the library. Since I consider our library's documentation to be a trade secret, I wouldn't want it to end up on a customer's server. Thus, we have to remember to manually remove this file from the publish directory before deploying it.
Is there a way to prevent Visual Studio from copying this file when publishing the ASP.NET project, but still retain the benefit of XML documentation IntelliSense when developing?
View 4 Replies
Feb 14, 2010
create database management system in vb 2008
View 2 Replies
Jan 28, 2011
A year or so back I made a database management program in vb.net and now its out dated and i want to start from scratch, since I wasn't very good at vb.net at that time most of it is hacked together in one single file.Now i want some tips in making these kind of programs.I've heard of something called a data access layer. What is it and Should I use It ? Is it a Class or interface (I don't know what interfaces do yet but they should be to hard)?
[Code]...
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
Oct 19, 2011
I just wanted to know if visual basic 6.0 or Visual Basic 2010 can be programmed to create a system that uses both smart card reader and sensors (photoelectric sensors) and be recorded their information into a information management database for date and time log.
Example:
1. A personnel will have to tag their smart card to the smart card reader. It will then be checked from the database and approved if their record is available in the database.
2. He will then have the access to enter and take a particular stuff from a rack (which has the sensor) guarding on each item on the rack. If the personnel take the item. It will then be logged into the database for the 1. personnel I.D, 2. item position on the rack, 3. time and date when the item is collected.
Question:
1. What hardware are needed to incorporate all this (smart card reader and sensors to database)? a controller perhaps? terminal for all the sensors?
2. What software to create the information management database so an authorized personnel may check the event history? also software to incorporate with the sensors? will it have to be on separate software or all can be done in the package given in VB6 or VB2010 or an additional software to be used?
3. Does MSComm Control have any relevance on this subject? All i know is what it does (vaguely) and no idea how to implement it.
View 7 Replies
Feb 24, 2010
I have a database that works fine when not yet published, I connect this way: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Network_Info.mdb" But when I publish my project my application can't find my database and I always get an error. Any solution to this matter?
View 4 Replies
Oct 28, 2009
I am working on a small personal database management program and am at the stage where I am trying to search the MS Access database given a user input.I need to look up lets say the "customer" ID and the update other records associated with that customer. Here is what I have so far.
[Code]...
View 14 Replies
May 8, 2012
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 Replies
Apr 22, 2009
I 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]...
View 4 Replies
Jan 28, 2010
I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?
Heres the screenshot and codes
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click
[CODE]............................
View 2 Replies
Nov 8, 2010
i am working on a project and i want your help for something. I use access database and visual studio vb.Net. In one of my forms i want to get records in a datagridview , between two dates . For example , i have the table Sales and i want to see all my sales between the two dates.
[Code]...
View 7 Replies
Feb 13, 2012
In my project i have different users lets say 100 users. My problem is most probably authentication. What i wanted to achieve is this;1. When user1 creates an account (saved database) with the following details
name: user1
lastname: user1
When he/she logging in into the system that information must be viewed by him ONLY. (authentication)
2. If user2 logging in he/she can't view the information of user1 (obviously).
View 8 Replies
