Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13280
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Cavo reads MySql |
| Date | 2021-03-05 13:33 +0100 |
| Message-ID | <iaemovF6pvqU1@mid.individual.net> (permalink) |
| References | <a953f330-d0d4-4155-9c7e-8b6b1ee51c45n@googlegroups.com> <1066ca7c-6a84-4062-8daf-3a5af9ae5853n@googlegroups.com> <8ed36d65-4458-458e-ba77-c3d61d36af84n@googlegroups.com> |
Hi Henry,
something like that should work:
cDriver := "MySQL ODBC 3.51 Driver"
cServer := "192.168.254.20"
cDB := "MyDB"
cUser := "myuser"
cPassword := "Mypassword"
oConn := SQLConnection{}
cConnectString := "DRIVER={" + cDriver + "};SERVER=" + cServer + ;
";DATABASE=" + cDB + ";UID=" + cUser + ";PWD=" + cPassword + ;
"; OPTION=3" // OPTION=16834"
oConn:DriverConnect( self, SQL_DRIVER_NOPROMPT, cConnectString )
But please pay attention if your provider permits external access to
the database!
Normally internet server databases are not opened for external
connections!
Wolfgang
Henry Fidler wrote:
> Fábio many thanks
>
> I understand I have to use:
> <oSQLConnection>:Connect([<cDataSource>], [<cUserID>], [<cPassword>])
>
> I have a WordPress website which uses a MySql DataBank with a name
> and password. What will be the cDataSource?
>
> Many thanks
> Henry
--
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-04 10:16 -0800
Re: Cavo reads MySql Fabio Rotheia <fabiorotheia@gmail.com> - 2021-03-04 20:15 -0800
Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-05 03:27 -0800
Re: Cavo reads MySql "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-03-05 13:33 +0100
Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-05 11:36 -0800
Re: Cavo reads MySql Franz Rachbauer <office@rachbauer.org> - 2021-03-06 09:24 +0100
Re: Cavo reads MySql "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-03-07 17:24 +0100
Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-08 05:48 -0800
Re: Cavo reads MySql Phil McGuinness <sherlocksoftware@gmail.com> - 2021-03-09 02:16 -0800
Re: Cavo reads MySql Henry Fidler <zodcomag@gmail.com> - 2021-03-09 13:04 -0800
csiph-web