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?
[code]....
but when i feed data in offline database, online database automatically updated.
I have an application build using asp.net in sharepoint platform, however the paging and sorting features in gridview failed to function properly in Offline Explorer (Metaproduct) environment, an offline browsing software.
In my website i have used a database file named TRAVEL12.mdf, which is present in APP_DATA folder and some how by default a databse file named aspnetdb.mdf is also present in APP_DATA folder , althogh I have not made it......
Now, my problem is that sometimes when I tries to insert some data at any table(that table is in TRAVEL12.mdf database) error shown that login failed to access the default database aspnetdb.mdf for the user...........
Then I deleted the database aspnetdb.mdf, but now also sometime error shown that login failed to access the default database for the user......
as i mentioned that error occurs sometimes not every time which is also a confusion to me!!!.........
I can't understand why this happening??? I am working with TRAVEL12.mdf and I have used it's connection string in my code as a argument of SqlConnection class, so what is the role of default database here!!!
I am currently working on visual studio 2008 , sql express 2005, i have copied .mdf and .ldf files , after i copied these files and try execute some existing stored procedure but exception is coming like " Failed to update database xxxxxxxxxxxxxxxxx.MDF" because the database is read-only", I dont knw what's wrong with this , i have executed same stored procedure in old .mdf and .ldf database , and its working fine . but in copied .Mdf , not working.
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
I have a website with a button.Everytime I press that button I want to multiply the number I have in the database by one.It works perfectly offline, but as soon as i upload it i get this error:
Code: protected void btnthumbdown_Click(object sender, ImageClickEventArgs e) { int countdown = 1; countdown += Convert.ToInt16(lblcountthumbdown.Text); OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/DataBase_J_Wall.mdb")); con.Open(); OleDbCommand cmd2 = new OleDbCommand("update MAIN_TBL set Person_Thumbs_Down='" + countdown + "' where Person_Email='" + lblemail.Text + "'", con); cmd2.ExecuteNonQuery(); con.Close(); Response.Redirect(Request.Url.ToString()); }
i have problem in connection strin i host my site and database is in DATA DIRECTORY my site run successfully in offline but an error of connection string in online pls give me an example of string for online i use asp.net, C# and sqlserver 2005
I have created roles and users using ASP.NET configurations for login validations, it works fine if I run my application within project but when I publish my site and try to run from my Inetpub it giving this error. I tried all shorts of solutions posted in website but nothing worked for me.
"Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed"
This program used to work when I had VWD 2005 express and SQLSERVER 2005 express. Then we upgraded to VWD 2008 express and SQLSERVER 2008 express. Now it fails Error running adodb Provider cannot be found. It may not be properly installed. 3706 To clarify; I used to run variations of the following to create small offline cub files that I could email to remote Users:-
PROVIDER=MSOLAP; DATASOURCE=C:TESTAMRunAdodbTestMyCube.CUB; SOURCE_DSN=AMCubeData; CREATECUBE=CREATE CUBE AMCubeData( DIMENSION [Channels], LEVEL [ALL Channels] TYPE ALL, LEVEL [Channel Group Name], LEVEL [Channelname], MEASURE [Sales Val] Function Sum Format 'Standard'); INSERTINTO=INSERT INTO AMCubeData( [Channels].[Channel Group Name], [Channels].[Channelname], MEASURES.[Sales Val]) SELECT [ChannelGroupName] AS Col1, [channelname] AS Col2, [Sales Val] AS Col23 FROM dbo_qryCubeDataExtra ;
in a VB6 program that ran them in a ADODB connection something like :-
Dim MyCnn As ADODB.Connection On Error GoTo Err_ErrorHappened Set MyCnn = New ADODB.Connection MyCnn.Open (MyAdodbcmd)
I have asp.net application, using LINQ to connecto to SQL Server 2008 R2 databse. My connection string: Data Source=[SqlServerIp];Initial Catalog=[databaseName]User Id=newLogin;Password=newPassword; When I deploy application on my local IIS (which is not the same machine as database server)
it works fine, but when I deploy application on other IIS (the same machine as sqlServer) it throws an exception: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. how to fix it? Maybe it is due to some bad configuration of IIS?
I am not used to work with SQL Server(usually I just use express). I run it on windows server 2008, iis7.
I have attached the database to my sql server. I made a web site in iis7 but I get this error message.
Cannot open database "Phaeton.mdf" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'. Connectionstring I use <add key="PhaetonConnectionString" value="Data Source=.;Initial Catalog=Phaeton.mdf;Integrated Security=True"/>
I am building an MVC application with C# as my language which is hosted on Widows 7 IIS. A call to Add a new member to the database works, but when attempting to save the change I get the following error:
Cannot open user default database. Login failed. Login failed for user 'IIS APPPOOLmyApplication'
The SQL table was added just by adding it within VS.
This is a very common error as evidenced but the very large number of problems and suggested solutions on the web. I finally got around it last week but can't remember what was the step that did it. At that time, I was building a web application rather than a web site. Is that the difference? As you can see, it is no longer in the APP_DATA folder and is named membership.mdf rather than aspnetdb.mdf. I ran aspnet_regsql.exe to create it and actually had it working and was updating it successfully. But for other reasons, I had to scrap the application and decided to re-create it from scratch as a web site rather than a web application. I had been using Visual Studio 2008 to build the web application but am now using Visual Web Developer 2008 Express Edition to build the web site. Unfortunately, the Visual Studio application will no longer open so I can't verify that the web application still works. Can anybody help? (Please!!!) BTW, ASPNET and NETWORK SERVICE both have full control over the membership.mdf.
In fact, I DO NOT want to ask a question but to share one solution to this. One cause of this problem is you did not register your sql express on iis.I installed .net 3.5 sp1, then ran aspnet_iis -i, then installed sql express 2005 advanced. Yes, here came the notorious alert. So, I ran aspnet_regiis again and everything is OK.Run aspnet_regiis before you have installed sql express.
i'm using asp.net 3.5 and my site is hosted on godaddy i have a contact us form on the site. and i have to send the contact queries on [URL] which is hosted on godaddy. whenever i try sending mails i get this error
The transport failed to connect to the server.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: The transport failed to connect to the server.
Source Error:
[Code]....
Line 250: SmtpMail.SmtpServer = "smtpout.asia.secureserver.net"; Line 251: mailmsg.Priority = System.Web.Mail.MailPriority.Normal; Line 252: SmtpMail.Send(mailmsg); Line 253: } Line 254: }
i tried changing smtp to relay-hosting.secureserver.net aswell. but it didn't work. i'm using this method of my classfile's sendmail class public void SendMessage(string From, string ToEmail, string subject,string body)
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Gullanian'.
I've created the database 'Scirra'. I've also attempted to add a login, but nothing seems to work. Logging into SQL management via Windows Authentication is the only way I can gain access to my DB's.
Ideally I just want to create a user, and that user having full control of DB. So I can run scripts etc.
Here's a few details:
Microsoft SQL Server Management Studio 10.50.1600.1 Microsoft Data Access Components (MDAC) 6.1.7600.16385 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4952 Operating System 6.1.7600
Idk why it says v2 for asp.net, all my application pools are set to 4.0.
I'm using an Oracle database(10g) which contains a stored procedure called Foo. Foo takes 2 datetime as IN parameters and 1 cursor as OUT parameter. I've been trying to make the connection and the query to the database with the OleDbCommand, but since Foo needs a cursor I have no choice but to use a OracleCommand(right?).When I try to connection to the database I get the following error : "OCIenvCreate has failed return code -1". I've gived the correct permissions to ASPNET user for the oci.dll file so that it can read and execute it. Unfortunately, I still get the same error and I'm lost.Here is what cause the error
I have set up my website to use ASP.NET Membership. it all works fine when trying to use it on my development machine but when I put it on the web server and try to log in, I get this error :
"Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only. "