hi,
my sql database works fine from my desktop
however when uploading it to my web server it does not work.
i considered this could be the connection path to the database.
in visual web developer i attempted to modify the connection for the actual web address on the server pc like this:
C:Inetpubvhostsarcvillage.comhttpdocsApp_Datavillagers.mdf
this is the actual path on the server.
However visual web developer will not allow this because it says that this connection is not available ON MY PC.... so i cant save this new connection in order to upload it.
any suggestions please.... or am i barking up the wrong tree!
i need to upload a database(mssql2000) into a remote server.i usually generate script of the source database and run that script in the sqlanalyser in the server and generate all the tables,sp,views, etc. but not diagram. but currently i am using a diagram with relationship set between different tables in my local machine, i don't know how to upload this diagram to the remote server, if know any method pls reply.......
I'm trying to upload an image to a database along with some other info. I have a form to get all the info from the user that I want to put in the database. Everything's getting into the database except for the actual image data. When I do a "select * from table" query on the database, the Image field reads "err", however I have an imagetype field in the db and it reads "image/jpeg". I have the following code to get the image into the database:
I was following an example from the book "ASP.net unleashed" in Chapter 14, where it describes how to upload a file directly into the database. I got it to insert the file into my database as described, and with changes created a master and detail form to select the file and display it.. (which I assume had worked). Except, when attempting to access the file it gives two different errors. For a ppt file it gives:
The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
An invalid character was found in text content. Error processing resource 'http://localhost:3870/SeminarOrganiser/view_file...
and for a simple txt file:
The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
Invalid at the top level of the document. Error processing resource 'http://localhost:3870/SeminarOrganiser/view_file.aspx?...SELECT suggestEvent.suggestID, suggestEvent.uID, users.uFirstName, users.uLastName, users.uEmail, suggestEvent.suggestTitle,...From these two errors, I cannot really make sense of what has gone wrong or even why XML has even been mentioned. Looking around on the net has not allowed me any further progress.In any case, would anyone be able to explain to me what might have gone wrong?Alternatively, any links that may help would be greatly appreciated.Thank you very much in advance.
hi, From my ealier post I learned that a MDF file can be read and written to even if I did not attach the database in the SQL Sever Management Studio. Is that behavior because of the connection string where is has AttachDBFilename=|DataDirectory|DNN12_24_07.mdf , Is that what "attaches" the database? This runs on SQL Express2005. Should I change the connection string to: name="SiteSqlServer" connectionString="Server=(local);Database=ASPNET;uid=;pwd=;" providerName="System.Data.SqlClient" /> ? Is there a statment in the XML of web.config that defines |DataDirectory| of the original connection string that points to APP_DATA where the mdf file physically resides? Thanks in advance? -KK
hello, After I FTP a ASP.NET website to a webserver, APP_DATA directory and all, I then use the SQL publishing wizard to create a script on the local machine and run the script on the webserver/SQL server, it builds ok. But I get an error "another database with the same name". Duplicate of the database in APP_DATA directory that is already attached by the connection string. So this isn't correct. Second attempt: I FTP an ASP.NET website up to a server. Then I open the SQL management studio and attach the database in the website's APP_DATA folder. (never running a .sql script)The database attaches. The name of the database is the complete path to the database in the APP_DATA directory by default. The website functions. But if I try to look at a table I get an errors. It gets to the point the database will not even expand. Then I start getting errors in the browser that NETWORK SERVICE can not open it's default database. So the website fails also. So this doesn't work either.... So I guess my question is, should I remapped the path of |DataDirectory| before I FTP it? To a path where the other common system databases reside, (I don't think that would be necessary.) Then FTP the website without the contents of the app folder(no database). Then use the script built with the SQL Publishing wizard to build the database, and attach the database in SQL Management Studio? ( I'm afraid of over playing and corrupting the server). If I attach the database to manage it and the connection string attaches the database to run it, will I always get errors? What am I missing here? Thanks jamesqua for your help so far, I understood the blog you sent me too. But how do I modify it so I can use SQL Management studio to manage the database? Once again from My Uncle Bob "Things are simply awful, or awfully simple" -KK
Hi everyone! i am working on an web application database(asp.net,c# and sql server), wherein i wanna upload and retrieve different kinda files . so guys, plz do, give me some info abt how exactly i can carry out the task and if possible give me the snippet too(hmm,, very lazy....) thanx in advance regards kiran
This is probably a very simple question but i am having problems with inserting information into database The function takes the values "FirstName" And "LastName" from A table Called "Customer" and the value "ProductID" from a table called "Products" and inserts them into a table called " NewOrder". Everything compiles ok but when I press the button the information is not uploaded to thedatabase. ( There is no error message) This is the stored procedure CREATE PROCEDURE SP_NewOrder(@CartID char (36), @CustomerID Varchar (50))AS INSERT INTO NewOrder (FirstName, LastName, ProductID) SELECT Customer.FirstName, Customer.LastName, Products.ProductID From Customer,Products Join ShoppingCart ON Products.ProductID =ShoppingCart.ProductIDWHERE ShoppingCart.CartID = @CartID AND Customer.CustomerID = @CustomerIDGO This is the Function Public Shared Function CreateOrder() AS String Dim customerID As integer Dim connection as New SqlConnection(connectionString) Dim command as New SqlCommand("SP_NewOrder",connection) command.CommandType = CommandType.StoredProcedure command.Parameters.Add("@CartID", SqlDbType.Char,36) command.Parameters("@CartID").Value = shoppingCartID command.Parameters.Add("@CustomerID", SqlDbType.Varchar,36) command.Parameters("@CustomerID").Value = customerID Try connection.Open() command.ExecuteNonQuery() Finally connection.Close() End TryEnd Function This is the page code Sub btn3_Click(sender As Object, e As EventArgs)Dim cart as New ShoppingCart()Dim shoppingCartID As IntegerDim customerID As Integer = Context.Session("worldshop_CustomerID")cart.CreateOrder()End Sub Can Anyone see where I am going wrong Many thanks martin
i have created site on asp.net using database sql server 2000 . i want to upload database and tables on internet. But i dont know how to do that. Please help me. i have very less time.
Hi all, I want to upload a text file from a webpage and save the content to our SQL Server database, a BLOB image column. I got an error on [myData] in the following sqlparameter: Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData) - Value of type '1-dimensional array of Byte' cannot be converted to 'Integer' How to fix it? Also,Did I do the right code to upload a text file? Thank you. --------------------------------------------------------------------------- Sub UploadResume_Click(ByVal source As Object, ByVal e As EventArgs) Dim ResumeFile = uploadResume.PostedFile Dim contentType As String = ResumeFile.ContentType Dim contentLength As Integer = ResumeFile.ContentLength Dim myData(contentLength) As Byte ResumeFile.InputStream.Read(myData, 0, contentLength) If Not (uploadResume.PostedFile Is Nothing) Then Try 'upload file to SQL Server If Not conHRISDb.State = ConnectionState.Open Then conHRISDb.Open() End If Dim strSQL As String strSQL = "Insert into Mgmt_App_Resume_Table (Applicant_ID, App_Resume) Values (@AppID,@AppResume)" Dim objComd = New SqlCommand(strSQL, conHRISDb) Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData) objComd.Parameters.add(parmBlob) objComd.ExecuteNonquery() conHRISDb.Close() Catch exc As Exception conHRISDb.Close() End Try End If End Sub
Does anyone know how to upload (bulk) data from a client (written in Excel VBA) to a remote SQL2000 database? Of coarse I tried "INSERT INTO" and rst.addnew but I noticed this is much, much slower as downloading from the same remote database.
I am trying to upload a file in ASP.net 2.0 to a SQL database using the FileUpload control. I am doing this by way of a typed dataset.Here is my code.Dim rta As New ResponseTableAdapterDim rdt As ResponseDataTable = rta.GetResponseByID(1)Dim rr As ResponseRow = rdt(0)Dim fs As New FileStream(fu.PostedFile.FileName, FileMode.Open, FileAccess.Read)Dim br As New BinaryReader(fs)Dim image() As Byte = br.ReadBytes(fs.Length)br.Close()fs.Close()rr.UploadFile = imagerr.NameFile = fs.Namerta.Update(rdt)The code runs without an error but afterwards I find that nothing has been stored in the UploadFile cell in the database but the file name has been stored in the NameFile cell in the database. Any ideas?Your help is much appreciated. James
Hi, I'm developing a website using VWD 2005 Express, which needs a Membership system and a products database. Using the VWD inherent Web Site Administration tool makes the membership set up easy but by default it creates a 'Local' SQL database in a folder named 'Apps_Data' in the VWD project. My question is: considering I will need to upload my web site to a Hosting Service, would it be better to change the default so that the membership systems, and the product database I need, are created in an SQL 'Server' database instead of a 'Local' database? The hosting service I am considering using is having a bit of a problem understanding this question, I hope it makes sense to someone or am I asking a stupid question? Regards Sean.
I would like some help in uploading a database from my harddrive to a server using sql server management studio express.
If I try to attach it to the server, this program only looks at the files on this server and not on my harddrive. So how can I copy a sql database to my folder on the server.
I am sure it must be a simple problem, but I've been bizzy with it for about a day now. So, please advice.
I needed to recreate/publish a DDL and data file(of a database) that was produced using Database Publishing Wizard. The size of the file is 4G. I receive the following error when I try to open it up in the new query window of sql server 2005 (sp2)for execution.
"The operation could not be completed. Not enough storage is available to complete this operation."
I know my server has 829G of free storage space available. i receive no errors when I open up a smaller file also created by database publishing wizard.
I am new with Visual Web Developer SQL Express and for a start I have been using the VWDHosting.net (Trial hosting for VWD 2005 Express) with a test website using login and membership controls. I followed the excellent instruction in the User Guide (for transferring data and adapting the connectionstring) and it worked succesfully. However, I have problems getting the same test website installed with my hosting provider.The VWDhosting.net has a special functionality for uploading the contents of a local database to a database created on the server. In the Restore database section is a field the "Restore database from SQL Server 2005 mdf file". After selecting in that field your local database, you can click the "Attach"-button and then the contents of the local database are transferred to the database on the server. With my hosting provider (using SQL Server 2000) I have to use the same procedure: creating a MS SQL database on the server and then transfer the contents of my local database. How can I do this? (My hosting provider does not offer me a similar "Attach" button).Do I have to use SQL Server Management Studio?Kees
All right, I've got a small sample of database-driven code running nicely on my own computer using an MS SQL database with code something like this to connect to it. (passwords and user ID's changed to protect the innocent)
Now, I want it to run on a web server, but there doesn't seem to be any simple "click here to upload your database without tearing your hair out in frustration" button. Only an option to "add ODBC data source" which has the following fields: data source name(dsn): ________ ODBC Driver Name: SQL Server (this value cannot be changed) DSN Description: ________ Associated SQL Server:_________ Default Database Name:_________
Without any option to upload any database files, though if I go into file manager, I notice that there is an MSSQL folder, which I assume I should be uploading the database into. But which file(s) from my database should I upload and what should I fill the blanks above in with? Thanks in advance. Do I have to change the connection code?
Hi There are so many records to upload into sql server DB.we have to use scripts for this?I don't know about script.How it will be usefull and how to implement ?please help me.Thanksswapprose.
I want to upload csv/xls file with more than 65000 of records.But i get an error after sometime 'Timeout Expired' while uploading into database.can anyone help me how to solve this problem.its very urgent.
In my web application I am using tables with more than 100 fields. I build such tables in my PC by means of Server Explorer. If I am not wrong such tables reside in the App_Data folder. When I upload my application to my Web Host I would like not to build hem again. Is there any procedure to easily reuse the already built tables and to maintain them? My Web Host provides unusable instruments to rebuild long tables. To connect to them a new Connection String is required.
I have yet to create a query string that works and it is beginning to drive me insane. I am trying to allow a user to upload a word document into my SQL 2000 database. However I always seem to get an error when it comes time to insert the file. The table has 5 fields memnumber, papertitle, and file type are all varchar. Length is an integer and actual_file is of type image. Here is my string command = "INSERT INTO resumes (memnumber, papertitle, length, filetype, actual_file) VALUES ( '" & TextBox1.Text & "', '" & rightname & "', " & length & ", '" & type & "', " & filer & ")" I can't tell you how many different versions of this string I have tried to run with none of them working, so the errors I have gotten have been varied. Most of them tell me either I can't use the & operator with file type image or that string or binary data would be truncated.
Hello!! i need to upload a csv file to sql server, i am trying to load using bcp or bulk load, but the files has null columns, so i guess, that's why the program is displaying error.
my table is as follows:
PK COLUMN TYPE SIZE NULLABLE ----------------------------------------------- PK Object_id int 4 NO SO varchar 4 NO FISY smallint 2 NO Segment_id varchar 3 NO SubSeg_id varchar 3 NO Line_id varchar 4 NO Level smallint 2 NO Type varchar 1 NO WWB_id varchar 3 YES SC_id varchar 6 YES PL_id varchar 9 YES PS_id varchar 12 YES PSS_id varchar 18 YES Material_id varchar 18 YES WWCC_id varchar 2 YES
THE OBJECT ID IS THE IDENTIFIER, SO IT SHOULD UPLOAD AUTOMATICALLY
Greetings, Salutations, and Howdy I'm using VWD on the local box and WS 2003/SQL Express on the remote box. The first time I upload the site, the upload works great. Later after uploading updates, new pages, etc. the upload still works great. BUT.....when I try to upload anything in the App_Data folder, I get a copy error, access denied. On a pre-existing site with App_Data ....How do you upload the App_Data folder or it's contents to the remote server? Thanks^2
i am trying to upload images from an asp.net or vb.net front end to a sql server db. I can upload the image fine if I first save the image to a file and then upload but my question is whether I can upload the image without first saving the image file. What i would like to do is to capture an image with a digital camera and without saving it first (an extra step for the user), upload it to a sql server db.
Hello, I have 3000 images to upload in SQL. I have a page that does it in ASP.net 2.0 1 by 1 but i am looking for a faster way. The targeted table look like this *ID (int) ImgSize (int) ImgContentType (nvarchar 50) ImgFile (image) Thanks for the help.
Iam currently loading the data using dts by way of exporting the tables in textfile and then importing it at the destination. But this takes hours to do that. So i would like know best way for a big database.
Can somebody please tell me what I am doing wrong or need to do to resolve my issue. I having problems with one of the columns in an excel spreadsheet that I am trying to upload into the system. One of the columns contain values of both text and numbers such as 'ABC123', 'ABC124', '123456' etc. When I try uploading the sheet into SQL Server 2000 using DTS, the system removes all characters from the one column that I am having problems with. So entry 'ABC123' for example would be truncated to '123'. I tried formatting the column that I am having trouble with in excel to 'General' format as well as tried to transform the column to type varchar in SQL Server while using the DTS wizard but still had no luck. The problem is that SQL server thinks that the column is a float type column from the source and therefore truncates any characters.