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.

ODBC Connection

13 posts in General Discussion Last posting was on 2005-04-23 03:32:23.0Z
Geoffrey Chambers Posted on 2005-04-18 14:48:36.0Z
Sender: 1abb.4263c83b.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: ODBC Connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4263c8bf.1ac3.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 18 Apr 2005 07:48:31 -0800, 10.22.241.42
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Apr 2005 07:48:33 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Apr 2005 07:48:36 -0700
X-Trace: forums-1-dub 1113835716 10.22.108.75 (18 Apr 2005 07:48:36 -0700)
X-Original-Trace: 18 Apr 2005 07:48:36 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4357
Article PK: 8173

I established a remote connection using mstsc.exe. On the
remote
computer I have an application that I wrote that accesses
Sybase SQL Anywhere. The problem is, it will only let one
person access the database. How can I change this so
multiple users can access the database.


Reg Domaratzki (iAnywhere Solutions) Posted on 2005-04-18 15:19:27.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4263c8bf.1ac3.1681692777@sybase.com>
Subject: Re: ODBC Connection
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <4263cfff$1@forums-1-dub>
Date: 18 Apr 2005 08:19:27 -0700
X-Trace: forums-1-dub 1113837567 10.25.99.235 (18 Apr 2005 08:19:27 -0700)
X-Original-Trace: 18 Apr 2005 08:19:27 -0700, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4358
Article PK: 8171

Can you please define what you mean by remote connection?
What is the connection string you use to connect to the 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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Geoffrey Chambers> wrote in message
news:4263c8bf.1ac3.1681692777@sybase.com...
> I established a remote connection using mstsc.exe. On the
> remote
> computer I have an application that I wrote that accesses
> Sybase SQL Anywhere. The problem is, it will only let one
> person access the database. How can I change this so
> multiple users can access the database.


Geoff Chambers Posted on 2005-04-19 14:47:13.0Z
Sender: 1abb.4263c83b.1804289383@sybase.com
From: Geoff Chambers
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <426519ee.2b7a.1681692777@sybase.com>
References: <4263cfff$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 19 Apr 2005 07:47:10 -0800, 10.22.241.42
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Apr 2005 07:47:11 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Apr 2005 07:47:13 -0700
X-Trace: forums-1-dub 1113922033 10.22.108.75 (19 Apr 2005 07:47:13 -0700)
X-Original-Trace: 19 Apr 2005 07:47:13 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4366
Article PK: 8180

I run remote desktop (mstsc.exe) which allows me to run the
application on the remote computer. It is only a single user
license, will upgrading to a multiuser license correct this?

> Can you please define what you mean by remote connection?
> What is the connection string you use to connect to the
> 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 iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <Geoffrey Chambers> wrote in message
> news:4263c8bf.1ac3.1681692777@sybase.com...
> > I established a remote connection using mstsc.exe. On
> > the remote
> > computer I have an application that I wrote that
> > accesses Sybase SQL Anywhere. The problem is, it will
> > only let one person access the database. How can I
> > change this so multiple users can access the database.
>
>


Reg Domaratzki (iAnywhere Solutions) Posted on 2005-04-19 15:03:43.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4263cfff$1@forums-1-dub> <426519ee.2b7a.1681692777@sybase.com>
Subject: Re: ODBC Connection
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <42651dc6$1@forums-2-dub>
X-Original-Trace: 19 Apr 2005 08:03:34 -0800, rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Apr 2005 08:03:36 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Apr 2005 08:03:43 -0700
X-Trace: forums-1-dub 1113923023 10.22.108.75 (19 Apr 2005 08:03:43 -0700)
X-Original-Trace: 19 Apr 2005 08:03:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4368
Article PK: 8181

You haven't answered the most important questions, which is how you are
starting the database engine, which engine you are using (dbeng or dbsrv)
and what your connection string is. There's no way to say that a
single-user versus 5-user license will fix this problem without knowing this
information.


--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Geoff Chambers> wrote in message
news:426519ee.2b7a.1681692777@sybase.com...
> I run remote desktop (mstsc.exe) which allows me to run the
> application on the remote computer. It is only a single user
> license, will upgrading to a multiuser license correct this?
>
> > Can you please define what you mean by remote connection?
> > What is the connection string you use to connect to the
> > 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 iAnywhere Documentation
> > : http://www.ianywhere.com/developer/product_manuals ASA
> > Patches and EBFs :
> > http://downloads.sybase.com/swx/sdmain.stm
> > -> Choose SQL Anywhere Studio
> > -> Set "Platform Preview" and "Time Frame" to ALL
> >
> > <Geoffrey Chambers> wrote in message
> > news:4263c8bf.1ac3.1681692777@sybase.com...
> > > I established a remote connection using mstsc.exe. On
> > > the remote
> > > computer I have an application that I wrote that
> > > accesses Sybase SQL Anywhere. The problem is, it will
> > > only let one person access the database. How can I
> > > change this so multiple users can access the database.
> >
> >


Chris Keating (iAnywhere Solutions) Posted on 2005-04-18 16:07:55.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4263c8bf.1ac3.1681692777@sybase.com>
Subject: Re: ODBC Connection
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-concord-173.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-173.sybase.com
Message-ID: <4263db5b$1@forums-1-dub>
Date: 18 Apr 2005 09:07:55 -0700
X-Trace: forums-1-dub 1113840475 158.159.8.173 (18 Apr 2005 09:07:55 -0700)
X-Original-Trace: 18 Apr 2005 09:07:55 -0700, vpn-concord-173.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4359
Article PK: 8174

Are you running a network server (DBSRVx.EXE where x is the version of SQL
Anywhere) with appropriate licencing to allow for multiuser access.. If not,
the engine being used is a single user engine and as such only person should
be able to use the engine. BTW I will take a guess that you are trying to
start the database file but it is already in use.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

*****************************************************************************

<Geoffrey Chambers> wrote in message
news:4263c8bf.1ac3.1681692777@sybase.com...
>I established a remote connection using mstsc.exe. On the
> remote
> computer I have an application that I wrote that accesses
> Sybase SQL Anywhere. The problem is, it will only let one
> person access the database. How can I change this so
> multiple users can access the database.


Geoffrey Chambers Posted on 2005-04-19 14:41:15.0Z
Sender: 1abb.4263c83b.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42651886.2b5c.1681692777@sybase.com>
References: <4263db5b$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 19 Apr 2005 07:41:10 -0800, 10.22.241.42
Lines: 54
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Apr 2005 07:41:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Apr 2005 07:41:15 -0700
X-Trace: forums-1-dub 1113921675 10.22.108.75 (19 Apr 2005 07:41:15 -0700)
X-Original-Trace: 19 Apr 2005 07:41:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4364
Article PK: 8177

Yes it is a single user license, is that the only problem,
If I get a 5 user license this will correct it? I also am
accessing the computer remotely using mstsc.exe, which
basically allows me to run the program from my laptop on the
remote machine. I would really like to run the application
on my computer and access the database from a network. My
only concern would be how slow this may be.

> Are you running a network server (DBSRVx.EXE where x is
> the version of SQL Anywhere) with appropriate licencing
> to allow for multiuser access.. If not, the engine being
> used is a single user engine and as such only person
> should be able to use the engine. BTW I will take a guess
> that you are trying to start the database file but it is
> already in use.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> **********************************************************
> ******************* Sign up today for your copy of the SQL
> Anywhere Studio 9 Developer Edition and try out the
> market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> **********************************************************
> *******************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at
> http://www.iAnywhere.com/developer ** EBFs can be found at
> http://downloads.sybase.com/swx/sdmain.stm ** Use
> CaseXpress to report bugs http://casexpress.sybase.com
>
> **********************************************************
> *******************
>
> <Geoffrey Chambers> wrote in message
> news:4263c8bf.1ac3.1681692777@sybase.com...
> >I established a remote connection using mstsc.exe. On the
> > remote
> > computer I have an application that I wrote that
> > accesses Sybase SQL Anywhere. The problem is, it will
> > only let one person access the database. How can I
> > change this so multiple users can access the database.
>
>


Reg Domaratzki (iAnywhere Solutions) Posted on 2005-04-19 14:45:33.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4263db5b$1@forums-1-dub> <42651886.2b5c.1681692777@sybase.com>
Subject: Re: ODBC Connection
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <4265198d$1@forums-1-dub>
Date: 19 Apr 2005 07:45:33 -0700
X-Trace: forums-1-dub 1113921933 10.25.99.235 (19 Apr 2005 07:45:33 -0700)
X-Original-Trace: 19 Apr 2005 07:45:33 -0700, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4365
Article PK: 8178

You haven't answered the most important questions, which is how you are
starting the database engine, which engine you are using (dbeng or dbsrv)
and what your connection string is. There's no way to say that a
single-user versus 5-user license will fix this problem without knowing this
information.

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Geoffrey Chambers> wrote in message
news:42651886.2b5c.1681692777@sybase.com...
> Yes it is a single user license, is that the only problem,
> If I get a 5 user license this will correct it? I also am
> accessing the computer remotely using mstsc.exe, which
> basically allows me to run the program from my laptop on the
> remote machine. I would really like to run the application
> on my computer and access the database from a network. My
> only concern would be how slow this may be.
>
> > Are you running a network server (DBSRVx.EXE where x is
> > the version of SQL Anywhere) with appropriate licencing
> > to allow for multiuser access.. If not, the engine being
> > used is a single user engine and as such only person
> > should be able to use the engine. BTW I will take a guess
> > that you are trying to start the database file but it is
> > already in use.
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> > **********************************************************
> > ******************* Sign up today for your copy of the SQL
> > Anywhere Studio 9 Developer Edition and try out the
> > market-leading database for mobile, embedded and small to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> > **********************************************************
> > *******************
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at
> > http://www.iAnywhere.com/developer ** EBFs can be found at
> > http://downloads.sybase.com/swx/sdmain.stm ** Use
> > CaseXpress to report bugs http://casexpress.sybase.com
> >
> > **********************************************************
> > *******************
> >
> > <Geoffrey Chambers> wrote in message
> > news:4263c8bf.1ac3.1681692777@sybase.com...
> > >I established a remote connection using mstsc.exe. On the
> > > remote
> > > computer I have an application that I wrote that
> > > accesses Sybase SQL Anywhere. The problem is, it will
> > > only let one person access the database. How can I
> > > change this so multiple users can access the database.
> >
> >


Geoffrey Chambers Posted on 2005-04-19 18:10:19.0Z
Sender: 648f.42651df9.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4265498b.6803.1681692777@sybase.com>
References: <4265198d$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Apr 2005 11:10:19 -0700
X-Trace: forums-1-dub 1113934219 10.22.241.41 (19 Apr 2005 11:10:19 -0700)
X-Original-Trace: 19 Apr 2005 11:10:19 -0700, 10.22.241.41
Lines: 87
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4372
Article PK: 8187

I'm not sure, how do I make sure dbsrv9 is being used? I
created an ODBC connection and access this connection within
my application, passing the odbc connection name, userid,
password.

> You haven't answered the most important questions, which
> is how you are starting the database engine, which engine
> you are using (dbeng or dbsrv) and what your connection
> string is. There's no way to say that a single-user
> versus 5-user license will fix this problem without
> knowing this information.
>
> --
> 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 iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <Geoffrey Chambers> wrote in message
> news:42651886.2b5c.1681692777@sybase.com...
> > Yes it is a single user license, is that the only
> > problem, If I get a 5 user license this will correct it?
> > I also am accessing the computer remotely using
> > mstsc.exe, which basically allows me to run the program
> > from my laptop on the remote machine. I would really
> > like to run the application on my computer and access
> > the database from a network. My only concern would be
> how slow this may be. >
> > > Are you running a network server (DBSRVx.EXE where x
> > > is the version of SQL Anywhere) with appropriate
> > > licencing to allow for multiuser access.. If not, the
> > > engine being used is a single user engine and as such
> > > only person should be able to use the engine. BTW I
> > > will take a guess that you are trying to start the
> > > database file but it is already in use.
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > >
> > >
> > >
> **********************************************************
> > > ******************* Sign up today for your copy of the
> > > SQL Anywhere Studio 9 Developer Edition and try out
> the market-leading database for mobile, embedded and small
> > > to medium sized business environments for free!
> > >
> > > http://www.ianywhere.com/promos/deved/index.html
> > >
> > >
> > >
> **********************************************************
> > ******************* >
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at
> > > http://www.iAnywhere.com/developer ** EBFs can be
> > > found at http://downloads.sybase.com/swx/sdmain.stm **
> > > Use CaseXpress to report bugs
> > http://casexpress.sybase.com >
> > >
> > >
> **********************************************************
> > ******************* >
> > > <Geoffrey Chambers> wrote in message
> > > news:4263c8bf.1ac3.1681692777@sybase.com...
> > > >I established a remote connection using mstsc.exe. On
> > > > the remote
> > > > computer I have an application that I wrote that
> > > > accesses Sybase SQL Anywhere. The problem is, it
> > > > will only let one person access the database. How
> > > > can I change this so multiple users can access the
> > database. >
> > >
>
>


Greg Fenton Posted on 2005-04-19 18:27:01.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Connection
References: <4265198d$1@forums-1-dub> <4265498b.6803.1681692777@sybase.com>
In-Reply-To: <4265498b.6803.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66-194-200-22.gen.twtelecom.net
X-Original-NNTP-Posting-Host: 66-194-200-22.gen.twtelecom.net
Message-ID: <42654d75@forums-1-dub>
Date: 19 Apr 2005 11:27:01 -0700
X-Trace: forums-1-dub 1113935221 66.194.200.22 (19 Apr 2005 11:27:01 -0700)
X-Original-Trace: 19 Apr 2005 11:27:01 -0700, 66-194-200-22.gen.twtelecom.net
Lines: 22
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4374
Article PK: 8188


Geoffrey Chambers wrote:
> I'm not sure, how do I make sure dbsrv9 is being used? I
> created an ODBC connection and access this connection within
> my application, passing the odbc connection name, userid,
> password.
>
>

Use the dbdsn command-line utility and post its output:

dbdsn -gu MY_USER_DSN
or
dbdsn -gs MY_SYSTEM_DSN

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Geoffrey Chambers Posted on 2005-04-20 15:07:00.0Z
Sender: 2e60.42654d8a.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42667010.3ba1.1681692777@sybase.com>
References: <42654d75@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 20 Apr 2005 08:06:56 -0800, 10.22.241.42
Lines: 33
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Apr 2005 08:06:57 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Apr 2005 08:07:00 -0700
X-Trace: forums-1-dub 1114009620 10.22.108.75 (20 Apr 2005 08:07:00 -0700)
X-Original-Trace: 20 Apr 2005 08:07:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4377
Article PK: 8194

I added this to my Odbc connection in the start line

C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe -c
8m

But it still only allows one user, Do I need a multi user
version of SQL Anywhere? I am only just testing the
application at this time.

> Geoffrey Chambers wrote:
> > I'm not sure, how do I make sure dbsrv9 is being used? I
> > created an ODBC connection and access this connection
> > within my application, passing the odbc connection name,
> > userid, password.
> >
> >
>
> Use the dbdsn command-line utility and post its output:
>
> dbdsn -gu MY_USER_DSN
> or
> dbdsn -gs MY_SYSTEM_DSN
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Chris Keating (iAnywhere Solutions) Posted on 2005-04-20 15:55:14.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42654d75@forums-1-dub> <42667010.3ba1.1681692777@sybase.com>
Subject: Re: ODBC Connection
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42667b62@forums-1-dub>
Date: 20 Apr 2005 08:55:14 -0700
X-Trace: forums-1-dub 1114012514 10.25.98.199 (20 Apr 2005 08:55:14 -0700)
X-Original-Trace: 20 Apr 2005 08:55:14 -0700, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4380
Article PK: 8198

We are going around in circles a bit here.Generally, you start the network
server outside the context of the connection. As such, you would only
provide information that points the connection to the running engine. In a
Terminal Server environment, the network server is started on the terminal
server. When a TS client is established, it then connects using TCP/IP to
the running network server. Generally, the network server is setup as a
service to ensure that gets started when the machine is started.


Also, do you have sufficient licensing for this network server? If you are
licensed a single user, you will only be able to connect a single user.

What error do you get when the connection fails?

<Geoffrey Chambers> wrote in message
news:42667010.3ba1.1681692777@sybase.com...
>I added this to my Odbc connection in the start line
>
> C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe -c
> 8m
>
> But it still only allows one user, Do I need a multi user
> version of SQL Anywhere? I am only just testing the
> application at this time.
>
>
>
>> Geoffrey Chambers wrote:
>> > I'm not sure, how do I make sure dbsrv9 is being used? I
>> > created an ODBC connection and access this connection
>> > within my application, passing the odbc connection name,
>> > userid, password.
>> >
>> >
>>
>> Use the dbdsn command-line utility and post its output:
>>
>> dbdsn -gu MY_USER_DSN
>> or
>> dbdsn -gs MY_SYSTEM_DSN
>>
>> greg.fenton
>> --
>> Greg Fenton
>> Consultant, Solution Services, iAnywhere Solutions
>> --------
>> Visit the iAnywhere Solutions Developer Community
>> Whitepapers, TechDocs, Downloads
>> http://www.ianywhere.com/developer/