SQL Server :: Converting .DAT File To Sql Database?
Oct 4, 2010My 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 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 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 Replieswhen i convert tiff file to pdf in debug mode it converted successfully but when i host it on localhost it didn't convert and throw an exception:
Cann't make pdf files. Try again.System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {71DBCBF1-587B-42E4-9B30-74B80F4AA70F} failed.
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 Repliesusing c#,i need to Convert each page of a pdf file into separate images and display the images?
is it possible to do this without using 3rd party dll?
I need to incorporate some basic database functionality with no real need for speed.
View 3 Repliesdoes someone know the utility/procedure for converting an ASP.net project containing multiple files into one executable (.EXE) file?
View 3 RepliesI am looking for a way to design a simple HTML file, and in runtime - to load it as string to the c#.
I am trying to File.Open it, but it resides in a different location than the binary code.
is there a simple way to tell the build process to load it into a string?
I need to used openForecast.jar in my asp.net app, for that i read here and there and found IKVM, when i wrote in cmd
ikvmc openForecast.jar
then i got warning message like this
D:BobbyTelkom Projectikvm-0.44.0.5in>ikvmc OpenForecast-0.4.0.jar
Note IKVMC0002: output file is "OpenForecast-0.4.0.dll"
Warning IKVMC0100: class "org.jfree.data.time.TimeSeries" not found
Warning IKVMC0100: class "org.jfree.data.time.RegularTimePeriod" not found
Warning IKVMC0100: class "org.jfree.data.time.TimeSeriesDataItem" not found
Warning IKVMC0111: emitted java.lang.NoClassDefFoundError in "net.sourceforge.op
enforecast.input.TimeSeriesBuilder.<init>(Lorg.jfree.data.time.TimeSeries;)V"
("org.jfree.data.time.TimeSeries")
Warning IKVMC0111: emitted java.lang.NoClassDefFoundError in "net.sourceforge.op
enforecast.input.TimeSeriesBuilder.<init>(Lorg.jfree.data.time.TimeSeries;Ljava.
lang.String;)V"
("org.jfree.data.time.TimeSeries")
Warning IKVMC0111: emitted java.lang.NoClassDefFoundError in "net.sourceforge.op
enforecast.input.TimeSeriesBuilder.build()Lnet.sourceforge.openforecast.DataSet;
"
(org.jfree.data.time.TimeSeries")
Warning IKVMC0111: emitted java.lang.NoClassDefFoundError in "net.sourceforge.op
enforecast.input.TimeSeriesBuilder.build(Lorg.jfree.data.time.TimeSeriesDataItem
;)Lnet.sourceforge.openforecast.DataPoint;"
("org.jfree.data.time.TimeSeriesDataItem")
Warning IKVMC0111: emitted java.lang.NoClassDefFoundError in "net.sourceforge.op
enforecast.output.TimeSeriesOutputter.output(Lnet.sourceforge.openforecast.DataP
oint;Ljava.lang.String;)V"
("org.jfree.data.time.TimeSeriesDataItem")
I also found that openForecast consist of about 6 class files and 3 subFolder which each contains several class files..how to fix it (since the documentation of IKVM itself still getting me nowhere)
I have a file with .wsdl and i want .asmx file from that,Is there any way of converting file from .wsdl to .asmx .
View 1 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'm retrieving a binary file from the database, a .pdf file that I would like to let the user open and view. From what I can tell, there are two steps to do this:
1. Convert binary file to byte array
2. Convert byte array to file content
Here's what I've got so far:
[Code]....
This isn't working and I'm having a heck of a time trying to find a solution. I'm getting a blue squiggly under c1.docData in the Dim bArray line.
I 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 Replies