ODBC access from 3rd party ap

John Irwin johni at gse.upenn.edu
Sat Dec 17 02:30:09 EST 2011


I did try running C:\Windows\SysWOW64\odbcad32.exe and didn't see any
Omnis ODBC Driver.

So maybe the driver is not getting installed.
Maybe I'm not running the installer properly.
How is that done?


John 

-----Original Message-----
From: omnisdev-en-bounces at lists.omnis-dev.com
[mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Philip
Potter
Sent: Friday, December 16, 2011 5:31 PM
To: OmnisDev List - English
Subject: Re: ODBC access from 3rd party ap

John,
Did you try running
C:\Windows\SysWOW64\odbcad32.exe
the 32bit ODBC administrator?
Did you not see the driver 'Omnis ODBC Driver'?

Omnis is 32bit and the ODBC driver is 32bit, so you need to run the 32bit
administrator and use a 32bit DSN.

I have successfully used this on a local machine, never tried over a
network.
regards
Phil.

On 16/12/2011 19:51, John Irwin wrote:
> How can I connect to an Omnis 7/Studio datafile using ODBC?
>
>
>
> Initially I want to connect from a 3rd party app on Windows 7 PC, but 
> later will want to connect from the same app on another source, 
> probably Windows Server, but not sure.
>
> I'll check on that.
>
>
>
> But initially how do I turn on access using my Studio 3.3.3 software 
> for Windows 7  access?
>
> I think I need to open up the datafile files to outside ODBC access 
> using the ODBC Admin tool included with Studio, and then configure a 
> driver in the OS of the other system for Omnis ODBC and point it at the
datafile.
>
>
>
> I'm looking at technote TNSQ0003.
>
> I don't understand the terminology. I want to setup access from a 
> third party application to my Omnis data.
>
> I see how to enter a user and password in the ODBC Administration tool 
> but don't get what the user Groups are.
>
> Is this what I should be looking at?
>
>
>
> To setup a driver I've also I tried:
>
> ODBC Driver without Databridge on Vista-64/Windows 7-64
>
> ----------------------------------------------------------------------
> --
>
> And now for the funny part of it: After having installed the ODBC 
> driver itself, you will try to configure a DSN in the ODBC Data 
> Sources Administrator in your Control Panel. You probably will not be 
> able to configure it (Omnis not listed), or if you do, it will crash 
> when you use it. What happened?
>
> Read carefully: In Win7-64, the control panel will open the 64-bit 
> ODBC Administrator program odbcad32.exe. Yes, it is called *32*, but 
> it is 64 bit. To access the Omnis ODBC driver, you need the 32bit ODBC 
> Admin program.
>
> You will be happy to discover there is an odbcad32.exe program in your
>
> Windows/system32 directory, too. Don't be disappointed if you start it 
> and you still can not configure your ODBC driver: The odbcad32.exe in 
> the
>
> system32 directory is the 64bit version which is also started from the 
> Control Panel! The 32-bit version of it is also called odbcad32.exe 
> (nice, isnt' it?), but it can be found in Windows/syswow64 ! Confusion
complete.
> So just start the odbcad32.exe in Windows/syswow64, and you will be 
> able to configure your ODBC driver for Omnis.
>
>
>
> But still nothing shows as a driver for Omnis.
>
> So I need to know how to make the driver show in the ODBC admin tool 
> on Windows 7.
>
>
>
> Thanks in advance.
>
>
>
> John
>
>
>
> According to the U.S. Department of Energy, if every American home 
> replaced just one lightbulb with an ENERGY STAR CFL bulb, we would 
> save almost six billion kWh per year.
>
>
>
> Population growth, food production plateauing, water shortages, 
> climate change mean big things need to be done, and soon. What will 
> you do about it?
>
>
>
> Read World on the Edge: How to Prevent Environmental and Economic 
> Collapse by Lester Brown for a proposal of what can be done. It's 
> available free online at:
>
> http://www.earth-policy.org/images/uploads/book_files/wotebook.pdf
>
>
>
> Always be a little kinder than necessary. - James M. Barrie
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
>

-- 

P G Potter, 11 Regency Court, Mickle Trafford, Chester, UK.

This message is confidential and intended for the use only of the person
to whom it is addressed. If you are not the intended recipient you are
strictly prohibited from reading, disseminating, copying, printing,
re-transmitting or using this message or its contents in any way. 
Opinions, conclusions and other information expressed in this message are
not given or authorised by the Company unless otherwise indicated by an
authorised representative independent of this message. The Company does
not accept liability for any data corruption, interception or amendment to
any e-mail or the consequences thereof. Emails addressed to individuals
may not necessarily be read by that person unless they are in the office.

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com



More information about the omnisdev-en mailing list