DataSource Controls :: MSSQL And Plesk?
May 17, 2010
I asked plesk the following question:I've been through the documentation and scoured various forums, but I can't find a defintive guide to uploading an mssql db (contained in a app_data folder) to the server and conecting it via the Plesk control panel. I've created a db and user via the panel but how do I get the actual db to the server and get it to work?"and they replied:"For database restoration please upload your database backup file ( i.e. .bak ) under your hosting space and update us the exact path where you place this file + your database login details ( i.e. database name , database user name and password ). So we restore this database for you. "
View 3 Replies
Similar Messages:
Jan 27, 2010
I am about to get my sites hosted with a local host company. They are offering me their lowest cost MSSQL server, which is the web edition. So my question is what is the difference between that and 2008 express edition? Can express edition be used for a full fledge in production website? And does Web implies that I will be interacting with it via the web correct. Lastly, if the web version is not chosen what is the typical protocol for uploading and maintaining a site when you have a dedicated server. Do you normally have to go to the data center or is there like a web portal that can be used. I will be asking the guys at the company these questions as well, but I want to make sure I get another opinion on the issue.
View 1 Replies
Apr 11, 2010
How do I import this XML: [URL] into MSSQL?
View 5 Replies
Jun 1, 2010
I was wondering what you guys thinks is the most efficient way to select data from a msSQL database.. I tend to use a sqldatareader, but is this really the best way? - It is particularly impractical if one also must take into account, that the table may be "Null"?:
[Code]....
[Code]....
View 3 Replies
Jul 7, 2010
On the internet we bought/hired a CRM product. When we enter a new project this datarecord (on their MSSQL DB) is transferd to our local MSSQL DB.
Internally we got a seperate application that uses the project information.
So after an insert project on the CRM side (on the internet) the data is transferred to our DB. When i check the internal application I see the project. All nice and sweet.
BUT when I alter (UPDATE) a project in the CRM internet application this data is pushed to our DB and i see the data in the table. But it doesnt show up in the internal webapplication. When i restart the website in IIS it still doesnt. Only when i restart the entire IIS the data is updated in my internal application.
Used techniques:
.NET 3.5MSSQL 2005LINQ to SQL The only thing i can imagine is that LINQ to SQL has a own cache or something. If so... how to disable it
View 1 Replies
Jan 14, 2010
How can I select a random row and then update or delete it? I've found how to get a random row, using SELECT TOP 1 column FROM table ORDER BY NEWID() do I have to make another select using this result in order to update the row, or it can be done more efficiently?
View 10 Replies
Feb 22, 2010
using c#, i have an array where i want to test every single line of this array if it is already contained in a table of a database. if not, i do an insert. the test if the line is already in the table is performed using update, if update fails i insert the line. this works BUT the table contains 100000 entries, the arrays i want to compare/insert contain appr. 5000 entries. so, i is really slow and takes minutes.
View 7 Replies
Oct 22, 2010
i was trying to upload from an .xls file to microsoft sql server.What i did was i upload the file to a folder in server and pick the record from the folder. This work on development machine but on getting to a iis server to test the application i got an error that was saying the root folder for the www root for the folder was not found. Below is the code.
<pre lang="msil">protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = FileUpload1.PostedFile.FileName;
string saveDir = @"";
string appPath = Request.ApplicationPath;
[Code].....
View 1 Replies
Jun 9, 2010
In remote db, I can be able to connect ms sql db as localhost in my connection string like below,
<
add
name="ConnectionString"
connectionString="Data
Source=localhost;Initial Catalog=DBServer;Persist Security Info=True;User ID=sa;Password=*****"
providerName="System.Data.SqlClient"
/>
This is running in server and its working fine.
If i want to make any changes in db structure or need to modify any data values, i have to login remotely to my server and has to open sql server management studio do db change or value editing stuffs. Its really getting iritating when the remote machine looks slow.
I just want to know how to configure the db hostname like dbname.domainname.com or mssql.domainname.com in server, so that we can open the server db in local using sql server management studio.
The application installed in windows server 2008 and using IIS 7.0 & SQL Server 2008
I have only little knowledge in server.
View 6 Replies
Mar 19, 2010
I'm an experienced PHP programmer that is new to ASP.net (C#). I'm trying to figure out how to do a manual echo of a specific field from an SQL database and was wondering how you do an if condition in case the field would meet certain criteria ?
What I want the script to do is check in the database if a certain condition is activated, then the html page should echo a windows media player object with the source of the video coming from the database itself ( $line[Video], and if the condition isn't active then either don't echo the player or just echo an old video (in the script I'm just printing a message).
in PHP:
[Code]....
View 9 Replies
Feb 5, 2010
I use a calendar to pick a date that I want to store in my MSSQL Database. I use the form format, like 2010-01-27 (european date format) with no time info. What MS SQL Date-type should I store this date in?
View 4 Replies
Jan 7, 2010
Im trying to import a semiolon seperated file into mssql db 2000 table and I need your help.I can read the file and present the content in a for loop, but I would like to extract values at certain possions.Like "Fel Beskrivning;Konktakt förare; and so on.
View 2 Replies
Sep 24, 2010
I want to create ftp account in plesk using asp.net so that whenevrever user register in site can have an ftp account with his username and password. Please help me with what approach to follow (code example) and what api's does asp.net include for this...??
View 3 Replies
Feb 23, 2011
i m developing web application in asp.net .Trying to deploy it.i m doing first time.I have uploaded my folder on plesk.But now hot to connect with database?How to connect physical server to database server on plesk 9.5?
View 3 Replies
Oct 23, 2010
I am new for web hosting.My hosting provider use plesk panel for manage websites.I have created MS SQL database using plesk panel. but every time I am getting error when trying to connect ro database. I am using the following connection string.
<add name="ACN" connectionString="Data Source=209.59.179.205SQLEXPRESS;Initial Catalog=ACN;User ID=xxxxx;Password=xxxxxx" providerName="System.Data.SqlClient" />
U can check error detail by just clicking on Login button on [URL]
View 2 Replies
May 19, 2010
i want to create application that register host and domain in pleskany guya have sample? or source code? or documentation
View 1 Replies
Jan 14, 2011
I was trying to upload the database of my ASP.NET website. On the local machine, if I copy the database from another machine, I have to attach it through SQL Server Management Studio and then use it in the connection string like
[Code]....
My database is approx. 10 MB in size for now. If I upload it via ftp to App_Data folder, how would I have to attach this database?In Plesk, I have the option to create the database and its user (as shown in the screenshots):1) Web Applications and services-Plesk2) Add New Databaseand add new database user3) Webadmin>ASP.ET Enterprise ManagerBut this is for the new database I created. My problem is to upload an existing one.There's also a section in Plesk for ASP.NET settings (as shown below)
This has the option to change the connection string etc.I also asked my hosting provider about the method to be followed for attaching the database that I would upload. This was the reply in quote." mdf ldf files perhaps will be working at your local computer but this way database of mssql will not work on web server as on web server you will be required to create and restore your database backup file using plesk control panel.
Sample connection string for asp.net
mssql `Standard Security`:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
Server name to be used in coding: localhost Catalog/ database name , database user and database password you will be required to create your own using plesk control panelI would be really be appreciative for the steps I have to take to upload my existing database. How do I have attach it? What connection string I have to use?
View 1 Replies
Nov 22, 2010
I've been using a standard web site in Visual Studio for my site, using the Plesk file manager interface to upload files either singly or in total as a .zip file.Recently I've changed the project to a VS web application.All the documentation that I see refers to using IIS to deploy a web app; if I wanted to just FTP all the source code, I may well have stayed with web site.I've not been able to find any Plesk specific deployment info.
View 1 Replies
Apr 23, 2010
I have encountered the task of saving an image to a MsSQL Server Database. (Although I haven't even managed to do it yet).
But anyways I need to link this image from the MsSQL Database to Gridview. Can this be done ?
View 2 Replies
Sep 13, 2010
I have a database which stores .png images as the sql "image" type. I have some code which retrieves these images as a byte[], and sends them to the page via the FileContentResult object in .Net. Performance is key in this application, and the images have to be retrieved and displayed as quickly as possible. My question is, can this operation be performed quicker by passing a byte stream from the database to the browser, and not at anytime storing the whole byte array in memory. If this is possible and worthwhile doing, how do I do it?
Here is the code I have so far:
[code]....
View 3 Replies
Sep 2, 2010
I would like to know how i can take a backup of my database to .bak file on my pc using asp.net code?
View 8 Replies
Aug 15, 2010
Is it possible to create a wap having a mssql connection?
View 1 Replies
Mar 24, 2011
I often hear the term database driven web app and just wanted to make sure using that description is the most accurate when describing an asp.net web app that relies on an SQL Database for all of its dynamic information.
What specifically is the correct terminology.
View 2 Replies
Feb 12, 2011
I have created a C# registration page that includes a secret question and answer. The secret questions are in a dropdown list. When the form is submitted, all field information gets written to my mssql database successfully but the value selected in the dropdown ListItem gets NULL inserted instead of the question.
What am I missing? Here is my code.
[Code]....
View 1 Replies
Dec 23, 2010
This may not the best place for this question, but I'm going to give it a shot. I have a large (3GB) file that contains maybe 100 fields, CSV. ALL FIELDS are surrounded by double quotes, a standard CSV file. So, it looks like this:
"12345678", "SMITH", "JOHN", "GARLAND, TEXAS", "75043","","","","37" (and so on)
I need to import this into SQL server but have been unable to find any simple way of doing so using the BULK INSERT. I could obviously do it with some coding [a lot, given the number of fields] but one would think a product like MSSQL would have this most basic of functionality built in.
View 3 Replies
