Sybase11 Cannot connect database file locate on network drive but Sybase 9 can.

[BonWan]

Hi,
My company upgrad from Sybase9 to Sybase11 many problem
that we found, some problem we can fixed but some problem we
have to change implement code.
I have problem to asking, some of my application have to
connect database that locate on network drive.
When I use Sybase9 it work find but when try to use
Sybase11 to connect then I got error message "Specified
database not found:..."
I want to know why and how can I fixed this problem?

Thank you,

BonWan

[John Smirnios [Sybase]]

First, accessing database files over a network share is not recommended.
It is error prone (network disconnections can cause your database server
to fail), inefficient (particularly if your network bandwidth is a
limiting factor for IO speed), and may compromise your ability to
perform disaster recovery.

That said, we don't _prevent_ you from doing it. Are you starting the
database server as an Windows Service? Windows services that run on
SYSTEM accounts generally do not have access to the network shares that
the local user has defined and may not have access to the network at
all. Define your service to run as a user or, possibly, you may be able
to use UNC name but you will need to deal with permissions where the
file is hosted.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

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

[BonWan]

John,

Thank you for your response.

>>Are you starting the database server as an Windows
Service?

No, just connect database that locate on network drive for
get information from it.
It's ok my boss suggest the solution and I will follow it.

Thank you,

BonWan