how to connect an asp.net applicaton running in local IIS to a database residing in a remote web server ?
Pls help me...its an urgent requirement..Thanks in advance
View Complete Post
I can't get Reporting Services to work with Sharepoint.
I've followed the instructions for installation of Reporting Service in SharePoint Integrated Mode, and completed the indicated steps on the SharePoint Central Administration Site successfully. When I try to create a page with a Reporting Services
Webpart, I get the following error:
Invalid object name 'History'.
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
I have SQL 2008 R2, SharePoint Enterprise 2010, and Report Builder 3.0. SQL and Sharepoint are installed on the same server.
I'm certain that there isn't a disk or timeout problem, so I'm assuming that it's a connection failure, but don't know what steps to take to troubleshoot and correct this.
I have a rather simple SSIS package that exports data through an ODBC connection from an IBM iSeries database and copies that data to a SQL Server 2005 database. When I was designing the application, I was able to connect to the iSeries database and
store the user ID and password with my BIDS project and copy the data with out any problems. Great!
When I finished designing and testing the project, I loaded it to the production server. The final test was to schedule the process so that it would run each night. I didn't realize it at the time but the password that I had stored with the project
in BIDS was removed from the package and various MS documentation stated that I should create a configuration file and load the password from there. So, I made the necessary changes to the project, adding a configuration file. The config file is
in the Miscellaneous folder within the BIDS project, however, it isn't automatically copied to the bin directory when I build the project. I have to manually save it to the server, and then after importing the project I have to manually link to the necessary
This fixed the problem with the server, however, now I can not get BIDS to save my password with the connection string from within the designer. This is a huge problem. I am exporting from 21 different da
Is there any way from my custom security extension that I can get to and unencrypt the database connection information held within the RSReportServer.config file?
I am using Linq
Before i start executing my query, want to check if the database connection is being established, i.e if the database server is up and running.
Incase database is down, display appropriate error message?
How can i do that?
I have created an application (vb.net , ado.net), in that i have written some methods that communicates with database server.(ie.to select,insert records etc.).
Now I want to handle the situation,If the process is going on and in between the connection with database server is lost, then after getting the connection again i want to resume the process from the point it is stopped.
How to do it with vb.net.
I am novice user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.
The connection string that i setup as follows.
<?xml version="1.0"?><configuration> <system.web> <compilation debug="false" targetFramework="4.0" /> </system.web> <connectionStrings> <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings></configuration>
And i am using websecurity helper as well and the setup is as follows.
WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);
When i am trying to insert the user details into database i am getting the below error.
Format of t
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008.
And the query is
-- MERGE Statement
MERGE INTO Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;
Please help me to overcome this issue and let me know where can I download that database too.
Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
I need to extract or get the schema from tables in my databse and what is the best way to do it. Is there any third party tool to do it??
Any idea will be appreciated..