Creating ODBC DSN with Ingres 2.6

[steveaust]

I'm an MS Access/VB/Foxpro database programmer new to Ingres.
I need to write a MS Access app for a windows XP client machine, with no administrator rights.
The environment is a hospital and the server runs on linux, presumably in the IT department to which I do not have access to.

I have read the "How to Use Ingres ODBC With MS Access" article from the Ingres Community Wiki.

It recommends to use an ODBC DSN (Data source definition) to connect to the target database.
To do this, it then goes on and talks about using the "ODBC Data Source Administrator" feature.
All good and well, but I do not have a "Data Source Administrator" on my client desktop.

I do have the Ingres II / Ingres Visual DBA tab, and I can see the "node" I need to connect to, and there I can build SQL commands (with the "SQL test" option upon right clicking the node)
This returns the records I need, but now I need to do it in my access app.

Any help would be very much appreciated.

[gerhard.hofmann]

ODBC Data Source Administrator means --> Start --> run --> odbcad32.exe

You will also find a shortcut in your Windows control panel for it. ODBC Data Source Administrator is not an Ingres application, it's shipped with Windows.

HTH
Gerhard

[thoda04]

You can find detailed information on configuring ODBC data sources in the Ingres Connectivity Guide, "Understanding ODBC Connectivity" chapter, in the section "Configure a Data Source (Windows)".

You can also get more information on Ingres ODBC in the Ingres wiki at Ingres ODBC Development Center - Ingres Community Wiki.

Hope this helps,
Dave

[steveaust]

Thanks so much Gerhard & Dave. I am on the right track now.

Its astonishing I have never heard of ODBC Data Source Administrator as a part of windows! I have of course used ODBC data connections in access before, adding them to forms and configuring them in access.
Learning never ceases.
Thanks again
Steve, Australia.