Hi
I'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.
After web site deployment I get allways message : Failed to update database "c:appapp.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.
I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".
TIA
Paul
Hey All, I'm very new to ASP.NET and have recently begun using the databinding functionality. So far, all I've had to do is drag and drop the various controls and then use the data source wizard to set up an appropriate query. However, now I've got a bit of a different need. In the VB codebehind, i need to be able to ask whether something is true in the database, and then if it is, carry out functions. So, for example, what I need to do is: if (SQLStatement "Select charttype FROM charts WHERE datasource = " & dropdownlist1.selecteditem.tostring()) Then 'do whatever end if Trouble is, I don't know how I would go about binding the data so that I could access it in this way. Any guidance would be very much appreciated. Thanks,J Rankin
I īd like to know if there is any way to access an Informix database from sqlserver 2005.
We are trying to build a data warehouse in SS2005, and I want to know If I could avoid the generation of hundreds of flats files from Informix and loading them into SS2005, directly recovering all information from SS2005 across any kind of migration or connection.
I have a asp.net 2.0 web applicaiton which is connecting to the remote SQL server 2005. When I run the Web app, then Iam connecting to the DB and its displaying the records on the page.
When I browse the same page from the IIS, then iam getting the following error: "System.Data.SqlClient.SqlException: Login failed for user 'mydomainuser' "
I wrote a vb 2005 application that access sqlexpress for data using sqlconnection (.NET). The program works fine. When I run debug on my code that is in my laptop, it access my xp server box with sqlexpress running and I see all my data in my application. My question is..When I compile this program and install it on a client machine that has no sqlexpress tools, no SQLCMD etc....will the application run and access the xp server box, or do I have to install something on the client machine.
I am trying to load data to a sql table from flat file..I have a script component which will validate the data. I am also firing the errros when data validation fails. Once I encounter an error I want the whole package to be aborted. What I have done is declared a variable called errorcount (Scope :Package) and I am incrmenting this variable everytime an error is raised and next I have a Conditional Split which will check if this variable count is greater than 0 if yes I will not update the table.This is the only way I think this will work.
error I am getting is :The collection of variables locked for read and write access is not available outside of PostExecute.
I understand they r in the same data flow thats the reason I get this error but how can I by pass it ?
MY dataflow-> Flat File Source-Script Comp-Condtional Split-(If errorCount==0)-SQL Table
How can I redo the dataflow so that this err is not raised.
I have tried to add an output column (blnContinue) and use that in conditional stmt but as this is stored at row level values which have blnContinue as true are getting processed, I dont want this I just want to stop the package execution even if a single validation fails
I almost finish my website and ready to upload it to internet. However, I have a thought of how the database will work.
Here's the scenario. My website is a data-driven dynamic website with SQL as the database manager. I have 3 database files.
After I finish with everything, I will have to deploy the application to the webserver right? Now, let say I deploy / upload it to a hosting company. Then, people start using my website, all traffic coming in, and database are getting larger and larger. Then, let say I decide to make some changes to my website. I change the website here and there. However, I haven't uploaded / deployed it to the hosting server yet. I just make the changes in my computer. I test the application and changes that I make, everything works fine.
My question is: If I deploy / upload my website to the SAME hosting company after I make some changes, what will happen to the database in the hosting server? My website has been used my many users and database is getting larger. If I deploy ./ upload the website that I have made changes, will it overwrite the database in the hosting server? Or how does this work?
Anybody has any idea or maybe has already done it?
My database contains over 50 tables of information - some tables are quite large. Rather than upload the entire database (which I imagine could potentially lock out many users from browsing the website), I would like to upload changes to individual tables. My local database contains the most recent table information. What would be the best way to upload individual tables that would only lock one row at a time while the updates were taking place? A DTS package?
it must be simple, but not for me! there's a folder called db in the ftp part of the server and the admin told me to upload my database there,i don't know how to transfer my database in that folder.can you help me?
Hello everybody, I intend to used SQL Express database in my website so that I don't have to go through all the database deployment effort when deplying my website. In this regard, can anyone please tell me what features would it require in my hosting package so that my application works fine (in database context). Would I have to purchase any additional features (like the way we purchase SQL Server database(s) in hosting package) for SQL EXpress in order to deploy my application?? I look forward to you kind replies. Thank you. Zulfiqar Dhuka
I am currently trying to complete part of my A-level coursework but am stuck.
i am creating a website for a restaurant on which customers can submit information to do with four areas: --------------------- Bookings Comments Job Applications Pre-order ----------------------
i have used access alot in the past and had no problems creating a running model of my final database.
i have built my website and created the four tables in the alloted MySQL area that came with my website package.
BIG QUESTION:
how do i create the interface for people to submit data and for it to be sent to my database?
i am a complete beginner to MySQL using it for the first time this week so im not sure what i need to do in the slightest to solve this issue
HiI’m abut developing a website that has a 200 megabytes SQL database ,in my estimation the maximum online users are 100 users for first year , I want to make shore a SQL express 2005 database in good enough for my purpose. Another question is how much can I count on a SQL express 2005 database? I mean how much it could be grown and abut security (I mean is it as secure as SQL server?). Thanks.
I don't know whether this question belong here, but.... In the past I had many customers using the same website each with their own domain name and their own database. To accomplish that, I used MS Access and placed each customers database in separate directories. I steered the customer to the correct directory using their domain name. I am now trying to accomplish the same thing using aspnetdb.mdf and other .mdf database files. I am using the aspnetdb.mdf database for membership, etc. I want the aspnetdb.mdf database file to be unique for each customer. Does anyone know how to accomplish what I was doing with MS Access using aspnetdb.mdf? Is there any way to have multiple web.config files each of which would be dedicated to a particular customer?
hi. I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005? I had tried to google for more info but there are too complicated thing for me to understand. Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form. We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server ) So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ? I appreciated that. Regards newbie on aspnet.
I am in the process of designing a web application for our application that will be available to the general public.Basically will be used to collect information for a case report. I need to know if there is a way from our internal database driven application to push certain data up to the website that the database may be behind a firewall so I cannot make a direct connection to the external database. I thought I heard about some sort of data sharing protocol. I then will be storing the users entered data in the website database and pulling it from the internal application. So basically I need a secure way of sending and receiving data between a server/client app on a LAN system to the Web site database that could be hosted outside the LAN. I hope this made sense.
Hi,A quick question, is it possible to deploy a website on a shared hosting environment which attaches to a MDF database file stored in the App_Data folder?
hi there.. I have write a code in the submit button using vb code so that when people key in their email.. it will be saved in my created database called test.mdf. but when i debug it, i tried to write an my email address in the textbox in my website but when i click at the submit button, the web page display the email was not enter in my database. here is the code, can anybody help me. i'm really lost here.. Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim TestDataSource As New SqlDataSource()TestDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TestConnectionString1").ToString()
TestDataSource.InsertCommandType = SqlDataSourceCommandType.Text TestDataSource.InsertCommand = "INSERT INTO Email(EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress,@IPAddress,@DateTimeStamp)" TestDataSource.InsertParameters.Add("EmailAddress", emailAddressTextBox.Text) TestDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString())TestDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now()) Dim rowsAffected As Integer = 0
Try rowsAffected = TestDataSource.Insert() Catch ex As Exception Server.Transfer("test_problem.aspx")
Finally
TestDataSource = Nothing
End Try
If rowsAffected <> 1 ThenServer.Transfer("test_problem.aspx") ElseServer.Transfer("Test_Confirm.aspx")
I am creating a website. where the data to be stored in my server. I had my webspace from some service provider. How can i connect the website and thee database. --> website is deployed at webspace given by the provider. --> database is at my server( located in our office).
****************How can i connect these website and database.*******************
Hi!!! I have a database called "test_DB" i have one table and some data on it. I uploaded the website and created an SQL Server account to upload the database. Can you please help me to do that task. Is there any step by step directions to do it and what files i need to add ( like ".mdf" or others...) I appreciate your help!!! Thanks...
Since VWD Express doesn't support Publish Website, I used 'Copy Website' to deploy my local site to the hosting server. The static page works fine, but when it gets to accessing database, I kept getting the following error: An attempt to attach an auto-named database for file I:DataWebdnh.sklingling_15726c71-b2bf-479f-bcc3-b7ae43318f3cwwwApp_DataPersonal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Anyone has the same experience? How to resolve this? Thanks,
I create a WebSite onto the internet. Then I created a database with MSSQLmanager provided by the WebHosting. I created a Table and put some data in it. When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely." What shall I do to configure my Database. basically I don't know where to go to change configuration of my Database. In my intranet I would use SQLServerSuraceArea. But on Internet I do not know. someone Help. Did I miss something ?
I'm working on a ASP.NET project. The applications has 4-layers. When I look in the Data Access Layer and test the typed dataset, then the "Preview Data" works fine. I see the right records from SQL Server 2005.
But when I run the app (default.aspx) in debug-mode, then the system gives the following error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"
I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.
I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.
I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.
Does anyone out there knows if there is a bug with this tool???
Hi all, I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as /Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :- <?xml version="1.0"?> <configuration> <appSettings/> <connectionStrings/> <system.web> <compilation debug="true"/> <authentication mode="Windows"/> </system.web> </configuration>
Am I missing something? I even have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator..... I appreciate your suggestions.
Hi, I am using express database and tools. I have an aspnetdb express database because I am using the login controls, personalisation...Can I use this database for my private tables also? Or do I need a separate express database for my private tables? Will using aspnetdb database, which contains special asp.net tables, for my private website tables create any kinds of problems in using my website? I want to use a single express database for my website, not two different express databases. Regards, Sandy
Hello.. I want to upgrade my website to asp.net 2.0 and I want to add a Daily news to website.and 10 to 15 news will be added daily , so after a year we have almost 4000 entry in the database. For designing this DB what is your advice on how to store news in database?Is it better to create same tables for each year ? for exampletblNews_2005tblNews_2006 Or just to make one table and have all news stored in that ? its gonna be huge after years , isnt that make any problems? ThanksRegards.
Hi everybody, Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office. We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it. Would it be possible to access our local SQL database from the remote website?
I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:
c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf thats use Sql server
i would like to access this database with c# form application on a network with multi-user. if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message
System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i read that sql server did not support database sharing with mapped drive or unc share.
So how can i share website database with c# application???
Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.
I cannot access the data source when I create a website in express - when I try to connect to the database I get an error telling that I am unable to connect to the data source - I tried doing it through the Visual Studio and through the Web Configaration.
New to AJAX and ASP .Net. I am trying to follow along with Scott's Todo List video. When I try to add a sql database by right-clicking on App_Data and selecting add new item and then sql database, I get the following message 'Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installatio of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251' . I have installed Sql Server Express but still get the message. I would appreciate it if anyone can help me with this issue, thanks.
