Zeos 7 Alpha and Delphi 2009 Support - Official Thread
Moderators: gto, EgonHugeist, olehs
-
- Fresh Boarder
- Posts: 4
- Joined: 13.07.2008, 10:22
- Contact:
Problems with SQLServer
Hi Guys,
I'm getting the following problem when try to local SQLServer:
"Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied. ConnectionOpen (Connect()). "
Does anybody got this problem before??
I'm getting the following problem when try to local SQLServer:
"Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied. ConnectionOpen (Connect()). "
Does anybody got this problem before??
-
- Fresh Boarder
- Posts: 1
- Joined: 02.07.2009, 15:11
Hello,
Reading the news (http://zeos.firmos.at/news_viewnews.php?news_id=2) I read about the Zeos 7:
"... and the following databases/protocols:
ADO
Mysql 4.1 to 6.0,
Interbase 5 / 6
Firebird 1.0 to 2.1
Postgres 7 to 8
SQLite 2.8 to 3"
I would like to know if the Zeos 7 will be able to work with de Oracle Database? Because de Oracle isn't in the list.
thanks
Kenner Grings
Reading the news (http://zeos.firmos.at/news_viewnews.php?news_id=2) I read about the Zeos 7:
"... and the following databases/protocols:
ADO
Mysql 4.1 to 6.0,
Interbase 5 / 6
Firebird 1.0 to 2.1
Postgres 7 to 8
SQLite 2.8 to 3"
I would like to know if the Zeos 7 will be able to work with de Oracle Database? Because de Oracle isn't in the list.
thanks
Kenner Grings
Hi all I'm working on Delphi 2009 few month's ago I was using Delphi 2007 and in my aplication I have working with postgresql 8.3. In delphi 2007 when I want same code in database and aplication in "properties" on ZConnection I have writing some thing like that:
codepage=WIN1250
In delphi 2009 there is error when I'm writing in editbox f.e.g. "ę" or "ą" (it is polisch chars) in my database it is looking like that:
ŻÓĹ?Ä?ŹĆŚĄĹ?
So as you see it is a big error because when I send to db path to file with polish chars db send me an error message.
Help
OK I change codeing of DB on UTF8 and ewerything is ok
codepage=WIN1250
In delphi 2009 there is error when I'm writing in editbox f.e.g. "ę" or "ą" (it is polisch chars) in my database it is looking like that:
ŻÓĹ?Ä?ŹĆŚĄĹ?
So as you see it is a big error because when I send to db path to file with polish chars db send me an error message.
Help
OK I change codeing of DB on UTF8 and ewerything is ok
Last edited by woolfik on 16.07.2009, 09:46, edited 1 time in total.
Why the version 7.X isn't in this repository http://zeosdownloads.firmos.at/downloads/snapshots/ ?
6.x doesn't work in D2009, ok ?! Somebody can post this version, please ?
6.x doesn't work in D2009, ok ?! Somebody can post this version, please ?
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
All versions in http://zeosdownloads.firmos.at/downloads/snapshots/ are 7.x development snapshots. it's the most recent you can get.
Mark
Mark
Hi All,
We trying a small thing and had been posted at zeosbugs.
This little snapshot my code:
But unfortunatelly, its doesn't work when retrieving back to view at my cxImage.
I'm use developer express latest version 6.45.
When using the Ado connection / ado related component, its running normally.
I'm also trying using like this : Assigning from cxImage
The error appear with : JPEG Error #53 when using this snap code :
the table :
create table image_emp ( foto longblob );
This problem appear when we upgrading into Delphi 2009, in D2007 its working normally.
I'm trying to search the Post method / saving procedure ... but still can't find it.
Maybe the ZeosLib teams can be fixed this one ... immediately if possible.
PS: MySQL 5.1.30, D2009 Update 3, 4, boost update, Zeos 6.6.5- Trunk 680
Thank you
Man'z
We trying a small thing and had been posted at zeosbugs.
This little snapshot my code:
Code: Select all
procedure TForm1.Button1Click%u28Sender%u3a TObject%u29;
var
J%u3a TJPEGImage;
begin
J %u3a= TJPEGImage.Create;
J.LoadFromFile%u28'C%u3a\Manz\Projects\Web\hrms\public_html\images\photo\1357a.jpg'%u29;
zTable2.Active %u3a= true;
ztable2.Append;
ztable2.FieldByName%u28'foto'%u29.Assign%u28J%u29;
ztable2.Post;
FreeAndNil%u28J%u29;
end;
I'm use developer express latest version 6.45.
When using the Ado connection / ado related component, its running normally.
I'm also trying using like this : Assigning from cxImage
Code: Select all
cxImage1.Properties.GraphicClassName %u3a= 'TJPEGImage';
zTable1.Active %u3a= true;
zTable1.Append;
zTable1.FieldByName%u28'foto'%u29.Assign%u28cxImage1.Picture.Graphic%u29;
zTable1.Post;
Code: Select all
// for retrieving JPG Image from table
J %u3a= TJpegImage.Create;
J.Assign%u28zTable1.FieldByName%u28'foto'%u29 as TBlobField%u29;
cxImage1.Picture.Graphic %u3a= J;
FreeAndNil%u28J%u29;
create table image_emp ( foto longblob );
This problem appear when we upgrading into Delphi 2009, in D2007 its working normally.
I'm trying to search the Post method / saving procedure ... but still can't find it.
Maybe the ZeosLib teams can be fixed this one ... immediately if possible.
PS: MySQL 5.1.30, D2009 Update 3, 4, boost update, Zeos 6.6.5- Trunk 680
Thank you
Man'z