Re: Connecting to SQL on a PC

[Charles Miller via 4D_Tech]

The same way, except the drivers are already there. There is an ODBC admin 
function similar to Mac
Log in could be different depending on how access is set up.

Regards

Chuck

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



> On Sep 12, 2017, at 6:38 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> For years, we have had a couple of clients that connect to an SQL server. All 
> the traffic is done using triggers under 4D Server (the triggers run on the 
> server), and we use the Actual OBDC SQL drivers for the connection on a Mac 
> server. Works well.
> 
> Now I have received a request to draw some data back to print on a surgical 
> booking form. I assume that the PC wanting to print will need to request the 
> data. So, how does one connect to an SQL server from a PC?
> 
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.com
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Connecting to SQL on a PC

[Robert McKeever via 4D_Tech]

For years, we have had a couple of clients that connect to an SQL server. All 
the traffic is done using triggers under 4D Server (the triggers run on the 
server), and we use the Actual OBDC SQL drivers for the connection on a Mac 
server. Works well.

Now I have received a request to draw some data back to print on a surgical 
booking form. I assume that the PC wanting to print will need to request the 
data. So, how does one connect to an SQL server from a PC?

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




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