Urgent -- Uploading Database And Tables On Internet

Jul 2, 2007

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.

 

 

View 5 Replies


ADVERTISEMENT

Uploading SQL Tables

Dec 26, 2007

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.

View 1 Replies View Related

Urgent:: Move Tables From One Database To Another Database??

Aug 27, 2007

hi,
I have a access database. In this database there are 10 tables and this tables are related to each other.
I want to move these tables to another database according to a field in XYZ table (vertical fragmentation).

for example there is name coloumn in the XYZ table and I want to take only joe lines and other tables related to that from database A and move it to database B

how can I do this?
thanks..

View 1 Replies View Related

Uploading An Sql Database

Oct 3, 2006

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 Related

Regarding Uploading A Database

Jan 22, 2008

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.......
 
 
 
 

View 1 Replies View Related

Uploading Image To Database

Nov 4, 2006

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:

View 2 Replies View Related

Uploading Files To SQL Database

Mar 19, 2006

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.

View 1 Replies View Related

Explain To Noob, Database Uploading

Dec 25, 2007

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
  

View 1 Replies View Related

Correct Way To Attach Database When Uploading.

Dec 26, 2007

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

View 5 Replies View Related

Uploading Different Kinda Files Into SQL Database :((

Apr 6, 2005

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 

View 1 Replies View Related

Difficulty Uploading Information To Database

Dec 1, 2005

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

View 2 Replies View Related

Uploading Data From A Different Type Of Database

Dec 22, 2006

How do I upload test data from a frame maker database to SQL database tables using ODBC.

View 6 Replies View Related

Question About Uploading A File From Webpage To Database

Oct 7, 2005

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 Related

Fast Uploading Data From Client To SQL2000 Database

Mar 4, 2005

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.

Thanks.

View 3 Replies View Related

Uploading A File To A SQL Database Via A Typed Dataset And Using The FileUpload Control.

Oct 2, 2006

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 Related

SQL 'Server' Or 'Local' Database For Uploading To Hosting Service Provider

Mar 23, 2007

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.

View 2 Replies View Related

Uploading Database To Sever With Sql Server Management Studio Express

Jun 28, 2007

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.

View 7 Replies View Related

Errors When Uploading DDL And Data File Created By Database Publishing Wizard

Jul 17, 2007

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

View 3 Replies View Related

Connect To Database That Is Onto The Internet.

May 3, 2008

I have 2 instances of SQL-Server 2000  running on my computer.
I connected to them through SQLServer enterprice Manager.
Now I want to connect to a  Database that is stored on my WebHosting-Site [on INTERNET]   
The Server-IP address is 65.22.42.57.etc..........
WHILE I can connect to That Database from Visual-Studio     server-Explorer..........I cannot connect to that server from SQLServer-EnterpriceManager.
It says 'You need to use SQLServer 2005 tool'.
But there is no Connect-word to create a connection in 'SQLServer 2005'-Manager.'
 
 
HELP I need to connect , what shall I do ?
 
 
EXPERTS.
 

View 2 Replies View Related

Database Access Over Internet

Oct 15, 2005

I was wondering if any body has used Internet as a WAN (Wide AreaNetwork) to provide database access. I know about web services but Ilike to experiment with using Internet as a extended network (webserver behind one router and database behind another). Any ideas onwhere to look for this?Thanks

View 3 Replies View Related

Uploading Tables On Sql Server (domain Server)

Mar 11, 2000

Hi everybody,

Please suggest me a guideline to upload tables on sql server
for internet based application.

Actually I want to know the exact procedure what are the files to
upload (of sql server) OR i have to export the whole database
to the domain server.

Thank you
Harish

View 1 Replies View Related

How Do I Publish Sql Express Database In Internet?

May 29, 2007

Hi all,
There is a sql express database .mdf file which I can access locally through local web pages using windows authentication and integrated security = true.
Now I want to publish this db and the web pages to my hoster's server so as to access the db from internet.
The connection string currently is in the web config as below:<add name="NORTHWNDConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|NORTHWND.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />     The database is currently located in the App_Data folder.
Please give me some step by step solution to configure the db to access from internet. Thanks a lot in advance.

View 1 Replies View Related

Build Database Application On Internet With ISP?

Jul 20, 2005

I have been building ASP, ASP.NET and Crystal Reports on SQL serverfor a few years now.I have build them mostly on an Intranet or with companies that havetheir own web servers.I now need to build an application for a company that doesn't not havea web server. Just a small shop that wants an internet application.How do I build an database application when the site will be host byan ISP? The database will be SQL Server 2000, but located locally.The site will be maintained by the ISP? How does the an applicationhosted by an ISP interact with a database located locally (client'ssite)?If someone could point me toward some tutorial or tell me how to dothis, I would appreciate it.

View 1 Replies View Related

How Can I Attach The Database From Internet(ftp Site)?

Mar 26, 2008



Hi,

I wanna attach to the database from our domain(ftp site) . it is not in the our network..

thanks,
J

View 3 Replies View Related

Attach MySql Database Via Internet

Sep 23, 2006

Hie !

Please, how to manage (attach,connect to) MySql database located on host server http://www.avanti.si from my home PC with Microsoft SQL Server Management Studio Express? This "http://www.avanti.si:8080MySqlDatabaseName,3306" fail !

Thenks!

View 4 Replies View Related

Updating Central Database Over The Internet

Jul 21, 2006

Hi, I've spend quite a bit of time on this but no luck. so any help is really appreciated.

I'm writing a class library dll that would pull data from a central db to offsite comps, manipulated then updated it back to the central db, much like systems salemen would use. Please keep in mind that i'm talk about LARGE amount of data. I want downloaded data to be manipulated on the client computer(without direction connection to db server) with EXCEL or something of the likes then upload changes back to the central DB.

Is there anything in SQL Integration Services that would help me? please keep in mind that data are distributed to computers over the internet, not on the same LAN. Please be as specific as possible

i'd really appreciate any help you guys can provide, thanks.

Vu,

View 4 Replies View Related

How To Move A SQL Database To Another Server Over Internet

Nov 7, 2007



Hi,

Here is the situation:
My SQL server is in B'lore. I need to transfer the Database from the B'lore server to a new Server in California.

Kindly let me know how it could be done.

Thanks in advance.

View 2 Replies View Related

SQL Server 2005 Express Database On The Internet

Jul 12, 2006

Hey all!I am hoping that somebody will be able to help me getting my database working over the Internet.I am using VS 2005 and SQL Server 2005 Express Edition and have my database set up within a web site project in VS under the App_Data folder.Everything runs smoothly when running the application on localhost I am just facing a problem when I attempt the same thing after uploading my pages to my web server.I am receiving the following error:An error has occurred while establishing a connection to
the server.  When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified)I have tried enabling the disabled SQLEXPRESS protocols and disabled my firewall with no luck.I have also looked into using localhostsqlexpress as the server name but I dont see how this method would work as it appears to only run a database on the local machine which is the problem I have currently.Could anybody help me with this problem? I have only just started trying to use SQL Server Express as a means of database connectivity and I am not exactly sure how it all works.Thanks

View 1 Replies View Related

Database Connection On My WebSite ,I Published On Internet.

Nov 9, 2007

I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?

View 4 Replies View Related

Access Data On A SQL Database Stored On The Internet

Feb 9, 2008

How can I store my database on the internet and then access it's data (from a Visual Basic Express Windows Application)?

Where on my server do I upload it to?

How do I keep it secure?

Can anyone reccomend any good articles, etc, please?

Thank you for your help.

Sam

View 3 Replies View Related

Uploading An SQL Server Express Database To A Server

Oct 8, 2006

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 Related

System Tables (Urgent)

Jul 10, 2002

Hello,

I've one Sybase DBA asking this question, Is this really true, Pls help me.

Due to architectural changes in SQL Server 7.0, you cannot dump the transaction log if a database's system tables are inaccessible (due to media failure, for instance)in 7.0 and later versions. Microsoft recommends that separate devices be used for system tables and user tables to allow a final log backup to take place in the event the data device is inaccessible. The additional exposure incurred by not doing this is possible loss of data for the interval between the last transaction dump and the point of failure.

Thanks
Qinglee

View 1 Replies View Related

System Tables,Urgent!!

Oct 24, 2001

HI all,
I need to understand a little bit more about SQL Server built in tables. For example in Oracle if I need to check for tables names under one database. The query will be something like this:

Select table_name from user_tables;

Or to get column_name and table_names:
Select column_name, table_name from user_tab_columns;

How can I do this in sql server 7?
I know there is a table called sysobjects. The sysobject will give me all the objects in the database but how can I specify wether its a table or a column. More over can someone refer me a good book for sql server 7. Both development and administration.
Thank you in advance!!!!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved