How to read MY SQL connection from file?

[temakir11]

I create form with button, when i click on Button1, i want create database, but i not want to write connection parameters to my server in code. I'd like to read them from a file.

--------
#EndRegion ### END Koda GUI section ###
Dim $server, $db, $user, $password,$ConnObj,$RezObj
$server = IniRead ( "read.ini", "Server ", "Server", "default" )
$user = IniRead ("read.ini", "uid ", "uid", "default")
$password = IniRead ("read.ini", "password ", "Password", "default")

While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit
        Case $Button1
        $sqlCon = ObjCreate("ADODB.Connection")
        $sqlCon.Open("Provider={SQLOLEDB};Data Source="& $server & ";uid=" & $user & ";pwd=" & $password & ";")
        $sqlCon.Execute( "create database testtest", $sqlCon )
        Exit


EndIf

EndSwitch
WEnd

But AutoIT not create database on my server

my .ini file:

[server]
Server = TestServer

[uid]
User ID = sa

[password]
Password = testets

 

[BrewManNH]

Your IniRead is wrong for one of the parameters.

$user = IniRead ("read.ini", "uid ", "uid", "default")
; This should be like this
$user = IniRead ("read.ini", "uid ", "User ID", "default")

If that doesn't work, remove the space in the key for User ID and rewrite the IniRead above. Let us know if that worked.

[temakir11]

RESOLVE