Re: Database to Indesign: Questions

Article View: adobe.scripting.indesign

Article #9147

Back to adobe.scripting.indesign Previous Next

#9147

From: Olav_Kvern
Date: Mon, 11 Sep 2006 19:39

9 lines
1470 bytes

Hi WJALLEN,

re: "I am using JavaScript to work on Mac or PC, but I want to access a SQL Server database on a database server in the same domain. Right now, I can't find any examples of connecting to a SQL Server database within an InDesign script."

The version of JavaScript used by InDesign is Adobe's ExtendScript. While it can access files and folders on your system (using the File and Folder objects), it does not have full access to the interapplication communication/automation features of the OS. For that, you need to call a platform-specific script using the app.doScript method. Calling a VBScript that sends the query to the SQL database would be a good way to do what you want to do.

Thanks,

Ole

Technical Details

Message-ID: <3bc18451.6@webcrossing.la2eafNXanI>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed2.scan-plus.net!news.germany.com!news.isoc.lu!webcrossing

References: <3bc18451.-1@webcrossing.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Thread: f939a,fc46c622873f0e2e
X-Google-Attributes: gidf939a,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Olav_Kvern@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed2.scan-plus.net!news.germany.com!news.isoc.lu!webcrossing
Newsgroups: adobe.scripting.indesign
Subject: Re: Database to Indesign:  Questions
Message-ID: <3bc18451.6@webcrossing.la2eafNXanI>
Date: Mon, 11 Sep 2006 12:39:11 -0700
References: <3bc18451.-1@webcrossing.la2eafNXanI>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message