Sign in to follow this  
Followers 0
blumi

SQL Connection without UDFs

10 posts in this topic

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

Share this post


Link to post
Share on other sites



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


TCP server and client - Learning about TCP servers and clients connection
Au3 oIrrlicht - Irrlicht project
Au3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related)



460px-Thief-4-temp-banner.jpg
There are those that believe that the perfect heist lies in the preparation.
Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost.

 

Share this post


Link to post
Share on other sites

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. :-(

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

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 by Zedna

Share this post


Link to post
Share on other sites

This

Driver={SQL Server};

I don't have to change?

Share this post


Link to post
Share on other sites

#10 ·  Posted (edited)

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

Change only values inside %%

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

Edited by Zedna

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0