Hi Rick,
Thanks for replying. I've checked and that is the version of P.SQL that
we're running. So I'm still lost with no options that I can see.
We were running the 058 version of the server because the 065 would not
work with P.SQL 7.x. So I just tried upgrading to the 065 hoping that
it would now work with the P.SQL 9.5 and still no luck. I do get a
different error though...
"Main Error Message: [Microsoft][ODBC Driver Manager] Function sequence
error - Secondary Error Message: HY010"
Has anyone see this error. Again, this is Witango Server 5.0.1.065
using ODBC to communicate to a Pervasive.SQL 9.5 database.
Thanks,
David Green
[EMAIL PROTECTED]
Rick Sanders wrote:
Hello David,
This is a P.SQL problem and not a WiTango problem.
You need to download and install SP2 for Pervasive SQL:
http://www.pervasive.com/support/updates/?product=psql
We have this running, and it works great.
The other option is to go with the JDBC driver for Pervasive SQL which also
works fine too.
Kind regards,
Rick Sanders
President
Tel: 902.401.7689
http://www.webenergy-sw.com/
This email was sent using Windows Vista & Office 2007. Looking to upgrade?
Contact us! We're Microsoft partners
-----Original Message-----
From: David Green [mailto:[EMAIL PROTECTED]
Sent: December-18-06 5:11 PM
To: witango-talk@witango.com
Subject: Witango-Talk: Witango 5.0 / Pervasive 9.0...
Hi Guys,
I think this issue has been raised in the past but I couldn't find
anything related to an answer. I'm hoping someone has seen this before
or even better, has this same setup working somewhere...
We've been running the following environment with no issues for at least
the last 3-4 years.
Witango Server:
- Windows 2000 Advanced Server
- Witango Professional Server 5.0.1.058 Chimera (Win32)
Database Server:
- Netware
- PervasiveSQL 7.x
We've tried upgrading Witango Server to 5.5 or even just to 5.0.1.065,
but because of the incapability of the ODBC versions?, we couldn't. So
now, years later, the database is finally going to get upgraded and
moved to a Windows Server (Totally different department and for totally
different reasons).
In our tests, with this environment:
Witango Server:
- Windows 2000 Advanced Server
- Witango Professional Server 5.0.1.058 Chimera (Win32)
Database Server:
- Windows 2003 Enterprise
- PervasiveSQL 9
It flat out doesn't work whatsoever. Regular tafs work fine, but I
can't get any of the database actions to work. Just the typical "-101
General error during data source operation." So before we go any
further, does anyone have the above scenario working in production
today? Will Witango 5.0 Server talk to Pervasive 9 via ODBC?
Any help is GREATLY appreciated!
Thanks,
David Green
[EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
