Re: [Firebird-net-provider] Connection problem from Win2003Standard
At 10:13 AM 21/08/2007, Nobuya Higuchi wrote: >Hi, > >Just for the information. I am experiencing a similar problem. My >Firebird2.0 DB resides on a PC server that has two NICs. When I try to >install my application server program onto the same PC server, it seems that >the application server program cannot connect to the DB on the same machine. >I tries "localhost", "127.0.0.1", and "192.168.x.x" in vain. The localhost IP address (127.0.0.1) does not route via any NIC. It is the local loopback server, which is an emulated transport accessible only by a local network client. If you are using the remote client interface as your local network interface (the default for S2003 and Vista) then you won't be able to access the local loopback server. I don't know how your network sees 192.168.x.x but, if it is a machine-local address also not visible to the network, then the remote client interface won't find it either, even if it is running on the same physical machine. Helen - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win2003Standard
Hi, Just for the information. I am experiencing a similar problem. My Firebird2.0 DB resides on a PC server that has two NICs. When I try to install my application server program onto the same PC server, it seems that the application server program cannot connect to the DB on the same machine. I tries "localhost", "127.0.0.1", and "192.168.x.x" in vain. Dean, thank you for your expert comment. Nobuya - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
> I've tested this. I provided IP, that definetelly isn't active in my > netwrok and isn't on my DNS. I got result without problems. I can send > you video. :) Alright. Here is a program that I ran on my computer: public static void Main(string[] args) { string address = args[0]; Console.WriteLine("Testing: {0}", address); IPHostEntry hostent = Dns.GetHostEntry(address); Console.WriteLine("Hostname: {0}", hostent.HostName); foreach(string alias in hostent.Aliases) { Console.WriteLine("Alias: {0}", alias); } foreach(IPAddress addr in hostent.AddressList) { Console.WriteLine("Address: {0}", addr); } } Here is the output for two different addresses: D:\Projects\TestProject\bin\Debug>test 10.0.0.33 Testing: 10.0.0.33 Hostname: xx Address: fe80::69eb:837:6a0:5c66%8 Address: fe80::5efe:10.0.0.33%11 Address: 10.0.0.33 D:\Projects\TestProject\bin\Debug>test 123.123.123.123 Testing: 123.123.123.123 Hostname: 123.123.123.123 Address: 123.123.123.123 The first address is my local IP address. Notice how it returned the IPv6 addresses *before* the IPv4 (this is Windows Vista). The second address is one that does not exist on my network. Not visible here, of course, is the fact that this address took about 6 seconds to "resolve" whereas the first one was practically instant. Your network may be different, but clearly not all networks are the same as yours. Remember, all I'm trying to say here is that you should replace the line: IPAddress addr = Dns.GetHostEntry(hostname).AddressList[0]; With the following: IPAddress addr; if (!IPAddress.Parse(hostname, out addr)) { addr = Dns.GetHostEntry(hostname).AddressList[0]; } It's not a big change and it's only useful in certain circumstances, but it *is* a better solution. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with dataadapter under VS2005 US
Hello: > The strange thing is that this error occures only in the US version of > VS but not in the german one > > Could somebody help please ? Why you don't try with TableAdapters and the DDEX provider ?? The old design time support is deprecated now, and is removed in newer releases. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard (SOLUTION)
First of all, thank you for all your responses. All the different ideas conducted me to the solution. I solved the problem by replacing Dns.GetHostEntry() in GdsConnection.cs, function private IPAddress GetIPAddress(string dataSource, AddressFamily addressFamily) with it's older brother, Dns.GetHostByName(). Although the compiler warns about this function as being obsolete, MSDN also specifies this and recommends using the new GetHostEntry, it looks like it behaves strangely in some situations. So I'll just use this modified source of the Firebird Provider until Microsoft solves this bug (that's what it looks like to me, though strangely enough, this isn't listed in any MS forums or bug lists). Also, maybe Firebird net provider developers should consider using the older function instead, until GetHostEntry is reliable in any environment. I wish you bugless developing ! ""Cosmin Sandu"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hello, I have a connection problem from a Windows 2003 Standard Edition using FibProvider from a C#2005 application to an Interbase Server. The system I use is the following: Application written in C#2005, .Net Framework 2.0, FibProvider 2.0, hosted on a Windows 2003 Standard Edition. The database server is an Interbase 6.0 Open Source hosted on a Linux server. The application cannot connect to the database server from the Windows 2003 server but if i move the application to another station, an XP station, it works perfectly. The error that i receive is something like ... "cannot connect to the remote server. The server actively refuse it". I presume it has something to do with the Windows 2003 settings... If you can help me, i would very much appreciate it... Thank you -- - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
On 8/20/07, Dean Harding <[EMAIL PROTECTED]> wrote: > But that has not been my experience: I have seen it return a *different* IP. > Also, if you do not have reverse DNS set up for that IP, then you won't get > any results at all. For example, here is a MySQL bug related to I've tested this. I provided IP, that definetelly isn't active in my netwrok and isn't on my DNS. I got result without problems. I can send you video. :) > Dns.GetHostEntry: http://bugs.mysql.com/bug.php?id=26593 > > I'm not saying this is the problem in this particular case, but I have run > into trouble just using Dns.GetHostEntry on an IP address... :-) > > Dean. > > > > - > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with dataadapter under VS2005 US version - need HELP
Hello. When I create a dataadapter by assistent with insert, delete and update query e.g. The code for insert, update & delete funtionality is generated automatically. Now when i reopen the winfform crashes (everytime i try to open the form). The strange thing is that this error occures only in the US version of VS but not in the german one Could somebody help please ? Michal - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
> Yep, but internally. Then you get back your IP (the IP you provided) > and maybe some others. But this isn't the problem. He has 2 NICs on > "client" not on server (if I understand). But that has not been my experience: I have seen it return a *different* IP. Also, if you do not have reverse DNS set up for that IP, then you won't get any results at all. For example, here is a MySQL bug related to Dns.GetHostEntry: http://bugs.mysql.com/bug.php?id=26593 I'm not saying this is the problem in this particular case, but I have run into trouble just using Dns.GetHostEntry on an IP address... :-) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
On 8/20/07, Dean Harding <[EMAIL PROTECTED]> wrote: > > If you provide IP, there's no hostname. > > Yes, but Dns.GetHostEntry does a reverse lookup on your IP to *get* the > hostname. Have a look in Reflector -- it ends up calling gethostbyaddr on > your address. Yep, but internally. Then you get back your IP (the IP you provided) and maybe some others. But this isn't the problem. He has 2 NICs on "client" not on server (if I understand). -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
> If you provide IP, there's no hostname. Yes, but Dns.GetHostEntry does a reverse lookup on your IP to *get* the hostname. Have a look in Reflector -- it ends up calling gethostbyaddr on your address. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
On 8/20/07, Dean Harding <[EMAIL PROTECTED]> wrote: > > I have 2 NICs in my notebook too. I don't have this problem. And the > > Dns.GetHostEntry() returns (should) for IP the same IP, that's all. > > Actually, that's not true. Dns.GetHostEntry() actually queries the DNS > server to get the name corresponding to that IP, and then returns all the IP > addresses associated with that name. It is quite possible that it can return > addresses in a different or unexpected order. If you provide IP, there's no hostname. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider