The difference between the User and System DSNs is simply a matter of permissions. System DSNs are available to the System - such as services - such as Witango and the "Administrator" account. Whereas User DSNs are available only to the user that created them. Thus, your applications can see them but not a service such as Witango. You could, if you wanted to, make Witango run as your user, and it would then be able to use User DNSs.
All that said, the System DSN configuration is the correct solution, and it seems that Tango2000 is incompatible with OpenBase. I would start by thinking in the terms of Tango2000 - try to get a copy of the ODBC driver from around 2000/2003. If the driver has any settings to force ODBC 2.x or to disable features such as asynchronous requests, try those. It's possible that if you are using a username/password that doesn't have Update permissions on the table that OpenBase is returning an error and Tango2000 is crashing attempting to process that error. Another thought is that there's a problem attempting to support @NUMAFFECTED (do DELETE actions also crash?) If you can trace the database, you might be able to see the problem better. I hope that helps Robert (PS. There's a good chance that you can work around this problem using a Direct DBMS Action) -----Original Message----- From: WebDude [mailto:[email protected]] Sent: Thursday, May 19, 2011 11:17 AM To: [email protected] Subject: Witango-Talk: ODBC via IP to OpenBase Hi folks, I am hoping someone could help me. Granted, I am using an old version of Witango, 2000, but hopefully someone a bit more knowledgable might be able to point me in the right direction. I need to connect via IP to an OpenBase database. I downloaded the recommended ODBC driver, Actual OpenBase and installed it on a Win 2003 server. After install, instructions state to create a user DSN, then I should be ready to go. When I create a User DSN, I can load the tables and view the columns in the Editor. But when I try doing a simple search, I get "The specified data source cannot be found." and "Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online." When I create a System DSN, I also can load the tables and view the columns in the Editor. I can also search and return data, but whenever I try to update, I get a Witango crash... "Client Error. The server refused connection." I go to the Witango logs and get the following... "Fatal error at 0285aa11: Write EXCEPTION_ACCESS_VIOLATION at f133c6dd." And then Witango goes through the restart stuff. So I guess one question would be, am I supposed to be using a User DNS or a System DSN? If a User DSN, is there something else I am supposed to be doing to get this to work past the Editor? I can view and load tables in the Editor, but cannot run an application through a browser. And the System DSN seems to get me a bit closer, but it seems very buggy and I cannot update the tables. Would a crash happen if a user on the other end did not have the correct permissions? Sorry for all the questions. I am not sure whet exactly the difference is between User and System. Also, I have made similar types of connections to MSSQL databases and have not had these types of problems, but this was several years ago. Thanks for any insight! ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
