_SQL.au3. ADODB.Connection

[t0nZ 31]

For now I had no time, but I'am interested.

The main difference for me is that if you configure the odbc connector you can force driver level read only behaviour.

I let you know  if I try...

[Rijswijker 0]

Hi,

I am not able to execute the following sql query.

_SQL_Execute(-1,"INSERT INTO KKSPERRE (HashNr, TeilKkNr, KkSperrbehandlung, KkGes) VALUES('1234', CONVERT(varbinary, '12345678901234'), 0, 'VIEL')")

I get the error.

"C:\Users\Administrator\Desktop\_sql.au3" (402) : ==> The requested action with this object has failed.:
$hQuery = $hConHandle.Execute($vQuery)
$hQuery = $hConHandle^ ERROR

I think the issue is in the CONVERT() part, i am not able to test it without the convert part because it is an existing running database.
If i run the query in the SQL Management Studio the query is executing fine.

How can i solve this with this library?
Thanks in advance

[mLipok 1,319]

Did you try my ADO.au3 UDF   ?

Did you set up COM Error Handler ?
What you get from COM Error Handler ?

 

[mLipok 1,319]

9 hours ago, Rijswijker said:

I think the issue is in the CONVERT() part, i am not able to test it without the convert part because it is an existing running database.
If i run the query in the SQL Management Studio the query is executing fine.

This mean that your QUERY is correct. The problem has other nature.
Maybe you are using inproper driver/provider in your connection string ?

 

[Rijswijker 0]

3 hours ago, mLipok said:

Did you try my ADO.au3 UDF   ?

Did you set up COM Error Handler ?
What you get from COM Error Handler ?

 

I tried now, but i get an error:

###############################
ADO.au3 (769) : ==> COM Error intercepted !
$oADO_Error.description is:     [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  769
$oADO_Error.source is:  Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:    
$oADO_Error.helpcontext is:     0
###############################

Is the SQL driver to old from the Autoit engine?

[mLipok 1,319]

I think you have problem with your connection string.
And could you try using SQLNCLI  provider ?

 

[Rijswijker 0]

I still get no database connection, here the part of my code.

Code:

Local $sDriver = 'SQLNCLI'
    Local $sDatabase = 'PARK_DB'
    Local $sServer = '172.16.240.148'
    Local $sUser = 'administrator'
    Local $sPassword = 'password'

    ; Local $sConnectionString = 'DRIVER={' & $sDriver & '};SERVER=' & $sServer & ';DATABASE=' & $sDatabase & ';UID=' & $sUser & ';PWD=' & $sPassword & ';'
    ; 2nd attempt
    Local $sConnectionString = 'PROVIDER={' & $sDriver & '};SERVER=' & $sServer & ';DATABASE=' & $sDatabase & ';UID=' & $sUser & ';PWD=' & $sPassword & ';'

    ; Create connection object
    Local $oConnection = _ADO_Connection_Create()

    ; Open connection with $sConnectionString
    _ADO_Connection_OpenConString($oConnection, $sConnectionString)

Error(s):

###############################
ADO.au3 (769) : ==> COM Error intercepted !
$oADO_Error.description is:     [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  769
$oADO_Error.source is:  Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:    
$oADO_Error.helpcontext is:     0
###############################

2nd attempt
###############################
ADO.au3 (769) : ==> COM Error intercepted !
$oADO_Error.description is:     Provider cannot be found. It may not be properly installed.
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:  80020009
$oADO_Error.lastdllerror is:    0
$oADO_Error.scriptline is:  769
$oADO_Error.source is:  ADODB.Connection
$oADO_Error.helpfile is:    C:\Windows\HELP\ADO270.CHM
$oADO_Error.helpcontext is:     1240655
###############################

 

[mLipok 1,319]

SQLNCLI is an abbreviation, you should check the name here:

 

btw.

It should be instaled, as this is not a standard Windows component.

Edited August 17, 2018 by mLipok

[Rijswijker 0]

Thanks the application is working when i run it on the SQL Server it self.
The tool should be running on the server it self so the problem is solved for now.

However, I still have a question, how can I find out which driver is using the SQL Server?
I now use the Driver "SQL Server Native Client 11.0", and I can connect from the server itself.
But from a remote computer I can not connect to the SQL Server using the same driver, how could that be?

Maybe the (small) difference in the versions?
I am not really at home in this, but how can you update a driver or install it on the client?
Is this only possible to install an SQL Server on the client?

I hope you can answer my questions, thanks in advance!

[mLipok 1,319]

This is related to connection string and firewall on sql server.

 

 

Edited August 17, 2018 by mLipok

[skynet0504 0]

How to use it ??? 

_sql.au3

[mLipok 1,319]

Start using ADO.au3