I need to rename this db and be able to set a path to it. This is because my webhost places all SQL databases on a seperate drive. This is a shared drive with alot of other databases. There fore my ASPNETDB.MDF needs to be renamed and have a path assigned. This doesnt seem tro be taken care of in my web.config file? Can some one help in reasigning the default database name and pathway. my other databases were pretty straight forward.
Hello,I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...I have renamed the db and now I get an error Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion My question is, how can I make this thing work? All help is greatly appreciated!
ASP.NET 2.0.... What is the proper way to rename the ASPNETDB.MDF to another name, such as TEST_ASPNETDB.MDF? I know you can rename the db in the IDE, BUT, there are other places you need to change so that ASPNETDB.MDF isn't recreated. Do I have to make a custom SQLExpress provider or something to that effect? Any examples? Thanks...
Does anyone know how to do this using variables? Everytime I try it, I get the
Error: Failed to lock variable for read access with error 0xc00100001.
I also tried it writing a script and still the same error. If I hard code the values into the variables it works fine but I will be running this everday so that it will pull in the current date along with the filename. So the value of the variables will change everyday. Here is my expression:
Hi there, I have inherited a databse and am building a new website to go wiht it. There is a file upload page which will upload images to a directory. I need to insert into the database retrieve the id just added then upload the image renaming it in the format locID(QueryString)_ImageID(retrieved from database).jpg The page has a file upload control and a button. I am trying to write my code behind so that when the button is clicked it inserts location id into the images table retrieves Image id. Renames the file and uploads it to the images folder. II think i need to call the routine from another routine for the button click but the signatures are different, where am i going wrong? or for that matter have i been pissing into the wind for the last 4 hours? CODE BEHIND
Imports System.Data Imports System.Data.SqlClientPartial Class admin_Add_Images Inherits System.Web.UI.PageProtected Sub UploadImage(ByVal Sender As Object, ByVal e As SqlDataSourceStatusEventArgs) Dim LocationId As String = Request.QueryString(ID)
' create a new SqlConnectionDim NewConn As New SqlConnection NewConn = New SqlConnection("server=desktopsqlexpress;uid=xxxxxx;pwd=xxxxxxx;database=MYLOCDEV") 'OleDbConnection i ' open the connection NewConn.Open()Dim MyInsert = New SqlCommand("INSERT into image([LocationID]) VALUES (@LocationID); SET @NewId = Scope_Identity()") NewConn.Close() If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then 'RENAME THE FILEDim newid As Integer = e.Command.Parameters("@NewId").Value Dim fn As String = (LocationId & "_" & newid & ".jpg")Dim SaveLocation As String = Server.MapPath("oicImages") & "" & fn Try File1.PostedFile.SaveAs(SaveLocation)Response.Write("The file has been uploaded.") Catch Exc As ExceptionResponse.Write("Error: " & Exc.Message) End Try ElseResponse.Write("Please select a file to upload.")
End If End SubProtected Sub Submit1_Click(ByVal Sender As Object, ByVal e As System.EventArgs) Handles Submit1.Click
I want to move and rename a file and embed the date/time into it, so that each time the package runs a new file is created. For example MyFile_20060712_150000.doc.
Can someone give me a hint how to do this with the File Systen Task SSIS Control Flow Item?
Could someone please instruct me on how to use the File System Task Editor to rename a file? I place control on control flow tab, change the operation to rename, from there I am not sure what to do.
I am fairly new to ASP.NET and MSSQL but when I run my website with memberships and roles everything seems to work perfectly!! NO PROBLEMS!! However when I try to go and actually open the ASPNETDB.MDF database file that was automatically created by VB when I added a login and sign up panel I get this Error Message "An attempt to attach an auto-named database for file C:Documents and SettingsoxMy DocumentsMy Webs nsApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." I don't really know why I can't open this file. I have someone who is going to help with some extra database work but asked if I could open this database so he could see the structure of it. I have a copy of the website as backup in another folder on my computer but even removing that backup does nothing in helping open the original. THANKS PLEASE HELP! Mark
Hello, I read the section related to membeship in the documentation and I have noticed that the aspnetdb.mdf file was generated on the fly. But how can I then exploit this file ? I have tried to access and create a new database with SqlServer 2005 Express but it didn't work. I manage it with the Database explorer of VWD 2005 Express, but why isn't it posssible with other database administration tools ? Thanks a lot.
Hi all!I have some problems with asp.net windows authentication.Asp made the file ASPNETDB.MDF. But I dont have SQL Server on the machine where the application will be deployed...So I have to move this file to another server, but I couldnt find any information about ASPNETDB.MDF connection string or somenthing like this.Is it possible to move this file or I have to make the authentication on my own, with my own database? I hope there is a solution to this problem!Many thanks! Regards!
I'm using Visual Web Developer 2005 Express, SQL Server 2005 and using the local file system as opposed to IIS for development purposes. I will reference two pages of my site: one that manages Types of Tours and one that downloads a Tour Registration Excel file. On the Tour Types page, there is a sqldatasource that populates a DetailsView whose default mode is Insert. On that same page I have a GridView that is populated from the same sqldatasource. The gridview has Paging, Editing and Deleting enabled. There is no code behind on this page except for a prompt to the user to confirm the delete action if he has elected to delete a Tour Type. This page works fine no problems. On the download page, I have a prompt that allows the user to click a button to download the Tour Registration Excel file. The code behind opens the Registration table in the ASPNETDB.mdf database, builds an .xls file via a streamwriter and prompts the user to download the file. My problem: if I start up VWD, go into my project, go straight to the download page without accessing any other pages, the download page works fine. If I access any other pages first and then go to the download page, I get the error "System.Data.SqlClient.SqlException: Unable to open the physical file "C:....App_DataASPNETDB.MDF". Operating system error 32: "32(The process cannot access the file because it is being used by another process." My simplified code behind is this: Dim sw As System.IO.StreamWriterDim myConn As Data.SqlClient.SqlConnection, query As String, myCommand As Data.SqlClient.SqlCommandDim myReader As Data.SqlClient.SqlDataReaderDim fileName As String, baseDirectory As String, fullFileName As String fullFileName = baseDirectory & fileNamesw = New IO.StreamWriter(fullFileName)myConn = New Data.SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=true;AttachDbFileName=C:<pathnamehere>App_DataASPNETDB.mdf;database=ASPNET;Data Source=.SQLEXPRESS")query = "SELECT Registrations.RegistrationNum, Registrations.Title, Registrations.LastName, Registrations.FirstName, Registrations.Organization, Registrations.StreetAddr1, Registrations.StreetAddr2, Registrations.City, Registrations.State, Registrations.Zip, Registrations.WorkPhone, Registrations.HomePhone, Registrations.CellPhone, Registrations.email, Registrations.AddToMailingList, Registrations.NumberInParty, Registrations.Comments, Registrations.DateRegistered, Registrations.TourDate, Registrations.TourFormattedTime, TourTypes.TourTypeDescr FROM Registrations INNER JOIN TourTypes ON Registrations.TourTypeNum = TourTypes.TourTypeNum" myCommand = New Data.SqlClient.SqlCommand(query, myConn)myConn.Open()As soon as the code his the myConn.Open(), it abends with the above message. I then have to close the project, and stop and re-start SQL Server. HELP!!
I want to rename a file that is a variable to a fixed file name in a specific folder in SQL Server System Integration Services using the File System Task Editor. Example: File1.txt to Users.txt or File2 to Users.txt. The source file is a variable the destination file is not. Here is an example of the File System Task EditorHOW DO I SPECIFY A FIXED OR VARIABLE FOLDER NAME WITH A SPECIFIC FILE NAME?????????File System Task EditorProperties ValueDestination ConnectionIsDestinationPathVariable TrueDestinationVariable User::ArchivePathOverWriteDestination TrueGeneralName Rename a fileDescription File System TaskOperationOperation Rename fileSource ConnectionIsSourcePathVariable TrueSourceVariable User::ImportFilePath Thanks
Hi everybody, I am running DTS export data evry night, where my MyTable is being transformed into MyTable.txt. In my MyTable which sits in sql 7.0 I have a field which shows today's date as julian date ( today julian date is 109). Is there a way to write a procedure/trigger which will rename MyTable.txt on daily basis into MyTable109.txt for today; MyTable110.txt for tomorrow; etc... Kind of stuck with that.. Thanks alot, rudi
I'm looking to use ActiveX in a DTS to copy a file from on elocation to another. I have the code for this (attached below kindly supplied by a colleague), so that's cool.
dim filesys set filesys=CreateObject("Scripting.FileSystemObject")
If filesys.FileExists("D:CreditsCredits_MTD.mdb") Then filesys.CopyFile "D:CreditsCredits_MTD.mdb", _ "C:CreditsCredits_200602.mdb" End If
But what I'm looking to do is go one step further. As you can see, it renames the file to yyyymm, but this is hard coded, and I'm looking for a coded solution so I can rename the file with yesterday's date.
having exhaustively searched the forum and tried everything over the pas few days im still recieving :Error Caught in Application_Error eventError in: http://mysite.com/site1/index.aspxError Message: An attempt to attach an auto-named database for file E:Inetpubwwwrootmvate.comWapCmsApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.Stack Trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) at System.Configuration.SettingsBase.get_Item(String propertyName) at System.Web.Profile.ProfileBase.GetInternal(String propertyName) at System.Web.Profile.ProfileBase.get_Item(String propertyName) at System.Web.Profile.ProfileGroupBase.GetPropertyValue(String propertyName) at ProfileGroupUser.get_ClientID() at InfoPage.Page_PreInit(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Page.OnPreInit(EventArgs e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)help and suggestions appreciated
I have a dataflow task that creates a text file and posts it in a FTP share. In need to rename the file attaching datestamp(current date of package execution) at the end of filename. For ex: My dataflowtask creates a file called 'Samplename.txt'
I need to rename it to : 'Samplename20080225.txt.
I think it can be done using the File task...I see an option to rename the file but not sure of how to configure the task to attach current datestamp.
I see some suggestions online, but complete steps on how to implement the above would be highly appreciated.
I love SQL Server Reporting Services (SSRS), but it doesnt let me name the tabs when exporting to Excel. The feature is well documented as not being available.
So I figured I can use the cell(1,1) on each tab to contain the tab name, and have an SSIS job poll a file share, open the file, read the cell, rename tabs, rename the file, and then email out the file. Polling the directory and emailing is a piece of cake, but I can't find any way to rename a tab without having Excel loaded on the SERVER. Not to mention instantiating an entire instance of Excel on the SERVER every time I want to do this.
I want to leverage SSRS, and preserve the formatting of the excel file, which is why I don't just dump the data in with SSIS to begin with.
For MS Press Book, ADO.NET 2.0 Step by Step, 2005 Edition by Rebecco Riordan, installing the code samples created a ConfigDB.exe file under SampleDBs folder. Running this exe file created a AdoStepByStep into the Database folder in SQL Server 2005 Express.
However, for ASP.NET 2.0 Step by Step, 2005 Edition, by George Shepherd, there is no Config.exe to install the ASPNETDB SQL Server 2005 Express database. I right clicked the Database folder to 'Attach' the database. But, the database just showed a 'c: ASPNETDB.MDF filfe path as a name. Further, running the aspx files in Chapters 7 and 12 showed a 'Timeout Expired' error msg, indicating something wrong with accessing the SQL Server database.
How can I run the aspx files in Chapters 7 and 12? How can I install the ASPNETDB?
I am getting the error: Cannot open database "aspnetdb" requested by the login. The login failed. When I browse to my ASP.NET 3.5 LINQ web application on the IIS 6.0 server on Server 2003. I imagine this is because while I granted SQL Server 2005 login and permissions to my database that the application stores its data in, I did NOT grant any rights to the service account the IIS Application Pool uses for its identity to the aspnetdb database on SQL Server which is where all my roles information is stored at. My question is what are the MINIMUM permissions needed for this database so it can perform its roles related functions? I'm using Windows Authentications with the SQL Role provider for authorization.
Thank you.
EDIT: I think I only need to open the aspnetdb database and add my login to the aspnet_Roles_FullAccess role. Is that correct?
Hi, I'm trying to upload the ASPNETDB.MDF file to a hosting server via FTP, and everytime when it was uploaded half way(40% or 50%) I would get an error message saying: "550 ASPNETDB.MDF: The process cannot access the file because it is being used by another process" and then the upload failed. I'm using SQL Express. Does anybody know what's the cause? Thanks a lot
Using VS2005, VB backend and javascript, I have developed a relatively simple site - its got a few (12) simple aspx pages but its mostly client side javascript. Keeping disk storage costs down is a big concern with this my site. The disk usage for the site is ~24M. Since this was larger than I expected I started inspecting the files comprising my site and found that the "ASPNETDB.MDF" in my "App_data" folder is consuming 10.2M by itself. The thing is that site only has a few pages with calls to SQL Server - but I never did anything (that I know of) with ASPNETDB.MDF. Through VS2005, I opened up the MDF file and poked around, everything that I looked at was empty (NULL). So my questions are:
What is causing the ASPNETDB.MDF to consume 10.2M even thought I can't see any data stored in it? Is there anyway for my to reduce the size of this file? If so, how? Your input appreciated.
I'm creating a website in VWDexpress 2005 using a database, with string "SqlDataProvider". I have only one small-sized database. When I try to run my application in login mode (not using LoginView, I create it manually), the application cannot log me in, instead there's a weird error said some kind of "cannot use the ], [ or ) in database name". I don't configure the ASP.NET Configuration (which is opened in browser to make roles etc), I create all the controls manually. I don't have any other automatically-generated databases such as ASPNETDB.mdf because it cost lots memory! Oh, I used it before and the weird error I mentioned is occur when I excluded the ASPNETDB.mdf. I'm confused, why would the same error occur since I create everything manually? Any solutions? Thank you.
I am creating a new application and want to store the sql database. But i need the aspnetdb.mdf. I dont know where is the database located or do we have any scripts to create the database. Any help would be useful
