Bdpconnections

Thread View: borland.public.delphi.database.dotnet

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by kalmen Thu, 19 Oct 2006 01:17

#140

Author: kalmen
Date: Thu, 19 Oct 2006 01:17

32 lines
2081 bytes

Hi ,

I have BDS Ent 2006 , try to use the BdpConnection for the mysql 5.0
, successfully created a myconnection in the Bdpconnection and test 
connected successfully.
then i drop the BdpCommand , right click open up command text editor , 
select the drop
down combobox for the connection , it then display "Unsupported datatype" , 
why ?
Any idea as I tried the Interbase or Firebird Connections with no such 
problem ?
but is it BDPConnection cannot work with the Mysql5.0 ?

I have also downloaded the mysql.net connector from mysql web site, and 
registered the connector for delphi ,
I can see the component appear in the generate tab as MySqlCommand , 
MySqlConnection and MySqlDataAdapter ,has anyone have successfully use that 
for BDS2006 ?

I have also tried to look for the TAdoconnection for the ADO.net connection 
but i cannot find , is there
any such TADOConnection in the BDS2006.net  (not win32) ?

Please help , as i am trying to get connected with my MySQL database , i 
can't even connect this , with
10 over years of delphi experiences since Delphi 1.0 , i really feel 
discourage ... what went wrong with
my experiences ... any help is much appreciated. Thanks.


Regds,
Kal

Re: Bdpconnections

#142

Author: Bob Swart
Date: Thu, 19 Oct 2006 06:54

20 lines
1696 bytes

Hi kalmen,

> I have BDS Ent 2006 , try to use the BdpConnection for the mysql 5.0

Please note that BDP in Delphi 2006 only supports MySQL version 4.0.24, 
and version 5.0 is officially not supported (hence probably your 
problems)...
See CoreLab (www.crlab.com) for a third-party driver that can connect 
with MySQL 5.0.

> Regds,
> Kal 

Groetjes,
           Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads