When I created table on the shared SQL server on hosting server using management studio, I right click mouse on the table, it pops up create table. However, the table schema is my user name but not dbo. I wnat to create table with dbo schema.
I have a SQL Server 2008 DB with many tables filled with data and I used SQL Server Management Studio to generate a SQL dump by using the Script Wizard : Tasks -> Generate Scripts -> Script All objects in the selected database and also selecting the option to Script Data. I made sure to change the value of "Script for Server Version" to "SQL Server 2008". Then I created a new DB and ran the SQL dump on the new DB to generate an identical copy of the old DB. Then I assigned permissions to my default user to the new DB. Then I changed the connection string on my ASP.NET application to use the new DB. But when I run it, it throws the following exception -
Server Error in '/myapp' Application. The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:.........................
I've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server. What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITYNETWORK SERVICE permission to my database? Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
I am developing a simple online DBMS to browse my database online.... the main concern for me is to clear everything from the PC when the user disconnect so no body can go and click (Back) on the browser and see the pages if the user forgot to close it.. what I have done so far is :
I am sure this is not enough.. am I right? so what else I should include there?
In some sites specially online shops, users can pay from thier bank account or cridit card.how can we implement online payment. what is the proccess of online payment? is there any API or Dll for this.
I want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
but when i feed data in offline database, online database automatically updated.
connecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:
Cannot open user default database. Login failed. Login failed for user 'Zephere-pcephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064) The cause is that the default database is set offline, How do I bring it back online agian?
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
I was just wondering if anyone has ever had to port the schema across? Are there any experts that could pitch their opinions on the achievability of this (mad) idea? I'm using the IBM Migration Toolkit and as expected its throwing a bunch of translation errors some of which were relatively easy to solve (vendor specific function calls for example) and some will take quite a while to pin down and work round.... however this is not my main concern.
If completed I expect I am going to have to basically rework all the System.Web.Profile/Roles/Membership namespace classes etc to work round the SQL limitations of informix (i.e. IDS11.x SQL server doesnt have a DEFAULT (newguid()) so that would have to be put into the calling method) (and any MVP comments really as I can slap my boss round with the weight after he ludicrously agreed to this project for a client without doing any research...)
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
Trying to open up a form in a new window while passing some values. It is working, but it is client side (My ASP co-worker finally grabbed the reigns and implemented a bit of his ASP magic to open the form and transfer the values.) But it's so messy, and I hate the fact that I have been bested by old technology.
I was doing this client side before, using window.open and transfering the variables in the URL, but I was getting flack for doing that. So I looked at alternatives and found session variables, which you set server side. So now we want to open the form. I tried the following (individually): Response.Redirect("OtherForm.aspx") and Server.Transfer("OtherForm.aspx") Which replaced the original form in the open window instead of a new window.
In my asp.net 2008 project, I am using the login controls... In the local sql server, there are all the necessary tables and stored procedures which the system creates for the relevant login controls. All working fine. I notice in the webconfig file there is an entry under connections, i.e.:
I have a project in VS2008.Net3.5 with a Module1, form1 and form2.
Imports Microsoft.VisualBasic Module Module1 Public frm1 As form1 Public frm2 As form2 Sub Main() frm1 = New form1 frm2 = New form2 Application.run(frm1) End Sub 'A menu sub Private Sub menuGotoSpecification_Click(ByVal sender As Object, ByVal e As System.EventArgs) _ Handles menuGotoSpecification.Click frm2.Show() End Sub End Module Public Class form1 Private Overrides Sub Show() LoadData() MyBase.Show() End Sub End Class Public Class form2 Private Overrides Sub Show() LoadData() MyBase.Show() End Sub Private Sub btnDone_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDone.Click frm1.show() frm1.refresh() Me.Hide() End Sub End Class[/CODE]
At the beginning I am opening form1 from sub Main(). Now from the menu I am openning form2. In form2 I am clicking Done button to hide form2 and go back to form1. It works fine in the 1st trial. Keeping form1 open for the 2nd time, I opened form2 from the menu. Now when I Click the Done button 2nd time it just hides up everything. Form1 does not show UP. It just exits the whole application. But in my btnDone event, I have frm1.show().