16,004,529 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Haifovchanin (Top 11 by date)
Haifovchanin
10-Apr-23 2:29am
View
Thanks for an answer!
The code works correctly on real SQL DB.
Your answer is the best. :)
Haifovchanin
27-Mar-23 7:56am
View
This is the query in Proj1, that creates the function.
TypeId (integer) and Timestamp (timestamp) columns are defined in the Log table in Proj1Log project.
CREATE FUNCTION [dbo].[ViewErrorLog]
(
@logType int
)
RETURNS TABLE
AS
RETURN
(
select top(300)
[Id] as 'Id'
,[Time] as 'Time'
,[Application] as 'Application'
,[Text] as 'Error'
from [$(Proj1Log)].[dbo].[Log] with (nolock)
where [TypeId] <= @logType
order by [Timestamp] desc
)
Haifovchanin
29-May-22 7:40am
View
I'm the person who will administer the server.
Now the state is the following:
On the server side, which is the Virtual machine on Azure:
- Firewall has the following open ports for Inbound connections: 21, 990 and 1024-65535 for TCP for both Private and Public networks.
- Firewall has the following open ports for Outbound connections: 20, 989 for TCP for both Private and Public networks.
- FTP Firewall Support is configured with the external IP address.
- FTP Site is set to use self-signed SSL Certificate and SSL Policy is set to "Allow SSL Connections.
- The SLL Certificate was exported without Private Key in Base-64 format and copied to the client's computer.
Azure Network Interface for the VM has corresponding rules for ports 21, 990, 20 and 989 (Allowed TCP connection from/to and IP).
On the client side, which is regular desktop PC:
- Firewall has the following open ports for Inbound connections: 21, 990 and 1024-65535 for TCP for both Private and Public networks.
- Firewall has the following open ports for Outbound connections: 20, 989 for TCP for both Private and Public networks.
In the C# code I still use the
UsePassive = false
line. So, As I understand, the connection type is Active, so all the traffic is via ports 21 and 20 and, for SSL case, via 989 and 990.
Still the SSL connection does not work, but the regular connection - without SSL - works fine.
What I have to do to make the SSL FTP connection work?
Thank you.
Haifovchanin
26-May-22 10:29am
View
You are right. I'm sorry for not including this information.
Thank you for the proposed solution. I'll check it with server administrator.
Haifovchanin
26-May-22 9:53am
View
Yes, I read it once, but with UsePassive set to True this does not work at all. It gives me the exception "The remote server returned an error: 227 Entering Passive Mode" with inner "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 ..."
Haifovchanin
12-May-22 2:39am
View
You are right, it is a client pull system.
Thank you, Gerry. I'll think how to implement the proposed synchronization with all our current restrictions.
Haifovchanin
12-May-22 2:01am
View
Understood.
Thank you, Dave.
Haifovchanin
11-May-22 9:21am
View
Thank you, Dave.
The problem is that the stations are independent and have no connection to each other. Another fact, that may make things easier: the unread emails are downloaded one by one on user's click and the time between clicks is measured in minutes.
Is there is a way to synchronize the access to unread emails to avoid simultaneous downloading if the same email?
Haifovchanin
7-Jun-20 7:50am
View
Thank you, Richard. The issue is solved.
Haifovchanin
3-Jun-20 7:51am
View
Understand. I'll try to reconnect after each request.
Thank you.
Haifovchanin
3-Jun-20 7:47am
View
As I saw in log-file, the connection was broken, then my application automatically reconnected to Gmail. Approximately 10 minutes after SelectMailbox function hung.
When reconnecting, I create a new instance of Imap4Client.
By the way, time between re-connection and function hanging differs from run to run.
Show More