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.

Dbeng Using Windows Environment Variable

2 posts in General Discussion Last posting was on 2007-03-05 19:44:26.0Z
Kevin Arnold Posted on 2007-03-05 17:24:47.0Z
Sender: 2a55.45ec4f52.1804289383@sybase.com
From: Kevin Arnold
Newsgroups: ianywhere.public.general
Subject: Dbeng Using Windows Environment Variable
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45ec525f.2ab6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Mar 2007 09:24:47 -0800
X-Trace: forums-1-dub 1173115487 10.22.241.41 (5 Mar 2007 09:24:47 -0800)
X-Original-Trace: 5 Mar 2007 09:24:47 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5861
Article PK: 1845

I am trying to assign a Windows Environment Variable (that
points to the location of our .DB) to the DatabaseFile value
in ODBC configuration. I cannot get this to work, I have
tried, %OURDB%, and @OURDB to no avail. This DB starts great
when I use the DBF=$OURDB% when using dbsrv. I also do
Start, Run and type in %OURDB% and the DB opens up. Any
suggestions would be greatly appreciated.

Kevin


Breck Carter [Team iAnywhere] Posted on 2007-03-05 19:44:26.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Dbeng Using Windows Environment Variable
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <4msou2punl9hjq9fc4q0tqj0b5nidhlrop@4ax.com>
References: <45ec525f.2ab6.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 5 Mar 2007 11:44:26 -0800
X-Trace: forums-1-dub 1173123866 64.7.134.118 (5 Mar 2007 11:44:26 -0800)
X-Original-Trace: 5 Mar 2007 11:44:26 -0800, bcarter.sentex.ca
Lines: 21
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5862
Article PK: 1844

I don't think environment variables can be referenced from inside an
ODBC DSN.

On 5 Mar 2007 09:24:47 -0800, Kevin Arnold wrote:

>I am trying to assign a Windows Environment Variable (that
>points to the location of our .DB) to the DatabaseFile value
>in ODBC configuration. I cannot get this to work, I have
>tried, %OURDB%, and @OURDB to no avail. This DB starts great
>when I use the DBF=$OURDB% when using dbsrv. I also do
>Start, Run and type in %OURDB% and the DB opens up. Any
>suggestions would be greatly appreciated.
>
>Kevin

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com