Hi, I'm a SQL Server DBA and am investigating using SQL Server 2005's Database Mirroring for an application we have that uses WiTango.
I apologize in advance because I am not versed in WiTango. The version we are using is 5.5. Database connections are made through ODBC. What I've done is to set up database mirroring for a database. Mirroring failover works correctly at the database level. I then created a simple C# app that pulls data as test. I also substituted the usual ODBC driver with the Windows the SQL Native Client ODBC wrapper, in which I can specify a server for the mirror. The C# app works as expected, and when I failover the database I the Native Client ODBC redirects to the correct server, and the application then correctly pulls data from the mirror seamlessly. I am monitoring both servers with traces so I can see all login events. However, when I try same setup through Witango for the same database, everything works as expected when we are not failed over but after failover the ODBC connection will not redirect to the mirror server. While I don't see a failed login attempt in my trace (I am auditing login failed and success) , I do have a WiTango page that explains the database connection failed. When I run this with my C# app I again won't see the login failed, but will see activity on the failover side as expected. I've tried to enable logging on the ODBC connection, but I'm not having sucess (it simply writes out an empty log file). I believe this output could be very helpful, but until I can get this logging to work successfully I don't have much to go on at that level. One of the developers gave me the .tcf file where the database connections are made, and one difference between my test apps odbc connection and the WiTango connection is that the WiTango credentials are encrypted. I haven't tried encrypted the credentials in my test app. Any idea what I might be missing, or something I should look into? Does anyone have any experience with Datbasebase Mirroring and WiTango? It would seem that if the ODBC Native client works for WiTango's usual connection to the database, and that if it can detect a failover, it should be able to redirect WiTango as well. Thanks, Rob Trahan -- This message was sent on behalf of [email protected] at openSubscriber.com http://www.opensubscriber.com/messages/[email protected]/topic.html ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
