SQL... I know this SHOULD work, but never does, why?

[GregThompson]

The start of ANY SQL query within AUTOIT starts with the connection, and that's my problem. It NEVER works.

Global $adCN

$adCN = ObjCreate("ADODB.Connection")

$DSN = "DRIVER={SQL Server};SERVER=xxx;DATABASE=xxx;UID=xxx;PWD=xxx;"

$adCN.Open($DSN)

NEVER works for me.

I put in the right data in the fields above and get this no matter what I do..

Y:\AutoIT\SQL Test\sqltest.au3 (12) : ==> The requested action with this object has failed.:

$adCN.Open($DSN)

$adCN.Open($DSN)^ ERROR

The data is all correct and I'm running Scite ON the MDB server. So? It's Win Server 2008, SQL 2005,

[kylomas]

Greg,

Run it with this error handler and the description should point you at a solution.

$oError = ObjEvent("AutoIt.Error","_Err")

Global $adCN

$adCN = ObjCreate("ADODB.Connection")
$DSN = "DRIVER={SQL Server};SERVER=xxx;DATABASE=xxx;UID=xxx;PWD=xxx;"
$adCN.Open($DSN)


Func _Err($oError)
    ConsoleWrite("err.number is: " & @TAB & $oError.number & @CRLF & _
            "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            "err.description is: " & @TAB & $oError.description & @CRLF & _
            "err.source is: " & @TAB & $oError.source & @CRLF & _
            "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            "err.retcode is: " & @TAB & $oError.retcode & @CRLF & @CRLF)
EndFunc

kylomas

[GregThompson]

Lo and behold it's a windows credentials issue. I can now connect using a SQL account instead. Thank you very much!