Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Executing dbidql accross machine?

2 posts in General Discussion Last posting was on 2003-08-11 13:22:03.0Z
Richard Posted on 2003-08-11 12:07:44.0Z
From: "Richard" <Richardr@ldsinc.com>
Newsgroups: ianywhere.public.general
Subject: Executing dbidql accross machine?
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: lds253.ldsinc.com
X-Original-NNTP-Posting-Host: lds253.ldsinc.com
Message-ID: <3f378710$1@forums-1-dub>
Date: 11 Aug 2003 05:07:44 -0700
X-Trace: forums-1-dub 1060603664 66.6.104.253 (11 Aug 2003 05:07:44 -0700)
X-Original-Trace: 11 Aug 2003 05:07:44 -0700, lds253.ldsinc.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1556
Article PK: 3785

I need to execute a command line from a remote machine. What is the syntax
to do it locally all I have to do is
dbisql -c "dbf=c:\data\myDatabase;uid=mpw;pwd=mpw" "c:\SQL\mySql.sql"
So I thought all I would have to do when accross machines on a machine
running a Service would be dbisql -c "dbn=MyService;uid=mpw;pwd=mpw"
"c:\SQL\mySql.sql"
What am I missing...Thanks

Richard


Reg Domaratzki Posted on 2003-08-11 13:22:03.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3f378710$1@forums-1-dub>
Subject: Re: Executing dbidql accross machine?
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3f37988f$1@forums-2-dub>
X-Original-Trace: 11 Aug 2003 06:22:23 -0700, rdomarat-pc.sybase.com
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 11 Aug 2003 06:22:03 -0700
X-Trace: forums-1-dub 1060608123 10.22.241.42 (11 Aug 2003 06:22:03 -0700)
X-Original-Trace: 11 Aug 2003 06:22:03 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1557
Article PK: 3786

What is the start line for the database engine when your service starts?
It's the name of the database server, not the service name that you'll use
to connect. For example, if your start line in the service called
"MyService" was "dbsrv8 c:\data\mydatabase.db", then your engine name would
be "mydatabase". Your connect string from another machine would be :

"eng=mydatabase;uid=mpw;pwd=mpw;links=tcpip"


--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Richard" <Richardr@ldsinc.com> wrote in message
news:3f378710$1@forums-1-dub...
> I need to execute a command line from a remote machine. What is the syntax
> to do it locally all I have to do is
> dbisql -c "dbf=c:\data\myDatabase;uid=mpw;pwd=mpw" "c:\SQL\mySql.sql"
> So I thought all I would have to do when accross machines on a machine
> running a Service would be dbisql -c "dbn=MyService;uid=mpw;pwd=mpw"
> "c:\SQL\mySql.sql"
> What am I missing...Thanks
>
> Richard
>
>