[patch_done] PostgreSQL64 + Lazarus 09.30.2+ windows 64 bit
Moderators: gto, EgonHugeist, olehs
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
elidorio2,
this is strange. I must admit i can't help you any more.
I changed your thread toppic to clearify the problem more logical.
Let's wait for other Lazarus+PostgreSQL-users who can help and guid you better than me. Contact ism if you doubt. He has mor fpc expierences... Maybe you can help us with futher expiriences.
So we've found and solved a bug with the MSecsToTimeStamp. I small success for Zeos7.
Let's wait for a LCL+PosgreSQL guru. Be patient somtimes it could take some time...
best regards,
EgonHugeist
this is strange. I must admit i can't help you any more.
I changed your thread toppic to clearify the problem more logical.
Let's wait for other Lazarus+PostgreSQL-users who can help and guid you better than me. Contact ism if you doubt. He has mor fpc expierences... Maybe you can help us with futher expiriences.
So we've found and solved a bug with the MSecsToTimeStamp. I small success for Zeos7.
Let's wait for a LCL+PosgreSQL guru. Be patient somtimes it could take some time...
best regards,
EgonHugeist
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
Hello EgonHugeist,
Please do not leave me, we're getting wool.
Let's try a little more, must be something simple, with postgresql dll.
I know you can, the hardest part you've got.
If we can not resolve this problem, I'll have my Zeos goods leave the project because it must run in win 7 64.
I await your return,
hugs,
Edson
Please do not leave me, we're getting wool.
Let's try a little more, must be something simple, with postgresql dll.
I know you can, the hardest part you've got.
If we can not resolve this problem, I'll have my Zeos goods leave the project because it must run in win 7 64.
I await your return,
hugs,
Edson
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
elidorio2,
it wasn't my intention to say we leave you. But we've all our day to day jobs. Actually im bussy with my private work.
possible issues we've to think about concerning this PG exception:
Things which where helpful to know (Please answer):
Result of: SizeOf(Integer); -> 4 or 8 byte (like in XE2 64Bit here we've to use the NativeInt for 32Bit integer)
Can you access PG in Win32 with the updated sources?
ism,
a hint or more a feeling (blindy typing now) concerning MySQL64: open MySQLResultSet.pas. Look for a function InternalGetString(ColumIndex: Integer): String;
Set a breakpoint there. Is it possible that the PULong incrementing is correct but the PULong size has changed and we point to the midle of nowhere?
elidorio2, On this post you can see how complex your problem is, Edson and w'll need some time and other users to find out what's going wrong. I wish i could consider you i can do it in a half hour but again i can't test it by my selves.
So be patient, don't overhurry and try to help us to help you.
Best regards,
Michael
it wasn't my intention to say we leave you. But we've all our day to day jobs. Actually im bussy with my private work.
possible issues we've to think about concerning this PG exception:
- 1. Is it possible that the pglib.dll 64Bit header has changes and we don't know it?
2. Do we use old integers instead of pointers in our code? Here i've took a look. First impression: No. But still possible.
3. A code snipped from PG9 64 pgtypes_interval.h:Which means ism is eventually right.Code: Select all
typedef struct %u7b #ifdef HAVE_INT64_TIMESTAMP int64 time; /* all time units other than months and years */ #else double time; /* all time units other than months and years */ #endif long month; /* months and years, after time for alignment */ %u7d interval;
4. Where, when, why happens this access violocation?
5. If the integers are right in the plaindriver definitions than which one (2byte smallint/4byte Integer/ 8byte Int64) is in use for which function? As far as i can see (quick look) uses PostgreSQL only 2 and 4 byte integers. But this could be changed too since 64Bit.
6. Can we keep the olp PG plaindrivers or do we need a new 64Bit one as new protocol.
OR is it a setting problem on your computer.
Things which where helpful to know (Please answer):
Result of: SizeOf(Integer); -> 4 or 8 byte (like in XE2 64Bit here we've to use the NativeInt for 32Bit integer)
Can you access PG in Win32 with the updated sources?
ism,
a hint or more a feeling (blindy typing now) concerning MySQL64: open MySQLResultSet.pas. Look for a function InternalGetString(ColumIndex: Integer): String;
Set a breakpoint there. Is it possible that the PULong incrementing is correct but the PULong size has changed and we point to the midle of nowhere?
elidorio2, On this post you can see how complex your problem is, Edson and w'll need some time and other users to find out what's going wrong. I wish i could consider you i can do it in a half hour but again i can't test it by my selves.
So be patient, don't overhurry and try to help us to help you.
Best regards,
Michael
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
Code: Select all
My problem is that i don't have Windows64
You can get win 7 64 for test http://www.microsoft.com/windows/busine ... mxid=mscom
and install in Virtualbox for test
Lazarus 1.0.8 fpc 2.6.0
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
ism,
Wonderfull! Started to download all the stuff.
This could solve some problems!
Thank you.
Wonderfull! Started to download all the stuff.
This could solve some problems!
Thank you.
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
elidorio2,
good news. Please update your Revision to 1145.
It was more an minior issue than thought before. We wanted access the plaindrivers on ZDbcXXXConnetion.Close with several functions. But the Plaindriver isn't assigned if the dll's where not found.
Also i've tested the PG Connection in Win64+Lazarus64+FPC64 Bit everythingis fine (didn't open any tables)if the files:
libeay32.dll, libiconv-2.dll, libintl-8.dll, libpg.dll, ssleay32.dll are in your !Windows\System32! folder at designtime and/or in your application folder at runtime.
Can you confirm this
And Bad news: selects don't work. Going on...
Now testing MySQL64. Thank ism for that advise.
Best regards,
EgonHugeist
good news. Please update your Revision to 1145.
It was more an minior issue than thought before. We wanted access the plaindrivers on ZDbcXXXConnetion.Close with several functions. But the Plaindriver isn't assigned if the dll's where not found.
Also i've tested the PG Connection in Win64+Lazarus64+FPC64 Bit everythingis fine (didn't open any tables)if the files:
libeay32.dll, libiconv-2.dll, libintl-8.dll, libpg.dll, ssleay32.dll are in your !Windows\System32! folder at designtime and/or in your application folder at runtime.
Can you confirm this
And Bad news: selects don't work. Going on...
Now testing MySQL64. Thank ism for that advise.
Best regards,
EgonHugeist
Last edited by EgonHugeist on 11.04.2012, 21:39, edited 2 times in total.
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Same with PG...
Hmpf..
Hmpf..
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Wasn't that the same behavoir of the wylton thread?
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/