What SQL is the SQL statement that is not working?
Does the direct dbms action work?
Are you using Witango 5.0.1.062 to connect to the database?
Are you using the Firebird JDBC driver to connect?
Phil
On 9/11/03 7:31 PM, "Brad Robertson" <[EMAIL PROTECTED]> wrote:
First, I would like to reinforce the sentiment expressed all of the time on this list about how great the members are to each other. Despite being thousand of miles apart and several hours apart, Jan feverishly helped me through the twilight hours of his night and into his first signs of a new morning. Well, thanks to Jan’s many hours working with me to solve this issue he was able to determine that his initial hunch was correct that it was a dialect issue. However, Jan and I weren’t able to come up with a viable solution since it appears that witango doesn’t support SQL dialect 3.
I am curious if anyone has any thoughts on work around methods for using witango on a SQL dialect 3 databases…
Thanks again Jan!!!
Regards,
Brad
-----Original Message-----
From: Jan Magnusson [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 5:11 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: need help with witango & interbase/firebird odbc
Brad,
And, oh yes, totally forgot to mention:
I hope your IB/FB db is NOT in SQL dialect 3 (I'm aftaid that might be the IB/FB default nowadays), it doesn't work with Tango. The db needs to be SQL dialect 1. This is also a parameter in the ODBC driver setup you need to check.
Jan
-----Original Message-----
From: Brad Robertson [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 09:38
To: [EMAIL PROTECTED]
Subject: Witango-Talk: need help with witango & interbase/firebird odbc
I am trying to connect to a firebird database through witango via odbc. The odbc driver seems to connect during it’s test and I can connect via other tools, however when I try to connect with in the tango editor I get the following error (no matter which odbc driver I use and how I configure it): Could not connect.. check user name and password or datasource configuration. I am in desperate need to get this up by Monday, any help or advise would be greatly appreciated…
Regards,
Brad
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
