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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Connecting thru IP Address

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Dear Anybody

Is the connection string below is correct to connect through IP in SQL Server 2005 Express


Data Source=,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Is the Library name OK.

I have checked up all like TCPIP port enabled, in IPall port number has been defined as 1433 (default) but it does not work.

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.

.RRAS IP Filter

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.

Connecting to MS SQL Server database using webmatrix.



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"?>


        <compilation debug="false" targetFramework="4.0" />
    <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />


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

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

Advanced Basics: What's My IP Address?


If you're like me, you regularly do tech-support for family, friends, and neighbors. You can't go to a party without hearing the familiar refrain: "I've just got a quick question. " It's always something-their Internet connections get dropped, they've got a virus, they can't install some piece of hardware, or some file has gone missing.

Ken Getz

MSDN Magazine December 2005

Help with connecting to SqlExpress 2005 remotely


So I've intalled SQL 2005 Express and Sql Server Management Studio Express (SSMSE). I don't have any problems connecting to it using Windows authentication. But I would like to set it up so that I can log in using Sql Server Authentication with a username and password.

My Problem

But I'm getting an error message of "A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0- No process is on the other end of the pipe) (Microsoft SQL Server, Error: 233).

What I've done

I've created a new "Login" in the Security node. Provided all necessary role access level. Granted permission to connect to database and enabled login.

I've used the Sql Server Surface Area Configuration to set the Remote Connection type to "Using TCP/IP only" or "Using Both TCP/IP and named pipes" (tried both, but in either situation I get the same error message when attempting to login to SSMSE with the user name and password). I also made sure to restart the service.

What do I need to do to fix this problem? 

Problems connecting stored procedure to Crystal Reports


I am working on updating a reporting system that uses Crystal Reports.  All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location.  All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location.  The reason I need to update the location is so that the .NET application will use the correct driver.  Everything has worked fine up until I got to one stored procedure.  The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.

First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report.  It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure.  Then I get the following error:

Query Engine Error: 'ADO Error Code: 0x
Source: OraOLEDB
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'

The proce

Checkout/Chevk in issue in MOSS 2007 while connecting through VPN(virtual private network)


HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying

"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".

Please do the needful....



Having Trouble Connecting to BDC


Hello Share Point experts,

For the first time I'm trying to connect to BDC in SharePoint. I created the Application Definition File and successfully uploaded it to the page. Here is the Authentication part of my ADF:

    <AccessControlEntry Principal="domain\admin">
      <Right BdcRight="Execute"/>
      <Right BdcRight="Edit"/>
      <Right BdcRight="SetPermissions"/>
      <Right BdcRight="SelectableInClients"/>
    <AccessControlEntry Principal="domain\admin">
      <Right BdcRight="Execute"/>
      <Right BdcRight="SelectableInClients"/>
  <LobSystemInstance Name="CRMDB">
<Property Name="AuthenticationMode"

Connecting to Oracle on 64bit OS

We have a 64-bit implementation of MOSS 2007. I recently installed the SharePoint SDK to use the Application Definition Designer to connect to Oracle. I enter the connection string and then I get this:

Attempt to load Oracle client libraries threw BadImageFormatException. The problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

I have verified that the server contains the 64 bit version of the Oracle client installed both with the instantclient and with system.data.oracleclient.dll. The only thing I can think of is that the tool was compiled as a 32bit application.  Is there a 64bit version available? Is there something else that I'm missing?

Connecting to Sharepoint Using Windows XP Home




I'm new in using sharepoint and tried to use my windows xp home computer to connect on the company's network. However, when I am trying to join sharepoint as a client computer, I come up with the following message:

Run the wizard to complete networking setup

Problem however, is that the wizard doesn't run.

While I found info describing this issue for win 7 and vista, http://support.microsoft.com/kb/926505, I can't find any regarding XP home.

Can someone kindly assist?

Error connecting using SPSite

Has anyone seen this error message?

The Web application at http://ecnet/Pages/Default.aspx could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

Errors on the line.

SPSite site = new SPSite("http://ecnet/Pages/Default.aspx");

It's a clean console application running on the SharePoint 2007 web server.

Any thoughts? I can't seem to connect to the Server like I used to in SharePoint 2003.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Sample: Connecting to a .NET Framework Source Using Business Connectivity Services in Office 2010

Explore the code in this visual how-to article as you learn to learn how to use Visual Studio 2010 to create a BCS external content type.

Connecting to a .NET Framework Source Using Business Connectivity Services in Office 2010 (Visual Ho

Watch the video and explore code as you learn how to use Visual Studio 2010 to create a BCS external content type. The external content type then connects to a .NET Framework assembly that uses XLINQ to provide read-write access to data that is stored in a simple XML data file.

Video: Connecting to a .NET Framework Source Using Business Connectivity Services in Office 2010

Watch this visual how-to video as you learn to create an Office 2010 Business Connectivity Services External Content Type based on a .NET Framework source.
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