MySQL OpenDatabase Handle 0

[Inner]

Code: Select all

UseMySQLDatabase()
OpenConsole()

    db_openconnection.s = "=host=192.168.0.5 port=3306 dbname=dbo"
    db_user.s = "user"
    db_password.s ="password"

    handle = OpenDatabase(#PB_Any,db_openconnection,db_user,db_password)
    
    PrintN("Handle = "+Str(handle))
        
    CloseDatabase(handle)
    
    
    Delay(1000)
    
CloseConsole()

While in the Pure Basic IDE this results in OpenDatabase returning a handle, however compile it to an executable and the handle is Null.

Is there some compiler option I've missed or some other reason why this is the case?

[Paul]

The UseMySQLDatabase requires libmariadb.dll to be included with your compiled app (it's not statically linked).
Did you copy this file from the "PureBasic\Compilers\" folder into the same folder as your compiled app?

[Inner]

The UseMySQLDatabase requires libmariadb.dll to be included with your compiled app (it's not statically linked).
Did you copy this file from the "PureBasic\Compilers\" folder into the same folder as your compiled app?

I didn't as I was unaware it didn't statically link at compile time. thanks for the assistance.