I've developed a web based report system using .NET. I received the customers' test data in BTR (BRTIEVE) files and install PSQL V8 on my PC to develop the reports - all went GREAT.
I installed the system om a windows server at the customers' site and setup the odbc connection to the pervasive service running on the netware box.
No my system cannot retrieve data from the netware pervasive system.
NW32 client is installed on the server as well.
I can browse the data using VS.NET, but as soon as I runn the application is get an error stating: "The connection is closed". This is in the line of code just after is give the open command (which gives me no errors).
I've googled this problem the whole weekend and cannot find anything that would work.
What engine is running on the NetWare server?
As far as rights, ASPNET (the user used by ASP.NET) needs to have rights to the NetWare server. When you log in and use an EXE, ODBC is using your rights. When you use an ASP.NET app, the user is ASPNET and it doesn't have a lot of rights by default. Make sure ASPNET has rights on the NetWare box.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.