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.......
hi,my sql database works fine from my desktophowever 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!
View 8 Replies View RelatedI'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:
View 2 Replies View RelatedI 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
How do I upload test data from a frame maker database to SQL database tables using ODBC.
View 6 Replies View Relatedi 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
View 1 Replies View RelatedDoes 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.
Thanks.
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
View 1 Replies View RelatedHi, 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.
Hello,
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.
Rgds,
Wouter.
Hi,
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.
What possibly is causing this?
Thanks in advance
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
View 1 Replies View RelatedAll 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)
connect_String = _
"Data Source = mysource;User ID=joeblow;Password=monkey;database=Reservation"
db_conn = New SqlConnection(connect_String)
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.
View 1 Replies View RelatedI 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.
View 1 Replies View RelatedIn 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.
View 1 Replies View RelatedHi,I really appreciate any help from somebody that could help me on how I can upload images in a GridView or DetailsView using ASP.NET 2.0 - VB.NETI have looked on the internet, but could not find any example....Here are my pages :ASPX-Page :
<asp:SqlDataSource ID="SqlDataSource2"
runat="server" ConnectionString="<%$ ConnectionStrings:IMMOASPNETDBConnectionString %>"
DeleteCommand="DELETE FROM aspnet_BuyGroundImages WHERE (BuyGroundID = @Original_BuyGroundID)"
InsertCommand="AddImage" SelectCommand="SELECT BuyGroundID, BuyGroundDescription, Image1, Image2, Image3, Image4, Image5, OptionOn, Sold, Price FROM aspnet_BuyGroundImages" UpdateCommand="UPDATE aspnet_BuyGroundImages SET BuyGroundDescription = @BuyGroundDescription, Image1 = @Image1, Image2 = @Image2, Image3 = @Image3, Image4 = @Image4, Image5 = @Image5, OptionOn = @OptionOn, Sold = @Sold, Price = @Price WHERE (BuyGroundID = @original_BuyGroundID)" InsertCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="Original_BuyGroundID" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="BuyGroundDescription" />
<asp:Parameter Name="Image1" Type="Byte" />
<asp:Parameter Name="Image2" Type="Byte" />
<asp:Parameter Name="Image3" Type="Byte" />
<asp:Parameter Name="Image4" Type="Byte" />
<asp:Parameter Name="Image5" Type="Byte" />
<asp:Parameter Name="OptionOn" />
<asp:Parameter Name="Sold" />
<asp:Parameter Name="Price" />
<asp:Parameter Name="original_BuyGroundID" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="BuyGroundID" Type="Int32" />
<asp:Parameter Name="BuyGroundDescription" />
<asp:Parameter Name="Image1" />
<asp:Parameter Name="Image2" />
<asp:Parameter Name="Image3" />
<asp:Parameter Name="Image4" />
<asp:Parameter Name="Image5" />
<asp:Parameter Name="OptionOn" />
<asp:Parameter Name="Sold" />
<asp:Parameter Name="Price" />
<asp:Parameter Name="LastUpdated" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="BuyGroundID" DataSourceID="SqlDataSource2" Height="50px" Width="125px" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" GridLines="Horizontal">
<Fields>
<asp:BoundField DataField="BuyGroundID" HeaderText="BuyGroundID" InsertVisible="False"
ReadOnly="True" SortExpression="BuyGroundID" />
<asp:BoundField DataField="BuyGroundDescription" HeaderText="BuyGroundDescription"
SortExpression="BuyGroundDescription" />
<asp:TemplateField HeaderText="Image1" SortExpression="Image1">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Image1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" />
<!-- <input id="File1" type="file" language="javascript" runat="server" />
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Image1") %>'></asp:TextBox> -->
</EditItemTemplate>
<InsertItemTemplate>
<input id="File2" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Image1") %>'></asp:TextBox> -->
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Image2" SortExpression="Image2">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Image2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<input id="File3" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Image2") %>'></asp:TextBox> -->
</EditItemTemplate>
<InsertItemTemplate>
<input id="File4" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Image2") %>'></asp:TextBox> -->
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Image3" SortExpression="Image3">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("Image3") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<input id="File5" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Image3") %>'></asp:TextBox> -->
</EditItemTemplate>
<InsertItemTemplate>
<input id="File6" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Image3") %>'></asp:TextBox> -->
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Image4" SortExpression="Image4">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("Image4") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<input id="File7" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Image4") %>'></asp:TextBox> -->
</EditItemTemplate>
<InsertItemTemplate>
<input id="File8" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Image4") %>'></asp:TextBox> -->
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Image5" SortExpression="Image5">
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("Image5") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<input id="File9" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("Image5") %>'></asp:TextBox> -->
</EditItemTemplate>
<InsertItemTemplate>
<input id="File10" type="file" language="javascript" runat="server" />
<!-- <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("Image5") %>'></asp:TextBox> -->
</InsertItemTemplate>
</asp:TemplateField>
<asp:CheckBoxField DataField="OptionOn" HeaderText="OptionOn" SortExpression="OptionOn" />
<asp:CheckBoxField DataField="Sold" HeaderText="Sold" SortExpression="Sold" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" ButtonType="Button" />
</Fields>
<FooterStyle BackColor="White" ForeColor="#333333" />
<EditRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="White" ForeColor="#333333" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
</asp:DetailsView>Code behind page:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class gronden
Inherits System.Web.UI.Page
Protected Sub DetailsView1_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdateEventArgs) Handles DetailsView1.ItemUpdating
Try
'copy file data into record?
Dim upload As FileUpload = CType(Me.DetailsView1.FindControl("FileUpload1"), FileUpload)
If Not upload Is Nothing Then
If upload.PostedFile.FileName <> "" Then
'copy file to a byte array in memory
Dim data(upload.PostedFile.ContentLength) As Byte
upload.PostedFile.InputStream.Read(data, 0, upload.PostedFile.ContentLength)
'get filename part only
Dim filename As String
Dim tmp As Integer = upload.PostedFile.FileName.LastIndexOf("")
If tmp >= 0 Then
'strip directory part
filename = upload.PostedFile.FileName.Substring(tmp + 1, _
upload.PostedFile.FileName.Length - tmp - 1)
Else
filename = upload.PostedFile.FileName
End If
'save this to the fields
e.NewValues("Image1") = data
e.NewValues("FileName") = filename
e.NewValues("Contenttype") = upload.PostedFile.ContentType
End If
End If
Catch Ex As Exception
Response.Write(Ex.StackTrace)
End Try
End Sub
End Class
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.
We are building an ASP application with SQL Server 2000 as a back end.
What is the best way to upload images to the server?
Thank you,
Anastasia.
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
MY FILE IS SOMETHING LIKE THIS:
SO FY SEG SUBS R NIV TIPO WWB SC PL PS PSS MAT WWCC
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100111 300081 NULL
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100111 300084 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CIO 102705453CIO100282 300180 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CIQ 102705453CIQ100284 300182 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CIR 102705453CIR100285 300183 NULL
4500 2008 100 110 R1 6 E 102 102120 102120167 102120167CIF 102120167CIF100255 300256 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CJB 102705453CJB103026 300279 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CIP 102705453CIP100283 300726 NULL
4500 2008 100 110 R1 6 E 102 102120 102120167 102120167BED 102120167BED100249 300922 NULL
4500 2008 100 110 R1 6 E 102 102120 102120164 102120164BDM 102120164BDM103231 301189 NULL
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100114 301730 NULL
4500 2008 100 110 R1 6 E 102 102443 102443542 102443542DFJ 102443542DFJ102704 301731 NULL
4500 2008 100 110 R1 6 E 102 102705 102705453 102705453CIP 102705453CIP100283 301882 NULL
4500 2008 100 110 R1 4 E 102 102120 102120167 102120167CII NULL NULL NULL
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100111 302346 NULL
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100111 302347 NULL
4500 2008 100 110 R1 6 E 102 102120 102120159 102120159BBT 102120159BBT100111 302349 NULL
the first colums(identifier/object id) doesnt appear in the file, since it is supposed to be set automatically.
the last column is a null value.
Do you have any ideas??
why is it displayiing me an error?
which is the easiest way to upload the file??
thanx in advance
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
Hope someone can help with this.
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.
Is this even possible.
Thank you,
Biirir
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.
View 3 Replies View RelatedHi, may i noe how to upload the report servicing such dat i could view throu local host? TIA
View 4 Replies View RelatedCan 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.
View 2 Replies View RelatedScenario: I have 80 RDL files which will be delivered to a customer to upload into their SSRS database.
Issue: Is it possible to bulk upload RDL files into SSRS instad of loading each file individually ?
If anyone has found any information on this and can direct me to it, I would be very grateful.
Thanks.
Hi All,
I have created my first database in SQL Server 2005 Express and would like to try putting it online.
I asked the web host to create an account. They gave me host name, database name, username and password.
The problem is that i dont know where i enter that information.
I cant find the answer in my books or online. The host said i needed MSSQL Enterprise manager.
Can i get this with the Express or do i need to pay for a different version of SQL Server? If Express has it, where do i find it please?
Any help much appreciated, as i'm completely lost!
Kind regards,
Justin