Article View: borland.public.cppbuilder.database.ado
Article #3454Re: MySQL and BCB5 pro
From: Vassiliev V.V.
Date: Fri, 30 Aug 2002 08:42
Date: Fri, 30 Aug 2002 08:42
83 lines
3637 bytes
3637 bytes
Try to do this. It should work. Regards, Vassiliev V.V. http://www.oledbdirect.com "Jackie" <tkfi@hotmail.com> �������/�������� � �������� ���������: news:3d6f068f$1@newsgroups.borland.com... > Hi VV > How about if MySql are not run on locally but run on the server (Linux) and > all the client have to connect it through the network , can i still use > the method that you told. > > Thanks > > > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> ���g��l�� > news:3d6c6897@newsgroups.borland.com... > > I assume you are using ADO Express (or dbGo as it is named in BCB6) and > > MySQL is on your computer. > > > > Native OLEDB provider for MySQL is at > > > > http://www.mysql.com/Downloads/Win32/MyOLEDB.exe > > http://www.mysql.com/Downloads/Win32/MyOLEDB.chm > > > > 1. Create new project. > > 2. Drop TADOConnection on main form. > > 3. Press "ConnectionString button" (...). > > 4. Press "Build". > > 5. Choose "MySQL.OLEDB Provider". Press "Next" > > 6. Set Data Source to "test". > > 7. Press Check Connection - it should be successfull. > > 8. Press OK. > > 9. Set LoginPrompt property to False; > > 10. Set Connected property to True. > > 11. Drop TADOTable on the form and set its Connection property to > > ADOConnection1. > > 12. Set TableName to "sample2". > > 13. Set Active property to True. > > 14. Add TDataSource and TDBGrid on the form, connect them to ADOTable1 as > > usual. > > > > Now you should see data from sample2 table from test database (this > database > > goes with MySQL). Look ConnectionString property of ADOConnection1 in IDE > > for details. > > > > Connection string in my case is > > Provider=MySqlProv.2.5;Data Source=test;Integrated > > Security="";Password="";User ID="";Location="";Extended Properties="" > > but > > Provider=MySqlProv.2.5;Data Source=test; > > works too. > > > > You can do all this from source code. > > > > P.S. If in Connection String dialog you will choose "MySQL.OLEDB Provider" > > and press "Check connection" without setting Data Source, you will see a > > dialog where you can enter properties, such as Host IP etc. > > > > Regards, > > Vassiliev V.V. > > http://www.oledbdirect.com > > > > "Alain ROGER" <pmdander@hotmail.com> ???????/???????? ? ???????? > ?????????: > > news:3D6A317F.2090107@hotmail.com... > > > Hi, > > > I would like to know if i'm able to use MySQL with BCB5 pro ? > > > if yes, is there some tips or things to do to use MySQL with BCB ? > > > TIA, > > > Alain > > > > > > > > >
Technical Details
Message-ID:
<3d6f35e4@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3D6A317F.2090107@hotmail.com> <3d6c6897@newsgroups.borland.com> <3d6f068f$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,f7dfe48e1044e8e0 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-08-30 02:19:44 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3D6A317F.2090107@hotmail.com> <3d6c6897@newsgroups.borland.com> <3d6f068f$1@newsgroups.borland.com> Subject: Re: MySQL and BCB5 pro Date: Fri, 30 Aug 2002 12:42:21 +0400 Lines: 85 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.136.39 Message-ID: <3d6f35e4@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1030698468 62.118.136.39 (30 Aug 2002 02:07:48 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail