Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13280

Re: Cavo reads MySql

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>

Show all headers | View raw


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


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