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.

How to Add a new database to existing Sybase Service

11 posts in General Discussion Last posting was on 2003-06-10 13:57:07.0Z
Richard Posted on 2003-05-28 15:27:21.0Z
From: Richard
Date: Wed, 28 May 2003 11:27:21 -0400
Newsgroups: ianywhere.public.general
Subject: How to Add a new database to existing Sybase Service
Message-ID: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1092
Article PK: 3370

I am creating a database in Script and would like to add to my script
adding to the existing sybase service...How would I achieve this?

Thanks
Richard


Reg Domaratzki Posted on 2003-05-29 13:06:37.0Z
From: "Reg Domaratzki" <rdomarat__AT__ianywhere__DOT__com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Thu, 29 May 2003 09:06:37 -0400
Lines: 23
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
Message-ID: <OKgNmOeJDHA.311@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rdomarat-pc.sybase.com 172.31.143.163
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1111
Article PK: 3040

When you say service, do you mean an NT/Win2K/XP service, or do you just
mean you have a database engine running already on which you'd like to mount
another database?

--
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> wrote in message
news:1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums...
> I am creating a database in Script and would like to add to my script
> adding to the existing sybase service...How would I achieve this?
>
> Thanks
> Richard


Richard Posted on 2003-05-29 15:42:46.0Z
From: Richard
Date: Thu, 29 May 2003 11:42:46 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Add a new database to existing Sybase Service
Message-ID: <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1115
Article PK: 3378

Yes I mean...The database engine running already on which I would like to
mount another database?

Thanks
Richard


Shuchit Velkar Posted on 2003-05-30 14:01:27.0Z
Subject: Re: How to Add a new database to existing Sybase Service
From: Shuchit Velkar <xxx@xxx.net>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums>
Message-ID: <Xns938B655A4822svelkarNOsybaseSPAMc@192.138.151.106>
User-Agent: Xnews/5.04.25
Newsgroups: ianywhere.public.general
Date: Fri, 30 May 2003 07:01:27 -0700
NNTP-Posting-Host: CPE0080c6ee7d81-CM024340006571.cpe.net.cable.rogers.com 24.101.240.132
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1125
Article PK: 3046

Richard wrote in
news:896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums:

> Yes I mean...The database engine running already on which I would like
> to mount another database?
>
> Thanks
> Richard

Look up the following topic in the online help

Adaptive Server Anywhere SQL Reference Manual
4. SQL Statements
START DATABASE statement

--
Shuchit Velkar
iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.ianywhere.com/developer


Stephen Rice Posted on 2003-05-29 18:45:23.0Z
From: "Stephen Rice" <srice_nospam@ianywhere.com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Thu, 29 May 2003 14:45:23 -0400
Lines: 24
Organization: iAnywhere Solutions
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
Message-ID: <#KJDnNhJDHA.218@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: srice-pc.sybase.com 172.31.142.125
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1119
Article PK: 3384

Use the databaseFile connection parameter when connection to the database
you want started

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums...
> Yes I mean...The database engine running already on which I would like to
> mount another database?
>
> Thanks
> Richard


Richard Posted on 2003-05-29 20:29:51.0Z
From: Richard
Date: Thu, 29 May 2003 16:29:51 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Add a new database to existing Sybase Service
Message-ID: <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1122
Article PK: 3045

Could you supply me with an example...to help me...

Thanks
Richard


Stephen Rice Posted on 2003-05-30 19:47:26.0Z
From: "Stephen Rice" <srice_nospam@ianywhere.com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub> <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Fri, 30 May 2003 15:47:26 -0400
Lines: 27
Organization: iAnywhere Solutions
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
Message-ID: <#t18PTuJDHA.280@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: srice-pc.sybase.com 172.31.142.125
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1133
Article PK: 3052

assume you have two database files; c:\temp\asademo.db and
c:\temp\another.db

dbeng8 -n waterloo c:\temp\asademo.db -n demodb

dbisql -c "uid=dba;pwd=sql;eng=waterloo;dbf=c:\temp\another.db"

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums...
> Could you supply me with an example...to help me...
>
> Thanks
> Richard


Richard Posted on 2003-06-02 17:51:22.0Z
From: Richard
Date: Mon, 2 Jun 2003 13:51:22 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to Add a new database to existing Sybase Service
Message-ID: <F680567A1437717F0062163085256D39.00750BFE85256D36@webforums>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub> <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums> <#t18PTuJDHA.280@forums-1-dub>
Lines: 11
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1144
Article PK: 3058

Thanks for the reply...I used these statements and it appears that it
creates a NEW instance of the Service and is able to create and append to
that instance. But what I need to accomplish is to use an existing service
and append to it so that when that service is call by any client that is
picks up the changes to that exisiting service. I was able to update the
Registry keys to append the existing service but I don't want to have to
mess with registry keys etc. in my Install script. Any other Ideas?


Thanks
Richard


Stephen Rice Posted on 2003-06-03 18:53:44.0Z
From: "Stephen Rice" <srice_nospam@ianywhere.com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub> <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums> <#t18PTuJDHA.280@forums-1-dub> <F680567A1437717F0062163085256D39.00750BFE85256D36@webforums>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Tue, 3 Jun 2003 14:53:44 -0400
Lines: 35
Organization: iAnywhere Solutions
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
Message-ID: <eTXL8HgKDHA.221@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.142.125
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1148
Article PK: 3395

If I'm reading what you are saying correctly you want to connect to an
arbitrary, existing engine and start a database on it?

You would then need to combine dblocate() to find any existing servers and
then attempt to make the connection. This is fairly sophisticated code and
it leads me to wonder what business problem you are trying to solve?

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Richard> wrote in message
news:F680567A1437717F0062163085256D39.00750BFE85256D36@webforums...
> Thanks for the reply...I used these statements and it appears that it
> creates a NEW instance of the Service and is able to create and append to
> that instance. But what I need to accomplish is to use an existing
service
> and append to it so that when that service is call by any client that is
> picks up the changes to that exisiting service. I was able to update the
> Registry keys to append the existing service but I don't want to have to
> mess with registry keys etc. in my Install script. Any other Ideas?
>
>
> Thanks
> Richard


Richard Posted on 2003-06-05 20:04:28.0Z
From: "Richard" <Richardr@ldsinc.com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub> <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums> <#t18PTuJDHA.280@forums-1-dub> <F680567A1437717F0062163085256D39.00750BFE85256D36@webforums> <eTXL8HgKDHA.221@forums-1-dub>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Thu, 5 Jun 2003 15:04:28 -0500
Lines: 63
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
Message-ID: <u9MY245KDHA.220@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: lds253.ldsinc.com 66.6.104.253
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1167
Article PK: 3412

Steve,

> If I'm reading what you are saying correctly you want to connect to an
> arbitrary, existing engine and start a database on it?

I actually want to Add perminantly to the Service only if it doesn't
exist...

What we are trying to accomplish is to combine this logic with an install
script for our customers so they don't have to spawn ISQL and run scripts.
manually. All they have to do is supply us with where and names of
DB/Services ect. then we can go out and Create new databases/tables/Stored
Procs Load Data and attach to exsiting Database Services ect....and yes It
is going to be a little more work but ... for own customers they only have
to answer a few questions and push a few buttons.

Thanks for your help
Richard


"Stephen Rice" <srice_nospam@ianywhere.com> wrote in message
news:eTXL8HgKDHA.221@forums-1-dub...
> If I'm reading what you are saying correctly you want to connect to an
> arbitrary, existing engine and start a database on it?
>
> You would then need to combine dblocate() to find any existing servers and
> then attempt to make the connection. This is fairly sophisticated code
and
> it leads me to wonder what business problem you are trying to solve?
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
>
> <Richard> wrote in message
> news:F680567A1437717F0062163085256D39.00750BFE85256D36@webforums...
> > Thanks for the reply...I used these statements and it appears that it
> > creates a NEW instance of the Service and is able to create and append
to
> > that instance. But what I need to accomplish is to use an existing
> service
> > and append to it so that when that service is call by any client that is
> > picks up the changes to that exisiting service. I was able to update
the
> > Registry keys to append the existing service but I don't want to have to
> > mess with registry keys etc. in my Install script. Any other Ideas?
> >
> >
> > Thanks
> > Richard
>
>


Stephen Rice Posted on 2003-06-10 13:57:07.0Z
From: "Stephen Rice" <srice_nospam@ianywhere.com>
References: <1E59784E67124FE70054E70585256D34.0054E71385256D34@webforums> <OKgNmOeJDHA.311@forums-1-dub> <896DB79B0DE81EF60056501985256D35.004F541085256D35@webforums> <#KJDnNhJDHA.218@forums-2-dub> <F37B925AC25561800070988885256D35.006BFC1E85256D35@webforums> <#t18PTuJDHA.280@forums-1-dub> <F680567A1437717F0062163085256D39.00750BFE85256D36@webforums> <eTXL8HgKDHA.221@forums-1-dub> <u9MY245KDHA.220@forums-1-dub>
Subject: Re: How to Add a new database to existing Sybase Service
Date: Tue, 10 Jun 2003 09:57:07 -0400
Lines: 91
Organization: iAnywhere Solutions
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
Message-ID: <O8Lwtk1LDHA.339@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: srice-pc.sybase.com 172.31.142.125
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1189
Article PK: 3430

Pretty ambitious but should be doable!

You are going to need to spend allot of time with db_locate(), connect
strings and the Microsoft service manager api to get it to work. Its
certainly beyond anything I personally have tried so I'm not going to be
much more help. I do believe you have all of the SQL Anywhere pieces now
you just need to spend some time with them to become comfortable with what
you have learned.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Richard" <Richardr@ldsinc.com> wrote in message
news:u9MY245KDHA.220@forums-1-dub...
>
> Steve,
>
> > If I'm reading what you are saying correctly you want to connect to an
> > arbitrary, existing engine and start a database on it?
> I actually want to Add perminantly to the Service only if it doesn't
> exist...
>
> What we are trying to accomplish is to combine this logic with an install
> script for our customers so they don't have to spawn ISQL and run scripts.
> manually. All they have to do is supply us with where and names of
> DB/Services ect. then we can go out and Create new databases/tables/Stored
> Procs Load Data and attach to exsiting Database Services ect....and yes It
> is going to be a little more work but ... for own customers they only have
> to answer a few questions and push a few buttons.
>
> Thanks for your help
> Richard
>
>
> "Stephen Rice" <srice_nospam@ianywhere.com> wrote in message
> news:eTXL8HgKDHA.221@forums-1-dub...
> > If I'm reading what you are saying correctly you want to connect to an
> > arbitrary, existing engine and start a database on it?
> >
> > You would then need to combine dblocate() to find any existing servers
and
> > then attempt to make the connection. This is fairly sophisticated code
> and
> > it leads me to wonder what business problem you are trying to solve?
> >
> > /steve
> >
> > --
> > Stephen Rice
> > Technical Services Manager
> > iAnywhere Solutions
> >
> > - Please Post-
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> >
> > <Richard> wrote in message
> > news:F680567A1437717F0062163085256D39.00750BFE85256D36@webforums...
> > > Thanks for the reply...I used these statements and it appears that it
> > > creates a NEW instance of the Service and is able to create and append
> to
> > > that instance. But what I need to accomplish is to use an existing
> > service
> > > and append to it so that when that service is call by any client that
is
> > > picks up the changes to that exisiting service. I was able to update
> the
> > > Registry keys to append the existing service but I don't want to have
to
> > > mess with registry keys etc. in my Install script. Any other Ideas?
> > >
> > >
> > > Thanks
> > > Richard
> >
> >
>
>