Configuration :: Connecting To Whois Server
Apr 28, 2010
I have written a method for getting information about the ip-addresses of visitors to my web site. The method is called from Page_Load. It connects to the Ripe whois database and gets information about the ip sent. Everything works perfectly when I try it locally using localhost, but as soon as I upload the code to my web host it stops working, and I get the following error message saying that it can't connect to Ripe. The code is exacly the same as I use locally. (The relevant code is included in the error message below). I tried to contact my web host to ask them, but they said it was beyond their expertise...
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 193.0.6.135:43
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 193.0.6.135:43
Source Error: [Code]....
Line 38: {Line 39: TcpClient objTCPC = new TcpClient();Line 40: objTCPC.Connect("whois.ripe.net", 43);Line 41: Line 42: string strDomain = ip + "
View 3 Replies
Similar Messages:
Mar 27, 2010
I am having 5 systems connected through LAN.Now I am creating a web application in server and want to retrive that web application through all the systems so that other people can able to access it andwork with different pages in the application.Is this possible?If yes pls send me the steps how to do that?Same with database also.Pls respond me ASAP.
View 3 Replies
Jun 7, 2010
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
View 8 Replies
Feb 23, 2010
A customer has asked that we do a dynamic whois lookup on the homepage of their ASP.NET site, based on the IP of the user accessing the site.The implementation would be something like what's described here:
http://www.aspheute.com/english/20000825.asp
However, I noticed that this code connects to whois.networksolutions.com. I am thinking that this may not scale very well if we are initiating a connection to this remote server on every page load.For example, say 1000 different users hit the home page - this would cause a lot of connections to be initiated.
View 3 Replies
Mar 27, 2010
My Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
View 3 Replies
Oct 1, 2010
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
View 5 Replies
Aug 22, 2010
I upgraded a Website to use ASP.NET 4.0, from 3.5. This involved setting it up on a different server, with the same hosting company. I'm using a shared hosting plan on Windows Server 2008.
Since migrating, it gives an error message when I try to login to the site:
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)
I'm using the same connection string as I did in the old version, which always worked. I also changed the permissions for the database to allow connections from the redeployed Website, via the host's control panel.
I have searched the web.config, and the source for the site, and I haven't been able to find a connection string that looks incorrect.
I've contacted the host about it, in case it is a configuration issue on their side.
View 2 Replies
Aug 26, 2010
I am facing some problem while uploading excel sheet upload and connecting it to dataset. The Code works fine in local machine but on website its showing following error.
System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal
Below is my code:
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
switch (Extension)
{
case ".xls": //Excel 97-03
s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
case ".xlsx": //Excel 07
s = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
}
EDT = new DataTable();
EDT.Columns.Add("MobileNo", typeof(string));
con = new OleDbConnection(s);
con.Open(); // I am getting the error at this point
da = new OleDbDataAdapter("select * from [Sheet1$]", con);
ds = new DataSet();
da.Fill(ds);
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
View 2 Replies
Jun 3, 2010
1. What is the best site to host an ASP.NET Web Application which contains a login page, members area, and specified user accounts?
2. How do I connect my created web site to a hosting site such as GoDaddy.com or other?
View 4 Replies
May 20, 2010
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
View 2 Replies
Aug 19, 2010
Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver?
View 2 Replies
Feb 4, 2011
We have a MOSS 2007 custom web part based on a user control that queries a database cluster. When the connection to the database is made, we regularly experience the error below and have had to create a work-around in the code to retry the connection. We have 3 environments - development, staging and production; the error only occurs in production. The difference in the production environment is it is a farm with 3 WFEs and a SQL cluster, where development and staging are single machine instances. All are MOSS 2007 & SQL Server 2008. We cannot find what is causing this issue and I'm hoping someone else has experienced a similar problem and knows the cause.
This is the error that occurs frequently when the query is executed:
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at [Our Namespace.OurMethod](String someParam)
More than one method will generate this, but this is typical code, note the retry work-around:
public static DataTable OurMethod(string someParam) {
const string query = "sp_OurStoredProcedure";
var resultsTable = new DataTable();
var connection = new SqlConnection { ConnectionString = OurDatabaseConnection };
var command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure };
var dataAdapter = new SqlDataAdapter(command);
var retry = 5; SqlConnection.ClearPool(connection);
while (retry > 0) { try { command.Parameters.Clear();
command.Parameters.AddWithValue("@someParam", someParam);
connection.Open(); dataAdapter.Fill(resultsTable); retry = -1;
} catch (Exception ex) { retry--; if (retry <= 0) {
LogError("Exception: DataAccess:OurMethod: *RETRIES EXCEEDED* " + ex, "error");
} else { SqlConnection.ClearPool(connection);
LogError("Exception: DataAccess:OurMethod: ATTEMPTS REMAINING " + retry + ". " + ex, "warning");
} } finally { dataAdapter.Dispose(); command.Dispose(); connection.Dispose();
} } return resultsTable; }
View 5 Replies
Mar 6, 2010
I have developed a web application in asp.net with C# in visual Studio 2005. And i used sql server 2008 as back end. When i run the program, it shows the following error..An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 2 Replies
Feb 20, 2011
or one of my project, I use Access 2007.I have application written by Access, that use database : Sql-Server 2007.I am using XP for the any company computer.The dsn file is on network, and include connectionString with username + password,ut I want to access the database from any user with automatic authentication (no need for user and password).
View 3 Replies
Jul 25, 2010
how do i connect visual web developer to sql server express 2008? in the Database Explorer, i right click on Data Connections, click Add Connection..., and in the Data source box i choose Microsoft SQL Server (sqlClient), which i'm guessing doesn't connect me to a database file, but to sql server express itself(?). in the server name box when i click the drop down box, there's nothing there and that's where i get stuck.
View 3 Replies
Jan 14, 2011
I am using this code to connect to my exchange server using POP3.I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email. modify my code to just read the most recent messages.
Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()[code]...
when i use top instead of retr i get this
+OK X-MimeOLE: Produced By Microsoft Exchange V6.5 Received: by xch0p.com id <01CB58CE.A6A4EA@p.com>; Mon, 20 Sep 2010 09:17:07 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB58CE.81A6A4EA" Content-class: urn:content-classes:message Subject: What we need to do?? Date: Mon, 20 Sep 2010 09:17:07 -0500 Message-ID:
View 3 Replies
Aug 5, 2011
Can you connect to a SQL Server in ASP.NET? If so how?
View 2 Replies
Apr 8, 2010
i have a project running good (database and application both are in same server). some days before we've decided to place databse (sql server 2000) in different server.we created new server with windows server 2003 and Sql server 2000; nothing else is installed in it.And then i register new server's sql in old server's sql server. it connected successfully. even i can fire a query to new server from old server.
Both new and old server having windows server 2003 and Sql server 2000.
Now the problem :I CAN NOT ACCESS NEW SERVER'S DATABASE FROM MY APPLICATION.
I have changed my web.config as under :
OLD :<connectionStrings>
<add name="ConnectStr" connectionString="Data Source=OLDSERVER;Initial Catalog=DataExtractor;Persist Security Info=True;User ID=123;Password=123;pooling=true;Max Pool Size=50" providerName="System.Data.SqlClient"/> [code]....
View 3 Replies
Mar 25, 2011
I have created an SSIS package to fetch the details from an Oracle database and import the details in to SQL servers table. In development region the client provided the connection description for oracle server as shown below: Using the above string
I have selected Microsoft OLE DB provider for Oracle and gave xxxxx:1543/AU1D as server name and provided the username and password. It got connected successfully. (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.abc.XYZ.com)(PORT = 1543))
)(CONNECT_DATA = (SERVER=dedicated) (SID=AU1D) )) For Prod environment the Oracle servers connection description is: C10P =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyyyy.abc.XYZ.com)(PORT = 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = zzzzz.abc.XYZ.com)(PORT
= 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = vvvvv.abc.XYZ.com)(PORT = 1524)) (LOAD_BALANCE = yes)(CONNECT_DATA =(SERVICE_NAME = C10P. abc. XYZ.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)))) Now I don't have the SID to use in the connection.
View 1 Replies
Mar 9, 2010
I need the syntax for a connection string in web.cong to connect to a SQL Server 2005 database that is on a VPN. I have an account on the DB that I can use....just don't know how to construct the connection string properly.
View 4 Replies
Dec 1, 2010
I am trying to retrieve some values from a Database built in SQL Server Express 2008 using .net Web Service.
[Code]...
Whenever i click run in Visual Studio 2008, it shows the startup page in IE that has two Methods (HelloWorld and authorizePassenger). When i click my method authorizePassenger it gets invoked and it asks me for input but when i input and click invoke IE shows HTTP500 error. The code above working fine in Standalone VB.net Application, so i guess i m doing the coding of Database correctly.
View 6 Replies
Sep 3, 2010
I have one web application which is configured to be use froms authentication.
But, I don't want to use SQL Authentication to connect to SQL server, I want to use windows authentication.
View 5 Replies
Jun 18, 2010
how would i go about measuring the number of users connecting a server...
i need to make a code for it..
View 8 Replies
Aug 22, 2010
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.
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.
View 1 Replies
Aug 27, 2010
I have recently combined my aspnet membership database and main website database into one database file, I'm happy with the schemas, stored procedures etc. (This is a development project not yet a production project.)
My problem is that I can no longer simultaneously connect to the database from Visual Studio if a user is logged in to the website.
EG:
Scenario 1: No user is logged in to the website. I can go to the Data Connection window in VS, choose "Add Connection" and then inspect the contents and schemas of the database. This is fine.
Scenario 2: A user is logged in on the website. I try to connect to the website in VS and get the error:
"Cannot open user default database. Login failed. "
Scenario 3: I am connected to the database in VS and nobody is logged into the website. If someone tries to log into the website they get the following error:
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
So it seems from the above that there can be only one connection to the database at a time? However this was not the case before I combined the membership database with the main website database. I could always make changes as a user logged into the website and at the same time see those changes through the connection in Visual Studio.
View 6 Replies
