ODBC Data Source Automation Script

[ORyan]

Hello, I am working on an AUTOIT script to automate the manual setup process of an ODBC Data Source using the Microsoft Visual FoxPro Driver.

I already wrote a hard coded script to setup a data source. The problem is the driver I need is not located in the same position on every computer.

What I am trying to do is make it dynamic for use with all Windows O/S's. I have the two following questions, and don't know which way will work or which is possible...

1) How can you get the currently selected text of a listbox via an HWND?

-OR-

2) How can I obtain an array of all the items within the listbox via HWND, that way I can get the index of the list item?

The list view I am trying to access is found by doing the following...

-> Press 'Windows Key' + 'R'

-> Enter "odbcad32.exe"

-> Click 'Add...'

The Add New Data Source Wizard will pop up, it contains a list of drivers available on the computer to choose from.

In order to test this you will need to download and install the ODBC Data Source Driver for Microsoft Visual FoxPro from Microsoft.

http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx

You will also need to create an db called EI in Microsoft Visual FoxPro, or download and extract the attached EI.zip file to your C:\ directory. When extracted the file structure should resemble "C:\EI\DATA\EI.DBC".

Attached is the code I wrote to setup an ODBC Data Source using the Microsoft Visual FoxPro Driver is attached as ODBC.au3.

Thank you,

O'Ryan

EI.zip

ODBC.au3

[PsaltyDS]

Hello, I am working on an AUTOIT script to automate the manual setup process of an ODBC Data Source using the Microsoft Visual FoxPro Driver.

I already wrote a hard coded script to setup a data source. The problem is the driver I need is not located in the same position on every computer.

What I am trying to do is make it dynamic for use with all Windows O/S's. I have the two following questions, and don't know which way will work or which is possible...

1) How can you get the currently selected text of a listbox via an HWND?

-OR-

2) How can I obtain an array of all the items within the listbox via HWND, that way I can get the index of the list item?

The list view I am trying to access is found by doing the following...

-> Press 'Windows Key' + 'R'

-> Enter "odbcad32.exe"

-> Click 'Add...'

The Add New Data Source Wizard will pop up, it contains a list of drivers available on the computer to choose from.

In order to test this you will need to download and install the ODBC Data Source Driver for Microsoft Visual FoxPro from Microsoft.

http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx

You will also need to create an db called EI in Microsoft Visual FoxPro, or download and extract the attached EI.zip file to your C:\ directory. When extracted the file structure should resemble "C:\EI\DATA\EI.DBC".

Attached is the code I wrote to setup an ODBC Data Source using the Microsoft Visual FoxPro Driver is attached as ODBC.au3.

Thank you,

O'Ryan

Automating that GUI is the hard way. I know, because I did it about two years ago.

Instead, just create\edit the registry keys in HKLM\SOFTWARE\ODBC\ODBCINST.INI\ to add\check drivers, and DSNs at HKLM\SOFTWARE\ODBC\ODBC.INI\{DSN_Name}.

[ORyan]

Thank you, for the tip on enumerating the keys from the registry. That worked great.

O'Ryan