Devart Forums

The site license means that all developers of a single company can use our provider for development. Since you are only one developer you do not need a site license. All applications that are developed under single license driver with licensing component support (see "Licensing" topic in the documentation) should work without any problem.
If you are interesting in purchasing site license please contact sales department.

Our licensing scheme do not work in such environment as now. We are planning to add such feature in near future.

You can generate all certificates yourself using OpenSSL tools and step by step description from "Using Secure Connections" topic. If you have a CA provider you can request certificates.
If you are trying to connect to MySQL server that you do not administer you should know the following information:
- Does this server supports SSL connections?
- If client and/or server requires verification you need client key pairs;

Dear users,

New build of PostgreSQLDirect .NET version 2.40.14 is available for download now.
This version includes:

• Bug with licensing fixed
• Bug with PgSqlCommand.FetchSize property fixed
• Fixed broken links to documentation
• Incompatibility issues with .NET Framework and Mono fixed

Core Lab development team
http://www.crlab.com/pgsqlnet

The problem is that connection string does not contain necessary SSH options. It is because of problem in MySQLDirect .NET Data Provider. We have fixed this issue. Fix will be available in the next build.
Meanwhile you can use the following code as a workaround:

mySqlConnection.UserId = "dbusername";
mySqlConnection.Password = "dbpassword";
mySqlConnection.Database = "dbname";
mySqlConnection.Port = 3306;
mySqlConnection.Host = "hostname.com";
mySqlConnection.Protocol = MySqlProtocol.Ssh;
mySqlConnection.SshOptions.Host = "hostname.com";
mySqlConnection.SshOptions.Port = 22;
mySqlConnection.SshOptions.User = "sshusername";
mySqlConnection.SshOptions.Password = "sshpassword";

......

We do not support parameters of array types directly. You should create parameter of VarChar type in PgSqlCommand for every array parameter in stored procedure. During execute you should pass value that corresponds to Postgre SQL server "Array Value Input" format (you can find it in Postgre SQL server documentation).
For your example it could be:
param1 - '{1, 2, 3}'
param2 - '{"string1", "string2", "string3"}'

We updated the documentation about licensing. It will be available in the next build. You can download the updated version in the CHM format now using the following link:
http://www.crlab.com/pgsqlnet/pgsqlnet.chm

Please try to follow according to instructions. Let us know if you will have any problem with it.
Also please let us know which type of application do you use Winforms using IDE, class library, console, ASP .NET

We have fixed this problem for the PostgreSQLDirect .NET.
Look forward for the next build.

We have fixed this problem for the PostgreSQLDirect .NET.
Look forward for the next build.

We have not tested DBMonitor on Win2003 OS. We plan this test.
You can also trace executed commands and parameters using TraceEvent of PgSqlMonitor component. You should define a handler for this event and output all parameters into console or component on the form.
private void pgSqlMonitor1_TraceEvent(object sender, CoreLab.Common.MonitorEventArgs e) {

PgSqlCommand cmd = sender as PgSqlCommand;
if (cmd != null) {
Console.WriteLine(string.Format("Command : {0}", e.Description));
Console.WriteLine("Parameters:");
foreach (PgSqlParameter param in cmd.Parameters) {
Console.WriteLine(string.Format("param name: {0} value: {1}", param.ParameterName, param.Value));
}
}
}

Since it works without problem on XP platform, then maybe on Server2003 platform you have problem with conversion to unicode somewhere before PostgreSQLDirect .NET Data Provider.

Please also clarify, which platform do you use, 32 or 64 bit?

You can deploy your applications that are created using PostgreSQLDirect .NET Data Provider for any number of clients.
The single developer license means that only you can use our provider for development. The site license means that all developers of a single company can use our provider for development.

This error message is returned by Postgre SQL server when you try to insert such values.
Can you insert/select these characters in PgAdmin?

Please try to use DBMonitor tool for monitoring all statements between client and server. Try to insert data that contains such symbols and check SQL statement and actual parameter values in DbMonitor.

Did you see any exceptions? What is the value for Label1.Text ?
Try to use: DataGrid1.DataSource = ds;

The error message tells that procedure can not be found. You need to check the following issues:
- Did you create the procedure in the default scheme(public)?
If no then you should use the procedure name like "SchemaName.ProcedureName" in PgSqlCommand.CommandText, or set the Initial Schema parameter in the connection string.

The functionality of SSH options implements port forwarding/tunnelling. You are trying to use it in appropriate way. You do not need additional settings to the DB server since the traffic between DB server SSH server is not secure. Only SSH server MySql client traffic is encrypted.

Please let me know values of the following variables when you break in the catch block: MySqlConnection.ConnectionString, ex.Message, ex.StackTrace. It will help me to reproduce your situation.

When you try to connect using Putty do you also use UserName+Password authentication method?
Since you have SSH server and DB server on the same computer you can try to use mySqlConnection.Host = "localhost";