I don't know, is this a right question to ask but my question is like is
1:- In my system sometimes i use sqlexpress(server name ".SqlExpress") and sometimes i use full version of sql server (server name "(local)").
2: What i wanted to do that is if i am using sqlexpress then server name should be passed as .SqlExpress and if i am sql server then sever name should be passed as (local).
I created web form which gets data from local database (SQLEXPRESS). It gives me an error when I publish the website. I can upload regular aspx page into my site. It works fine. How can I publish data-driven web form into my website?
View 8 RepliesI have a server that doesn't have MSSQL, can I use the default SQLExpress database somehow on the server to store my provider information? Or do I need to use a different databse with custom providers?
View 1 RepliesWhat is the best way to move my ASPNETDB.MDF from SQLExpress 2000 to SQLExpress 20005 on anothere server
View 2 Replieswhen generating local resources by using ( "Tools"->"Generate Local Resource" ) i noticed that some controls disappear in run time.
is good to take advantage of Visual Studio to automatically generate it? or is better to create resource files and add meta:resourcekey="..." to my page manually??
i have two tasks to accomplish. There are several pdf files (invoices) sitting in web server. My tasks are 1) enabling Olga to download multiple invoices into her local computer WITHOUT prompting any dialog box. 2) printing these files then automatically by default local printer from her desktop computer. How is possible this? She has birthday soon. No gift could be better than this solution as she has to open each pdf separately and hit print button about 40 times a day.
View 1 RepliesI'm developing an ASP.NET Website locally using Web Developer Express Edition and publish my site via ftp to the remote host. Problem: Locally I'm using path settings to xml files etc. different from the remote paths. So each time before I publish my site I have to set the remote paths explicitely commenting out the specific lines of code.
Sample:
if(local) {
XDocument loaded =
XDocument.Load(@"<localpath>jobitemssample_" + companyId +
".xml");
else{
XDocument loaded =
XDocument.Load(@"<remotepath>datajobitemssample_" + companyId + ".xml");
}
How can I achieve an automatic setting mechanism on deployment. How do I know how to set local?
I used visual studio 2008 and sql server 2005(for database) in my website project. After finishing my project i used publish to web option and got the files into an folder. I have installed .NET framework ,IIS, i have also set the remote connection ,firewall setting etc. But when i run i.e., In the IIS manager when i click browse it gives me the following error. Can anyone pls tell me what went wrong in this. My code works fine when run on visual studio 2008. Server Error in '/EBUSINESS' Application.
View 1 RepliesI am wriyng an ASP website for my use on my local PC.
I have setup IIS and eveything works OK apart from accessing my SQL database. As I'm new to this I did not realise that you need to change the connnection string to reflect the place where the DB will be.
Having tried various options like http://localhost/ & db name, without succes I'm looking for some help.
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING
MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.
I want to restore .bak files from a server directory into database. The problem is it should behave automatically. Whenever a .bak file will be uploaded in that specified directory of the server that file will be restored. It may happen by using sql procedure which will restore all the .bak file which it will find at a certain time in that specified directory. Or, it may happen by using asp.net program which will run exclusively on server and call a sql procedure to restore a backup file whenever a backup file will come in that specified directory. But I am not getting how to figure out this ideas programetically.
View 2 RepliesMy codes below are to insert a new data into the database. The thing is, this code can insert the primary key(DeviceID) into the database automatically but I cant seem to find the code to insert the primary key into the database. point me the statement that insert primary key(DeviceID)..
This is the snippet of the submit button event
Protected Sub SubmitDevice_Button_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitDevice_Button.Click If Session("canUploadBool") = False Then ClientScript.RegisterStartupScript(Me.GetType,
"canuploadScript", "")
Exit Sub
End
Dim insertNewProcess As String = "INSERT INTO Device_Table("
Dim deviceColumn As String = "DeviceRevision, CustomerName, CustomerCode, CustomerResponsibleEngineer, Date, DevicePartNumber, PackageType"
Dim deviceValue As String = ") VALUES ('01', '" + CustNameDropDownList.SelectedValue.ToUpper + "', '" + CustCodeLabel.Text + "', '" + CustomerResponsibleEngineerTextBox.Text.Trim.ToUpper + "', '" +
Format(Now, "dd-MMM-yyyy").ToUpper + "', '" + DevicePartNumberTextBox.Text.Trim.ToUpper + "', '" + PackageTypeTextBox.Text.Trim.ToUpper + "'"
I've created a SQL stored proc and want to change it to use a local variable to reduce process time..
Major lines of my SP:
[Code]....
I've been trying to use a variable for AVG(AA.Count) so that I don't have to process it three times,
[Code]....
=> this stored proc does not work, and I am not too sure where I should declare my local variable to use it in SELECT statement..
My hosting company provider MS SQL Express as part of my hosting package, they have provided me with both the name and IP address of the server running MS SQL Express.
I have created a database on this server via management studio and when I create a connection string like this (connectionString="Data Source=ServerName/IP;Persist Security Info=True;User ID=xxx;Password=xxx") my application works fine.
But if I create a local database file and try to attach this with a connection string like this (connectionString="Data SourceServerName/IP; AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance = True ; Trusted_Connection=Yes) my application doesn't work.
Therefore my questions are:-
Is there something wrong with my connection string? Can you use a local database file within a production environment?
I am developing a website with ASP.NET pages that uses an SQL Server database with LINQ to SQL. I am using Visual Studio's Web Developer along with SQL Server 2008 (Developer Edition) database tables on my personal PC to develop this software. When ready, I intend to transfer the compiled web pages to a web hosting service with an SQL server database that is identical to the database on my PC.
I now have a version of my website deployed on a web hosting service at: [URL] and all of my database tables duplicated at the remote SQL server. However, this version of my website does not work with the database yet. I realize that I can have the VS Server Explorer connect to both databases, but I do not know if the web pages on my PC can use both databases interactively.
I am asking how I can develop my website to use the local SQL Server database and then have the deployed pages use the remote SQL Server database with LINQ to SQL. Do I need to create one version that works with the local database and another deployable version that works with the remote database? What should I do?
i have a registration from which have a field email-id , which user select paid or free (for 15 days) registration . when user registration is going to expire then they get a automatic mail regarding registration. and i also want to send some particular msg to all user ., i want to take all email from data base . i am using asp.net c#
View 2 RepliesIn 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.
I am developing membership for website. SQL Server 2005 is at backend. I want Column <Package> to "Free" from "Premium" automatically when month ends. The website is membership per month basis. Two type of members "Free" and "Premium".
Is there any way to automatically column update as month ends. Can I do it with triggers? If yes then how?
When a user creates an account for my web application using the create user wizard additional steps have been added to take more details and store them in another table. Now this tables primary key is set to uniqueidentifier, is it possible to have that unique identifier automatically generated when the query is run to insert a new row for a new user?
View 1 RepliesI have a page that has been working for sometime and now getting this error..
String was not recognized as a valid Boolean.
Im was working on a How-To document of the pages for our VP and now i cant get to page 2 to continue the document.
I have recently added 2 new radiobuttonlists(rel and relst) and im sure its one of them thats causing the issue. But sicne i cant debug not sure which one is failing. Here is my insert code and the error is occuring on the Line 376:
cmd.ExecuteNonQuery();
The fields for the radiobuttons are all setup as BIT in SQL. They all have default values of 0. They are all setup NOT TO ALLOW NULLS.
[Code]....
I have been running a VWD 2008 express and sql server 2008 express based system both on local server and website successfully, then started getting this error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Now I cannot run this system on either local server or website.
View 3 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
I need to insert a record in table which is in remote server....I am using two connection strings for local and remote....both the servers are in same workgroup only...so am able to connect the both.The problem is am filling data of local table in on dataset1 and remote server table data in another dataset dataset2..Now whil inserting a record local an error occured like "This row already belongs to another table" after googlingI found like this like "Dataset.importrow()" instead of "dataset.add()" method...then there is no errors but the inserted record is not inserting in remote server database...
View 5 RepliesI want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
I'm sure this has been answered many times already, but I still can't seem to find exactly how to search for this issue, so apologies in advance.
Anyway, I have a VB script for entering a row of data into a table by a web user. When this row of data is entered, I wish to take some of the values from the columns of the "primary" table, and have that data automatically create a new row of data in a "secondary" table. I think I'm part of the way there, here is my script:
[code]...
"ProductsByMfr" is the "primary" table - the table that the user adds data into when the button click event is fired.
"DealerPricing" is a "secondary" table that I wish to have some of the data from the newly-entered row in ProductsByMfr copied into. Am I even close here?