🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3454

Re: MySQL and BCB5 pro

#3454
From: Vassiliev V.V.
Date: Fri, 30 Aug 2002 08:42
83 lines
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-mail
References: <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