On Mon, 26 Aug 2013, Bruce wrote:
> What syntax for "DatabaseURL As String"?
>
> I'm trying to create a connection to an SQLite db in a different gambas
> project source directory:
>
> $conn = New
>
> Connection("/share/projects/gambas3_proj/horse/horseBO/.connection/bometa.connection")
>
> (and various other path strings to the connection definition).
>
> All I get is "Malformed URL" error.
>
>From the sources, I deduce the following format (and it works here):
$TYPE://$USER@$HOST:$PORT/$DB
where the :$PORT part is optional.
So to connect to something like
hConn = New Connection
With hConn
.Type = "mysql"
.Login = "root"
.Password = "toor"
.Host = "localhost"
.Port = 3306
.Name = "test"
.Open()
End With
you could write
hConn = New Connection("mysql://root@localhost:3306/test")
hConn.Passwort = "toor"
hConn.Open()
Regards,
Tobi
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
