Devart Forums

Alexey

I've tried the following query with MySQLDirect .NET 3.55

select year(hiredate) from emp

and it does work.
Please make sure you are using the latest version of MySQLDirect .NET.

Alexey

How many Oracle homes do you have? Maybe this is the problem...

Alexey

Try to increase mySqlCommand.CommandTimeout as well.

Alexey

Do I just put "B.exe" inside the licenses.config only?

Exactly so!

Alexey

You need a space in every line starting from the second:

Code: Select all

test_db = 
 (DESCRIPTION = 
 (ADDRESS_LIST = 
 (ADDRESS = (PROTOCOL = TCP)(HOST = sal-emp-dsk-06)(PORT = 1521)) 
 ) 
 (CONNECT_DATA = 
 (SID = orcl) 
 ) 
 )

Alexey

Have you created licenses.config file as described in the Licensing topic of our documentation?

Alexey

It seems like PostgreSQL server's problem. If you say that your website is very busy, then this is quite common situation when a server fails to answer.
Yes, connection pooling is set by default. Try to increase max_connections parameter.

Alexey

We will provide this feature in the next version.
Currently it can be done only with DBMS_SESSION.SET_IDENTIFIER('12345');

Alexey

Not at all.
Well done!

Alexey

We will investigate this problem. Look forward to my reply.

Alexey

Are you able to connect to your PostgreSQL server using PostgreSQLDirect .NET at all? Please specify the connection string used.

Alexey

CNPSV wrote:- if I have a field of type "serial" why doesn't the direct connector recognize the field as Serial.

Serial its just an integer type with sequence. That's why we map it to System.Int.

CNPSV wrote:- if I have a dataGridView, how can I autoFill and autoUpdate, from the designer

You need to use "With refresh SQL" option when configuring PgSQlDataTable comtrol.

CNPSV wrote:- if I have in postgreSql a not null field, why can I enter a new field with a null value and no message or exception is shown / thrown.

Please describe the problem in detail. Send me a small test project to reproduce the problem. Include the definition of your own database objects. Use e-mail address provided in the Readme.txt file.
Do not use third party components.

Alexey

You mean the problem is resolved?

Alexey

Unfortunately, I couldn't reproduce the problem with your data.
Try to use emp and dept tables and see whether same problem occurs.

Alexey

How do you preview data?

Devart Forums

Search found 2757 matches

Re: Questions about Fill, Serial, Update, Delete