Devart Forums

I have a .NET application that runs on the Mac using the Mono Project. All the data looks good except for dates. They are coming back as an empty string or 01/01/01.

using 2.20.12
DB engine 8.01

Any thoughts?


(also, works fine as .NET app and using Mono on WinXP)

It is a new issue. I need more information about your environment in order to analyze the problem.
Please answer following questions:
- Do you connect to the same PostgreSQL server in both cases?
- Do you have PostrgeSQL server installed on Windows or Mac platform?
- Which protocol do you use for connection?
- Did you try to access this data using strandard tools like pgAdmin? Did you see your datetime fields?

- Do you connect to the same PostgreSQL server in both cases?
Yes

- Do you have PostrgeSQL server installed on Windows or Mac platform?
Mac

- Which protocol do you use for connection?
TCP/IP (not sure if this is what you are looking for)

- Did you try to access this data using strandard tools like pgAdmin?
Yes, from both the Mac and XP

Did you see your datetime fields?
Yes - the data looks ok. I did notice that the field I am looking at is a TimeStamp, so I added Date field with the same results.

We have investigated this situation. In the last version we have problem converting date datatypes using binary ptotocol on Linux and MAC OS. We are going to fix it in the next build.
Now you can try to use the text protocol in you PostgreSQL connection. You should set ";Protocol=2" option in your connection string;

Still does not work - Protocol=2.

I added a IsDBNull check and it is always returning false.

Is this related to the issue?

Did someone verify that setting the Protocol=2 would work?

What is the ETA of this fix? I now have a "hot" client that keeps calling.

For kicks I tried to use 2.4, but the MonoProject does not have all the .NET 2.0 implmented, so I got an error when loading System.Data.Common.DbConnection.

I also tried your protocol=2 suggestion and that did not work. What am I missing?

I just got another email from my client.

I have to find a soltuon ASAP.

Any thoughts?

Using the text protocol (protocol=2) is the most compatible way of working with Postgre SQL server on different platforms. Our tests of text protocol with mono do not produce any errors. Please try to use this protocol in your application. If you will have any problem please send me error message and simple example that reproduces your problem. (DDL that creates table with necessary datatypes, and code piece that shows what you are trying to do).

There is no error. The date field is always returning IsNULL.

I'll see what I can put together for you.

We are looking forward for your example (small DDL and code).