Hi
I am trying to use Dot net to connect to a sybase DB.
this connection string usually works but i have run into a snag
I use this connection string
ODBC; Driver=Sybase SQL Anywhere 5.0;Dbf=<path to db>;Uid=<LOGIN>;Pwd=<Password>;Dsn=<DSN NAME>
this server has 2 databases called MGN.db
1 is...
mirtheil,
running as a service works great (in our test environment), you are the man, the error still occurs but setting the service to restart prevents any down time.
got 1 last question for you if you don't mind.
the people running 7.9 are on SP3 which does not support running as a service...
yes i found a document for using the pvsw.exe
pervassive support tool box.
I will give it a try and hopefully it will work.
thanks for all your time Mirtheil
you rock, ill let you know if a few if it works
we are just using select queries and I have set the DSN up as read only as well. I will try to setare the workgroup engine as a service makes sense. I found out how to easily set it up with 8.6 and above. Got any ideas or resources on how to set 7.9 up as a service?
problem is that per our arrangement
we are not allowed on their clients server at all
plus
in the data directory on the server are ddf files with the paths hard coded, so we definately cannot alter the ddf's there or on the workstation. i was able to get a client interface dsn setup for the...
the servers all had the same version as the workstations in 3 of the 5 cases
i know in 2 cases the server is 7.8 while workstation is 7.9
we have been trying to convince the clients to upgrade their psql version on the server
yes this was the method they recommended
we used to break the .dat files appart and put the info in an access db
just cant figure out why the engine is dying like this
to clarify this is the situation
thanks for the help
software called HR OFfice is using the pervassive software.
We wrote a service to query data out of it.
So since the DDF are hard coded we are having to create an engine interface, tried using client but that did not work, think they still...
I am setting up a DSN on a workstation, THe local ddf files are hard coded to the path of the ddf files on the server.
The
I am setting up using the Pervassive ODBC Engine Interface.
Everything works fine for a while but occasionally I get
Error Loading Employee List : ERROR [HY000]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.