Re: How to connect to a 4d ODBC server across a network

[Tom Benedict via 4D_Tech]

>Is it possible to create a UserDSN or SystemDSN that can find the server
>located across the network??

My experience is a few years old, but you should be able to do this. The 
documentation which comes with the 4D ODBC driver (here’s the link for 4D ODBC 
Driver v17: 4D ODBC  
DRIVERhttps://doc.4d.com/4Dv17/4D/17/4D-ODBC-Driver.100-3786159.en.html
 https://doc.4d.com/4Dv17/4D/17/4D-ODBC-Driver.100-3786159.en.html>) 
describes how to configure the UserDSN or SystemDSN. Take care that you are 
using the correct version, 32-bit or 64 bit. Are you doing this on Windows? If 
so, make sure you’re using the correct 32 or 64 bit version of ODBC Data Source 
Administrator. It might be called Data Sources (ODBC) in Control Panels.

HTH,

Tom Benedict

> On Apr 10, 2019, at 16:34, msherloc via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I am accessing (via an SQL query) my 4D database across a network.
> The 4d ODBC database is situated on one server and the software I will be
> querying the database will be on another server.
> Is it possible to create a UserDSN or SystemDSN that can find the server
> located across the network??
> 
> Not sure how to do his and keen for some advice
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: How to connect to a 4d ODBC server across a network

[Stephen J. Orth via 4D_Tech]

We have a similar situation, but it's simply because we don't want to have to 
install the ODBC on every Client.

The way I get around this is to separate the SQL query into it's own method, 
and have it run on the Server.  This way there is only 1 ODBC System DSN.

The method packs the results into an Object (JSON format) and returns the 
results back to the Client method, where it is unpacked and displayed to the 
user.

Hope that helps!


Best,


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc.  Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of msherloc via 4D_Tech
Sent: Wednesday, April 10, 2019 6:35 PM
To: 4d_tech@lists.4d.com
Cc: msherloc 
Subject: How to connect to a 4d ODBC server across a network

I am accessing (via an SQL query) my 4D database across a network.
The 4d ODBC database is situated on one server and the software I will be 
querying the database will be on another server.
Is it possible to create a UserDSN or SystemDSN that can find the server 
located across the network??

Not sure how to do his and keen for some advice



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to connect to a 4d ODBC server across a network

[Chuck Miller via 4D_Tech]

you have to create odbc connection on whatever machine you are running sql from


 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Apr 10, 2019, at 7:34 PM, msherloc via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am accessing (via an SQL query) my 4D database across a network.
> The 4d ODBC database is situated on one server and the software I will be
> querying the database will be on another server.
> Is it possible to create a UserDSN or SystemDSN that can find the server
> located across the network??
> 
> Not sure how to do his and keen for some advice

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**