Date
1 - 6 of 6
unipaas 1.9 with file dsn
|
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
|
|
|
|
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. |
|
|
|
DB2. Right. I knew that.
 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 |
|
|
|
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 |
|
|
|
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
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
|
|
|