Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Http Connection to Remote SQL Server

Author  Topic 

sarathi125
Starting Member

3 Posts

Posted - 2010-07-20 : 06:08:39
Hi,

Hi All,
I want to connect my C# Windows applicaiton to a remote server using http connection strings,

How can I?

I tried something like this...

private const string ConnectionString = @"Provider=MS Remote;Remote Server=http://192.168.1.61; Remote Provider=SQLOLEDB; Data Source=192.168.1.61; Initial Catalog=MYDATABASE; User ID=sa; Password=password";

and need to configure one Virtual directory in the IIS as shown in the below url

http://support.microsoft.com/kb/321357

But when I'm trying to execute a query it troughing error...


An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more information about server security settings.
   

- Advertisement -