Trust ID PBCEX logo 300x102

MySQL Unable to convert MySQL date/time value

4 years 9 months ago
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
MySQL Unable to convert MySQL date/time value #6089
Hi Guys,

if we try to connect to our MySQL database we get the following error:

Unable to convert MySQL date/time value


If found out that this is a known error and needs a parameter in the connection string but we are not able to add these parameter in CardExchange. What do you think?
stackoverflow.com/questions/5754822/unab...e-to-system-datetime

Best regards

Ingo

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
4 years 9 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
MySQL Unable to convert MySQL date/time value #6091
Hi Ingo,

To have CardExchange construct the connection string mentioned in your link:
server=localhost;User Id=root;password=mautauaja;Persist Security Info=True;database=test;Convert Zero Datetime=True
you have to set the Server to localhost and the Database to
test;Persist Security Info=True;Convert Zero Datetime=True

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
The following user(s) said Thank You Ingo Sterthaus
4 years 9 months ago
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
MySQL Unable to convert MySQL date/time value #6096
Thanks Rutger, everything works fine now!

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
×

Notice

The forum is in read only mode.