SQL Connection without UDFs

[blumi]

I want to use Autoit to connect to a SQL Server and do some queries.

I have found some UDFs but I want to do it without them.

Are there some good links or tutorials for SQL and AutoIt without the UDFs?

Thanks

[Bert]

Why do you wish to do them without the UDFs? The UDF makes it easier to do for they did most of the work you are proposing to do.

[Bert]

If anything you can look at the UDF's code and chop out what you need if your reason is to just making the code shorter.

[bogQ]

well you have the UDF, edit it with scite and see how its made ...

or hit forum search with SQL ...

While i don't see the point of your question or you dont understand the point of not using UDF-s i hope you'll understand my answer

[blumi]

Why do you wish to do them without the UDFs? The UDF makes it easier to do for they did most of the work you are proposing to do.

Sure it will be easier with the UDF, but I want to learn the syntax for SQL connect and usage.

I took a look in the udf with scite but did not understand everything. :-(

[Zedna]

Search this forum for ADODB

Here is my simple example:

EDIT:

ADO very good tutorial

http://www.w3schools.com/ado/default.asp

Edited July 27, 2011 by Zedna

[blumi]

Okay will take a look for the search etc.

What about the driver I found in one UDF

$driver = "{MySQL ODBC 3.51 Driver}"
$port = 3306

Local $v = StringMid($driver, 2, StringLen($driver) - 2)
Local $key = "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers", $val = RegRead($key, $v)

Do I need this?

[Zedna]

What about the driver I found in one UDF

Do I need this?

No. You need only DSN string for connection, for MS SQL Server it' like this (as you can see in my example from my above post):

"Driver={SQL Server};Server=server;Database=master;Uid=user;Pwd=password;"

Edited July 27, 2011 by Zedna

[blumi]

This

Driver={SQL Server};

I don't have to change?

[Zedna]

"Driver={SQL Server};Server=%server%;Database=%master%;Uid=%user%;Pwd=%password%;"

Change only values inside %%

EDIT: Search this forum for examples for this ...

Edited July 28, 2011 by Zedna