Using Mdf File On Server Without Database?
Jan 12, 2011I need to incorporate some basic database functionality with no real need for speed.
View 3 RepliesI need to incorporate some basic database functionality with no real need for speed.
View 3 RepliesI m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.
i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server)
i am trying to restore back up database .bak into the new database i just created in sql server 2005i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message"You must select a restore source"
Here's the screen shot: (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)
I am trying to import the SQL file provided by Elmah into my application, and I don't want to import it into the development machine I use. I want to make it a .mdf file so it can be easily transported to my host. I was wondering if there is a way to do this?
View 7 RepliesHow do I upload a file on the web server and save the link of the file in a database?
View 3 Repliesam importing a text file database in my sql server database in asp.net c#.but i cannot fetch the column name from .txt file which contains a numeric data now what to do?
View 1 RepliesI have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 RepliesMy client gave me .DAT database file. But I am not know how to use it or how to attach it to the sql server.
View 3 RepliesI'd like to know how to allow user to upload file to the server in mvc 2 application. I haven't seen a very clear tutorial for this, at least not on this website. There is a movie database tutorial but that is simply a list of movies not actual files. What is the simplest method for uploading files, be they images or movies?
View 13 Repliesi saved files into database. when i'm displaying i wrote code like this
Dim mySqlDataReader As System.Data.SqlClient.SqlDataReader
Dim mySqlCommand As New System.Data.SqlClient.SqlCommand("pl_Resumes", mySqlConnection)
mySqlCommand.CommandType = CommandType.StoredProcedure
[code]...
i have an csv file, using Logparser im reading the data and add into the table, now if the csv file has 100 records then im hitting the DB 100 times, how can i push all the records to the DB at one time so, that i can improve the performance.
View 9 RepliesI have a .bak database file and i want to restore it to a new database so that i can get the data inside the .bak file
I am using SSMS 2008 Express
what i did :
I created a database with the same name as of my .bak file (in my case "RM")
now after creating a new database > righclick on database > tasks > restore
Selected FROM : RM ( empty database that i just created)
Selected TO : RM.bak (my backup file)
when i press "Ok"
i get this error:
I am newbie in SQL Server 2008 R2. I able to created table within it but how do I get the database file. Can I specify the path where the database is create?
View 1 RepliesI urgently need to find a way of reading data from a .CSV or .xls(Excel) file into an sql database so that I can use it in my asp.net 2.0 application.
View 4 Repliesupload the vedio file in sqlserver database using asp.net c# .
View 4 RepliesHow to create Database from .bak file in asp.net c#
and the new database should be created with new database name,user id and password
I need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
i want to insert doc/docx file into database and after that i want to retrive that file in lable
View 10 Replieswhen i upload a file his size lower than 5MO it work but if not this error display
Erreur 101 (net::ERR_CONNECTION_RESET) : Erreur inconnue
i use this method for programming [URL]
i want to save afile(word or pdf) to database table and allow user to download itStored Procedure
alter procedure addAttachments
(
@ENo varchar(6),
@CID nvarchar(7),
@ATT image,
@Date nvarchar(50),
[code]...
I need to make a back up file(.bak) from my database (.mdf)
I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't.
How to upload a file in asp.net.
View 1 RepliesHow can i import CSV file in ASP.Net C#?
View 1 RepliesBelow is the code I use to store file into database but there are a few problems.
1. couldn't store file larger than 4mb
2. couldn't store doc,docx,xlsx but only .txt
my table column are:
[code]....
WEB FRAMEWORK: ASP.NET in C#
I've looked all over the web for something that would show me how to do this but can't find it. I have a page that uploads information about an individual including a resume in the form of a doc docx or pdf. I can upload the file okay but I do not know how to, on another page, To download the file that was loaded to that person's row in the database. Here is the upload code
[code]....