C#  CONNECTION TO A REMOTE DATABASE

navidj
navidj used Ask the Experts™
on
Hi Guys,

I have a Firebird database on our Amazon windows server 2008.

I need to developing a C# client application which needs to communicate with the Firebird database on cloud.

A couple of questions:(This is my first project with C# working with a database)

1.      What are the methods which I can create a connection between the application and the remote database.  (TCP)

2.      How secure are these connection.

Many thanks
Navid
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Nick UpsonPrincipal Operations Engineer

Commented:
The recommended way to connect to a firebird database over the internet is to establish a VPN tunnel and then communicate through that.
IT Analyst
Top Expert 2012
Commented:
Hi,

Check this link - http://www.connectionstrings.com/firebird

Regarding security, it depends on the channel you are using! If you are using https, it will be more secure!

Hope it helps u...
Manoj PatilSr. Software Engineer
Commented:
Your connection string should be like this

connection.ConnectionString = "User ID=sysdba;Password=masterkey;" +
"Database=\\server\share\database.fdb;DataSource=10.48.14.51;Charset=NONE;";

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial