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.

Sybase Central and DSNs

9 posts in General Discussion Last posting was on 2003-06-27 12:15:31.0Z
David I. Bell Posted on 2003-06-25 18:31:04.0Z
From: "David I. Bell" <David_I_Bell@intuit.com>
Subject: Sybase Central and DSNs
Date: Wed, 25 Jun 2003 11:31:04 -0700
Lines: 234
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#TRYM10ODHA.187@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: niner.intuit.com 216.52.25.129
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1252
Article PK: 3497

Kind Readers,

This may be a naive question... but here it is:

It seems as if one must have a DB server running before one can use a DSN.
Is this true? I have a DSN (user DSN) that has the checkbox "Automatically
start the database if it isn't running" checked on the database tab. I have
a correct pathname to the executable in the "Start Line" text box
(C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe) and I have an
engine name in the "Server Name" text box. and yet, when I try to connect I
get the attached error dialog which complains that I don't have a Server
Name in the configuration.

If I manually start the DB engine and then try to use the DSN, it works
fine.

Obviously, I don't expect a remote server to start up, but I don't
understand why a local server isn't started. Can someone please explain?

Thanks in advance.

-- David

connect_error.gif

Breck Carter [TeamSybase] Posted on 2003-06-25 19:43:17.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Subject: Re: Sybase Central and DSNs
Date: Wed, 25 Jun 2003 15:43:17 -0400
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com>
References: <#TRYM10ODHA.187@forums-2-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nnc010.canpar.ca 204.225.91.186
Lines: 48
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1253
Article PK: 3496

Here is a test that was successful using 8.0.2.4122...

ODBC Administrator
ODBC tab
Data source name: testdb
Login tab
DBA, SQL
Database tab
Server name: <empty>
Start line: <empty>
Database name: <empty>
Database file: C:\amisc\experiments\testdb\test.db
Automatically start...: <checked>
Automatically shut down...: <checked>
ODBC tab
Test Connection button worked OK

Sybase Central
Connection Profile
New Profile
Name: testdb
Identification tab
ODBC Data Source Name: testdb

Nothing else was filled in, and it worked OK to start the engine and
database. The Start line seems to be unnecessary, the ASA ODBC driver
seems able to figure things out :)

Breck

On Wed, 25 Jun 2003 11:31:04 -0700, "David I. Bell"

<David_I_Bell@intuit.com> wrote:

>Kind Readers,
>
>This may be a naive question... but here it is:
>
>It seems as if one must have a DB server running before one can use a DSN.
>Is this true? I have a DSN (user DSN) that has the checkbox "Automatically
>start the database if it isn't running" checked on the database tab. I have
>a correct pathname to the executable in the "Start Line" text box
>(C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe) and I have an
>engine name in the "Server Name" text box. and yet, when I try to connect I
>get the attached error dialog which complains that I don't have a Server
>Name in the configuration.
>
>If I manually start the DB engine and then try to use the DSN, it works
>fine.
>
>Obviously, I don't expect a remote server to start up, but I don't
>understand why a local server isn't started. Can someone please explain?
>
>Thanks in advance.
>
>-- David
>
>
>
>
>
>
>
>
>
>

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


David I. Bell Posted on 2003-06-25 20:48:31.0Z
From: "David I. Bell" <David_I_Bell@intuit.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com>
Subject: Re: Sybase Central and DSNs
Date: Wed, 25 Jun 2003 13:48:31 -0700
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#zzbcA2ODHA.362@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: niner.intuit.com 216.52.25.129
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1254
Article PK: 3498

Just tried that. "Test Connection" works. I see the SQL server logo show
up (briefly) in my system tray, then disappaer.

But... when I try to connect, from Sybase Central, it fails with the same
error mesasge as before.

Sybase Central 4.1.1.1370
ASA 8.0.2.3601

By the way, how do affect the server page size when starting things up this
way?

"Breck Carter [TeamSybase]"

> Here is a test that was successful using 8.0.2.4122...
>
> ODBC Administrator
> ODBC tab
> Data source name: testdb
> Login tab
> DBA, SQL
> Database tab
> Server name: <empty>
> Start line: <empty>
> Database name: <empty>
> Database file: C:\amisc\experiments\testdb\test.db
> Automatically start...: <checked>
> Automatically shut down...: <checked>
> ODBC tab
> Test Connection button worked OK
>
> Sybase Central
> Connection Profile
> New Profile
> Name: testdb
> Identification tab
> ODBC Data Source Name: testdb
>
> Nothing else was filled in, and it worked OK to start the engine and
> database. The Start line seems to be unnecessary, the ASA ODBC driver
> seems able to figure things out :)
>
> Breck
>
> On Wed, 25 Jun 2003 11:31:04 -0700, "David I. Bell"
> <David_I_Bell@intuit.com> wrote:
>
> >Kind Readers,
> >
> >This may be a naive question... but here it is:
> >
> >It seems as if one must have a DB server running before one can use a
DSN.
> >Is this true? I have a DSN (user DSN) that has the checkbox
"Automatically
> >start the database if it isn't running" checked on the database tab. I
have
> >a correct pathname to the executable in the "Start Line" text box
> >(C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe) and I have an
> >engine name in the "Server Name" text box. and yet, when I try to connect
I
> >get the attached error dialog which complains that I don't have a Server
> >Name in the configuration.
> >
> >If I manually start the DB engine and then try to use the DSN, it works
> >fine.
> >
> >Obviously, I don't expect a remote server to start up, but I don't
> >understand why a local server isn't started. Can someone please explain?
> >
> >Thanks in advance.
> >
> >-- David
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> http://www.risingroad.com


Chris Keating Posted on 2003-06-26 03:13:01.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Wed, 25 Jun 2003 23:13:01 -0400
Lines: 103
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <#PUQuH5ODHA.187@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: CPE00045af8ce8c-CM012059936305.cpe.net.cable.rogers.com 24.100.33.132
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1255
Article PK: 3500

Sybase Central parses the information in the DSN and builds a connection
string. IN does not necessarily use the DSN. Try switching the setting of
the checkbox "Search network for database servers" on the database tab of
connection dialog. What happens? What value did it have previously?

/ck

"David I. Bell" <David_I_Bell@intuit.com> wrote in message
news:#zzbcA2ODHA.362@forums-2-dub...
> Just tried that. "Test Connection" works. I see the SQL server logo show
> up (briefly) in my system tray, then disappaer.
>
> But... when I try to connect, from Sybase Central, it fails with the same
> error mesasge as before.
>
> Sybase Central 4.1.1.1370
> ASA 8.0.2.3601
>
> By the way, how do affect the server page size when starting things up
this
> way?
>
> "Breck Carter [TeamSybase]"
> > Here is a test that was successful using 8.0.2.4122...
> >
> > ODBC Administrator
> > ODBC tab
> > Data source name: testdb
> > Login tab
> > DBA, SQL
> > Database tab
> > Server name: <empty>
> > Start line: <empty>
> > Database name: <empty>
> > Database file: C:\amisc\experiments\testdb\test.db
> > Automatically start...: <checked>
> > Automatically shut down...: <checked>
> > ODBC tab
> > Test Connection button worked OK
> >
> > Sybase Central
> > Connection Profile
> > New Profile
> > Name: testdb
> > Identification tab
> > ODBC Data Source Name: testdb
> >
> > Nothing else was filled in, and it worked OK to start the engine and
> > database. The Start line seems to be unnecessary, the ASA ODBC driver
> > seems able to figure things out :)
> >
> > Breck
> >
> > On Wed, 25 Jun 2003 11:31:04 -0700, "David I. Bell"
> > <David_I_Bell@intuit.com> wrote:
> >
> > >Kind Readers,
> > >
> > >This may be a naive question... but here it is:
> > >
> > >It seems as if one must have a DB server running before one can use a
> DSN.
> > >Is this true? I have a DSN (user DSN) that has the checkbox
> "Automatically
> > >start the database if it isn't running" checked on the database tab. I
> have
> > >a correct pathname to the executable in the "Start Line" text box
> > >(C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe) and I have an
> > >engine name in the "Server Name" text box. and yet, when I try to
connect
> I
> > >get the attached error dialog which complains that I don't have a
Server
> > >Name in the configuration.
> > >
> > >If I manually start the DB engine and then try to use the DSN, it works
> > >fine.
> > >
> > >Obviously, I don't expect a remote server to start up, but I don't
> > >understand why a local server isn't started. Can someone please
explain?
> > >
> > >Thanks in advance.
> > >
> > >-- David
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> > bcarter@risingroad.com
> > Mobile and Distributed Enterprise Database Applications
> > http://www.risingroad.com
>
>


David I. Bell Posted on 2003-06-26 17:41:56.0Z
From: "David I. Bell" <David_I_Bell@intuit.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub> <#PUQuH5ODHA.187@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Thu, 26 Jun 2003 10:41:56 -0700
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <eym#gtAPDHA.218@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: niner.intuit.com 216.52.25.129
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1256
Article PK: 3499

Problem solved... Thanks.

The details:
* Unchecked "Search network for database servers"
* Make sure the "Start line:" field has proper path name dbeng8.exe (or
dbsrv8.exe) and a -n flag for the server engine name
* Make sure the "Server name:" has the same name as the -n flag in the
Server line field.

Then everything works as expected.

"Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
news:#PUQuH5ODHA.187@forums-2-dub...
> Sybase Central parses the information in the DSN and builds a connection
> string. IN does not necessarily use the DSN. Try switching the setting of
> the checkbox "Search network for database servers" on the database tab of
> connection dialog. What happens? What value did it have previously?
>
> /ck


Graeme Perrow Posted on 2003-06-26 18:05:59.0Z
From: "Graeme Perrow" <gperrowNO@SPAMianywhere.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub> <#PUQuH5ODHA.187@forums-2-dub> <eym#gtAPDHA.218@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Thu, 26 Jun 2003 14:05:59 -0400
Lines: 43
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: <egRx6HBPDHA.301@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gperrow-pc.sybase.com 172.31.143.147
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1257
Article PK: 3501

You shouldn't need to (and shouldn't) put the -n switch in the start line.
If you remove the -n flag from the start line, we should use the server name
in the "Server Name" field to name the server. Can you provide a
reproducible case where the -n in the start line is required?

--
Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

"David I. Bell" <David_I_Bell@intuit.com> wrote in message
news:eym%23gtAPDHA.218@forums-2-dub...
> Problem solved... Thanks.
>
> The details:
> * Unchecked "Search network for database servers"
> * Make sure the "Start line:" field has proper path name dbeng8.exe (or
> dbsrv8.exe) and a -n flag for the server engine name
> * Make sure the "Server name:" has the same name as the -n flag in the
> Server line field.
>
> Then everything works as expected.
>
> "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> news:#PUQuH5ODHA.187@forums-2-dub...
> > Sybase Central parses the information in the DSN and builds a connection
> > string. IN does not necessarily use the DSN. Try switching the setting
of
> > the checkbox "Search network for database servers" on the database tab
of
> > connection dialog. What happens? What value did it have previously?
> >
> > /ck
>
>


Graeme Perrow Posted on 2003-06-26 18:29:37.0Z
From: "Graeme Perrow" <gperrowNO@SPAMianywhere.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub> <#PUQuH5ODHA.187@forums-2-dub> <eym#gtAPDHA.218@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Thu, 26 Jun 2003 14:29:37 -0400
Lines: 44
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: <umm86HBPDHA.301@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gperrow-pc.sybase.com 172.31.143.147
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1258
Article PK: 3502

You shouldn't need to (and shouldn't) put the -n switch in the start line.
If you remove the -n flag from the start line, we should use the server name
in the "Server Name" field to name the server. Can you provide a
reproducible case where the -n in the start line is required?

--
Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

"David I. Bell" <David_I_Bell@intuit.com> wrote in message
news:eym%23gtAPDHA.218@forums-2-dub...
> Problem solved... Thanks.
>
> The details:
> * Unchecked "Search network for database servers"
> * Make sure the "Start line:" field has proper path name dbeng8.exe (or
> dbsrv8.exe) and a -n flag for the server engine name
> * Make sure the "Server name:" has the same name as the -n flag in the
> Server line field.
>
> Then everything works as expected.
>
> "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> news:#PUQuH5ODHA.187@forums-2-dub...
> > Sybase Central parses the information in the DSN and builds a connection
> > string. IN does not necessarily use the DSN. Try switching the setting
of
> > the checkbox "Search network for database servers" on the database tab
of
> > connection dialog. What happens? What value did it have previously?
> >
> > /ck
>
>


David I. Bell Posted on 2003-06-26 23:10:08.0Z
From: "David I. Bell" <David_I_Bell@intuit.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub> <#PUQuH5ODHA.187@forums-2-dub> <eym#gtAPDHA.218@forums-2-dub> <umm86HBPDHA.301@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Thu, 26 Jun 2003 16:10:08 -0700
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <eBi7qkDPDHA.185@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: niner.intuit.com 216.52.25.129
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1260
Article PK: 3504

Hi Graeme,

Hmmm, thought I tried that before (i.e. no -n option, only a "Server name:")
and had trouble. Of course, your message sent me back to try to verfiy my
initial experiments. Indeed, it works as you describe it. I do not need
a -n option on the "Start line:".

Thanks.

-- David

"Graeme Perrow" <gperrowNO@SPAMianywhere.com> wrote in message
news:umm86HBPDHA.301@forums-2-dub...
>
> You shouldn't need to (and shouldn't) put the -n switch in the start line.
> If you remove the -n flag from the start line, we should use the server
name
> in the "Server Name" field to name the server. Can you provide a
> reproducible case where the -n in the start line is required?
>
> --
> Graeme Perrow
> Senior Software Developer
> gperrow@ianywhere.com
> iAnywhere Solutions Inc.
> A Sybase company
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer/
>
> "David I. Bell" <David_I_Bell@intuit.com> wrote in message
> news:eym%23gtAPDHA.218@forums-2-dub...
> > Problem solved... Thanks.
> >
> > The details:
> > * Unchecked "Search network for database servers"
> > * Make sure the "Start line:" field has proper path name dbeng8.exe (or
> > dbsrv8.exe) and a -n flag for the server engine name
> > * Make sure the "Server name:" has the same name as the -n flag in the
> > Server line field.
> >
> > Then everything works as expected.


Chris Keating Posted on 2003-06-27 12:15:31.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <#TRYM10ODHA.187@forums-2-dub> <o7ujfvoqfibfk3oa9k31fkea6ureousmeb@4ax.com> <#zzbcA2ODHA.362@forums-2-dub> <#PUQuH5ODHA.187@forums-2-dub> <eym#gtAPDHA.218@forums-2-dub>
Subject: Re: Sybase Central and DSNs
Date: Fri, 27 Jun 2003 08:15:31 -0400
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <#GpckbKPDHA.305@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: CPE00045af8ce8c-CM012059936305.cpe.net.cable.rogers.com 24.100.33.132
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1261
Article PK: 3505

If "Search network for database servers" is checked, the connection will
look for existing servers that are running and won't attempt to start an
engine.

/ck

"David I. Bell" <David_I_Bell@intuit.com> wrote in message
news:eym#gtAPDHA.218@forums-2-dub...
> Problem solved... Thanks.
>
> The details:
> * Unchecked "Search network for database servers"
> * Make sure the "Start line:" field has proper path name dbeng8.exe (or
> dbsrv8.exe) and a -n flag for the server engine name
> * Make sure the "Server name:" has the same name as the -n flag in the
> Server line field.
>
> Then everything works as expected.
>
> "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> news:#PUQuH5ODHA.187@forums-2-dub...
> > Sybase Central parses the information in the DSN and builds a connection
> > string. IN does not necessarily use the DSN. Try switching the setting
of
> > the checkbox "Search network for database servers" on the database tab
of
> > connection dialog. What happens? What value did it have previously?
> >
> > /ck
>
>