.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Fetch Data from sql server having different physical address or ip address

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

Hi

I have this sql server xxx.xx.40.221 where i am writing cursor.

I want to fetch data from xxx.xx.1.153 sql server.

But as you can see these two databases are on different physical locations, how m i suppose to do.

I m counting on u guys. Please help me!!


Prajpk


View Complete Post


More Related Resource Links

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Error Firefox has detected that the server is redirecting the request for this address in a way tha

  
The page isn't redirecting properly                                                        Firefox has detected that the server is redirecting the request for this address in a way that will never complete.                            *   This problem can sometimes be caused by disabling or refusing to accept          cookies.

Get Development Server to bind to a different address

  

does anybody know how to tell Development Server to bind to a different address?

By default, it binds to "127.0.0.1" and this doesn't let other computers on the same network access the web application.

I guess there should be a web.config section but I can't sort it out

 

Thank you!



Windows 7 socket bind behavior difference from XP/Server 2003, with reuse address socket option (WSA

  

I have two processes that are both listening to UDP packets and can run on the same PC.  One process binds a socket to one NIC address with port 18246.  The other process has two Socket objects, one for sending on port 18246 and one for listening on port 18246.  Both of these sockets are created, have the SO_REUSEADDR socket option set.  Bind is called for a single IP Endpoint for a common local NIC address, but a different one than used by the above app.

Under Windows XP and server 2003, both processes can bind regardless of order of startup.

Under Windows 7, if the process with only one socket starts first, the second process fails with WSAEACCES 10013 error with the second socket bind.

I wrote a sample C# app with the following method that fails when running under Windows 7 x86 and x64.  The above failure occurs when the sockets are in separate processes, but a single process using the same socket interaction also fails.  The below method is called with two IPV4 addresses that are assigned to local Network adapters on the PC.

Retrieving Global Address List from Exchange Server

  

Hi everyone,

This is my 3rd post, always getting great help from here.

My last two questions were about sending email through ASP.NET, and adding web form to that email body, which is working :)

This time my boss wants me to send email addresses from our exchange server global address list. :(

For example,

Dropdownlist for send from who,  Dropdownlist for recieving person...The behind values should be email addresses.

And this information should come from global address list on our exchange server.

 

I am very newbie to ASP.NET so please instruct me step by step, what is the steps I need to do, very specifically please.

Thank you advance!!!

 

 


WCF Service to be hosted on the server with multiple IP Address

  

Hello all,

I am new to WCF Service. Following is my scenario

I have got a Windows Server 2008 with two NIC ie. two IP Addresses

xxx.xxx.xxx.1

xxx.xxx.xxx.2

I have got Apache server running on 1 and IIS on 2.

Now when I publish the WCF service on my service and have explicitly set the iplisten for IIS to 2. Still I am not able to access the service.

One more observation the link which I get after publishing is "svcutil.exe http://servername/Webservice/Service.svc?wsdl "

I need to have IP Address instead of servername in above URL.

Because I think the servername is causing the confusion as both IP Address 1 and 2 point to it.

Please suggest what needs to be done

Thanks in Advance.


How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.

  

how to write SMO's conn.ConnectionString with IP address and port?


SQL Server Remote Access not work with Live IP Address

  

I have one server which has OS Windows 2003 Server I have installed SQL Server 2005 Express Edition in that I have connect my Internet with this pc directly with Live ID.

 

But when i try to connect SQL server from internet it give me bellow mention error.

 

TITLE: Connect to Server
------------------------------

Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

my ip address

  
IP Tejji answers question like what is my ip address? find my ip addresss? detect my ip address? Best part is it also determines your local ip address as well as mac address. Further if you keen on browser specification and details regarding browser capabilities can also be found. It also help you see your geographic location. Other details that are available are Latitude, Longitude, timezone, country, region & city. In short it is one-stop-shop for very rich details about your IP and related information.

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Sorting Data in a GridView Web Server Control

  
The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events

Frequently Asked Questions - SQL Server Data Types

  
This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

server side does not save data when using POST data to another URL using WebRequest

  

Hi,
 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
 
 
2. How can I debug the server code side where to receive the request from client side who posts the data ?
 


The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.


Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)

        {

           

    &nbs

OData and AtomPub: Building an AtomPub Server Using WCF Data Services

  

Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010


SOA Tips: Address Scalability Bottlenecks with Distributed Caching

  

SOA makes application scalability easier, but getting the best performance out of your SOA means paying close attention to the details. We'll give you some tips for coding your app more effectively and using distributed caching to remove data access bottlenecks.

Iqbal Khan

MSDN Magazine June 2010


Under The Table: Spatial Data Support In SQL Server 2008

  

New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend