SQL --this object has failed

[xueshan007050]

I have got a problem,ask some help

when I run this script,get errors

#include <SQLite.au3>

#include <Excel.au3>

#include <Array.au3>

#include <DBOperate.au3>

#include <String.au3>

#include <ADO Constants.au3>

;Open the Database

$sqlCon=ObjCreate("ADODB.Connection")

$conDSN=("DRIVER={SQL Server};SERVER=10.30.12.203;DATA3ASE=MSDB;UID=Sa;PWD=LC1234,;")

$sqlCon.Open($conDSN)

;_SQLite_Exec(-1,"INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[bUGLIST] (LISTID) VALUES ("15")")

$sqlCon.Execute("INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[bUGLIST] (LISTID) VALUES ('15')")

when i run this script,get error like this

C:\Users\Administrator\Desktop\BugMangment_SQL.au3 (47) : ==> The requested action with this object has failed.:

$sqlCon.Execute("INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[bUGLIST] (LISTID) VALUES ('15')")

$sqlCon.Execute("INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[bUGLIST] (LISTID) VALUES ('15')")^ ERROR

->16:25:45 AutoIT3.exe ended.rc:1

>Exit code: 1 Time: 4.027

[skysel]

$sqlCon.Execute("INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[BUGLIST] (LISTID) VALUES ('" & "15" & "')")"

Try this, it's tricky when it comes to ' and "

Edited March 13, 2013 by skysel

[xueshan007050]

thanks skysel

$sqlCon.Execute("INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[BUGLIST] (LISTID) VALUES ('" & "15" & "')")"

Try this, it's tricky when it comes to ' and "

thank s skysel.

The question had solved.

use this method

;Open the Database

$oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")

$sqlCon=ObjCreate("ADODB.Connection")

$conDSN=("DRIVER={SQL Server};SERVER=10.30.12.203;DATA3ASE=MSDB;UID=Sa;PWD=LC1234,;")

$sqlCon.Open($conDSN)

_SQLite_Exec(-1,"INSERT INTO [MT_BUGMANAGEMENTDB].[dbo].[bUGLIST] (LISTID) VALUES ("15")")

If @error Then

ConsoleWrite("ObjOpen Failed dude ")

Else

ConsoleWrite("ObjOpen Success!! hahaha we did it , Query away ")

EndIf

Func MyErrFunc()

ConsoleWrite("AutoItCOM Test" & @CRLF & "We intercepted a COM Error !" & @CRLF & _

"err.description is: " & @TAB & $oMyError.description & @CRLF & _

"err.windescription:" & @TAB & $oMyError.windescription & @CRLF & _

"err.number is: " & @TAB & Hex($oMyError.number, 8) & @CRLF & _

"err.lastdllerror is: " & @TAB & $oMyError.lastdllerror & @CRLF & _

"err.scriptline is: " & @TAB & $oMyError.scriptline & @CRLF & _

"err.source is: " & @TAB & $oMyError.source & @CRLF & _

"err.helpfile is: " & @TAB & $oMyError.helpfile & @CRLF & _

"err.helpcontext is: " & @TAB & $oMyError.helpcontext & @CRLF )

;"err $sqlString is:" & @TAB &$sqlString& @CRLF )

SetError(1)

EndFunc ;==>MyErrFunc

[jchd]

You are mixing DB engines!

You just can't connect to an MS SQL engine then query it using the SQLite engine.

If you need to connect to different SQL engines, then show all the relevant code. Else stick with one engine at a time.

Also whay's this DBoperate.au3 include? Just curious. Same for ADO constants.au3