Posted this yesterday, didn't get a response from down under. Please
let me know if this is something I need to fix on my end, or if it's a
problem with the app server
Ok, I changed the data source types from ODBC to JDBC so I can test my
app on linux, and right away I've run into a problem. Here is the
debugging output. It basically shows two identical queries, one with a
search action, and another with a direct dbms action, and the direct
dbms action fails. reporting a syntax problem. I am using JSQLConnect
as the JDBC driver to connect to MSSQL 7. In the past I used this
particular JDBC driver with JTransit without any problems, even on this
same application, so i suspect that there must be a problem with Witango.
| [Application File] |
[40] |
START /test.taf WitangoServer |
| [Search Action] |
[40] |
All_Sites |
| [Query] |
[275] |
SELECT
S1.SiteID,S1.Title,S1.Description,S1.DisabledID,S1.NonExistID,S1.ResourceDir,S1.BaseURL,S1.StyleSheetPC,S1.StyleSheetMac,S1.MasterSite
FROM dbo.Sites S1 |
| [ActionResults] |
[461] |
1 Steakfest 21510 21510
\\ISIS\www\wwwste~1.com\ http://www.steakfest.com/ 20380
20380 |
| [Results Action] |
[461] |
Results |
| [Direct DBMS Action] |
[463] |
Direct_DBMS |
| [Query] |
[463] |
SELECT
S1.SiteID,S1.Title,S1.Description,S1.DisabledID,S1.NonExistID,S1.ResourceDir,S1.BaseURL,S1.StyleSheetPC,S1.StyleSheetMac,S1.MasterSite
FROM dbo.Sites S1 |
| [Error] |
[484] |
156 Incorrect syntax near the keyword
'SELECT'. S0001 |
| [Error] |
[484] |
-101 General error during data source
operation. |
| [request$ Vars] |
[485] |
variableTimeout=30;
resultSet=[Array:116x10]; |
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
|
