unipaas 1.9 with file dsn


Mike Moore
 

I don't see any reply to this.

Is is possible to configure uniPaaS 1.9 to connect to a data source using a File DSN?

We have a working connection using System DSN, but I prefer File DSN.


Thanks.




From:        postraider@...
To:        main@magicu-l.groups.io
Date:        04/19/2017 10:31 PM
Subject:        [magicu-l] unipaas 1.9 with file dsn using MS Access




Hello Group,

how can unipaas or XPA connect to an Access DB using ODBC with a file DSN stored on a server?

Connecting through System DSN may be a problem, cause not every Client has the rights to write the ODBC Informations to the Windows Registry

and I don't want to log in as admin on every machine and do the settings manually.

Greets

Roger




Steven Blank
 

Hi Mike,

Are you, as in the earlier post, also wanting to connect to an MS Access DB?

'Cause if you're wanting to connect to a PSQL database, you don't need a local DSN at all, System, User, File, whatever.

Else, I should think that it wouldn't matter to uniPaaS or XPA what TYPE of DSN is was, although it may indeed matter WHERE a file DSN is stored.

HTH
Steve Blank


Mike Moore
 

Thanks, Steve.

I am connecting to IBM i DB2. We have it working with a System DSN, but I prefer to use a file DSN.




From:        "Steven Blank" <sgblank@...>
To:        main@magicu-l.groups.io
Date:        08/16/2017 06:06 AM
Subject:        Re: [magicu-l] unipaas 1.9 with file dsn




Hi Mike,

Are you, as in the earlier post, also wanting to connect to an MS Access DB?

'Cause if you're wanting to connect to a PSQL database, you don't need a local DSN at all, System, User, File, whatever.

Else, I should think that it wouldn't matter to uniPaaS or XPA what TYPE of DSN is was, although it may indeed matter WHERE a file DSN is stored.

HTH
Steve Blank






Steven Blank
 

DB2. Right. I knew that.
 
Winking smile
 
 
From: Mike Moore
Sent: Wednesday, August 16, 2017 1:02 PM
Subject: Re: [magicu-l] unipaas 1.9 with file dsn
 
Thanks, Steve.

I am connecting to IBM i DB2. We have it working with a System DSN, but I prefer to use a file DSN.




From:        "Steven Blank" <sgblank@...>
To:        main@magicu-l.groups.io
Date:        08/16/2017 06:06 AM
Subject:        Re: [magicu-l] unipaas 1.9 with file dsn




Hi Mike,

Are you, as in the earlier post, also wanting to connect to an MS Access DB?

'Cause if you're wanting to connect to a PSQL database, you don't need a local DSN at all, System, User, File, whatever.

Else, I should think that it wouldn't matter to uniPaaS or XPA what TYPE of DSN is was, although it may indeed matter WHERE a file DSN is stored.

HTH
Steve Blank






Andy Jerison
 

The ODBC gateway connects to 32-bit ODBC. Any connection you create should be available to the gateway. I doubt it's even possible for the gateway to determine whether it's a file or system DSN.

On Wed, Aug 16, 2017 at 3:02 PM, Mike Moore <mmoore@...> wrote:
Thanks, Steve.

I am connecting to IBM i DB2. We have it working with a System DSN, but I prefer to use a file DSN.




From:        "Steven Blank" <sgblank@...>
To:        main@magicu-l.groups.io
Date:        08/16/2017 06:06 AM
Subject:        Re: [magicu-l] unipaas 1.9 with file dsn




Hi Mike,

Are you, as in the earlier post, also wanting to connect to an MS Access DB?

'Cause if you're wanting to connect to a PSQL database, you don't need a local DSN at all, System, User, File, whatever.

Else, I should think that it wouldn't matter to uniPaaS or XPA what TYPE of DSN is was, although it may indeed matter WHERE a file DSN is stored.

HTH
Steve Blank







Mike Moore
 

Thanks, Andy.

Magic Support says File DSN is not supported, and that matches my experience and what others have told me.




From:        "Andy Jerison" <droidaj@...>
To:        main@magicu-l.groups.io
Date:        08/16/2017 09:14 AM
Subject:        Re: [magicu-l] unipaas 1.9 with file dsn




The ODBC gateway connects to 32-bit ODBC. Any connection you create should be available to the gateway. I doubt it's even possible for the gateway to determine whether it's a file or system DSN.

On Wed, Aug 16, 2017 at 3:02 PM, Mike Moore <mmoore@...> wrote:
Thanks, Steve.

I am connecting to IBM i DB2. We have it working with a System DSN, but I prefer to use a file DSN.





From:        
"Steven Blank" <sgblank@...>
To:        
main@magicu-l.groups.io
Date:        
08/16/2017 06:06 AM
Subject:        
Re: [magicu-l] unipaas 1.9 with file dsn




Hi Mike,

Are you, as in the earlier post, also wanting to connect to an MS Access DB?

'Cause if you're wanting to connect to a PSQL database, you don't need a local DSN at all, System, User, File, whatever.

Else, I should think that it wouldn't matter to uniPaaS or XPA what TYPE of DSN is was, although it may indeed matter WHERE a file DSN is stored.

HTH
Steve Blank