more ODBC driver
От | Cedar Cox |
---|---|
Тема | more ODBC driver |
Дата | |
Msg-id | Pine.LNX.4.21.0007022017510.7526-100000@nanu.visionforisrael.com обсуждение исходный текст |
Список | pgsql-interfaces |
I'm new. I'm working on developing an inventory system with PG as the back end and (eek..) MS Access as the front end. I'm a bit lost because most of the DB design was done by someone else and I just convinced him that a client/server model was better.. so I'm left with the server side of things and he's fighting 'Evil Access'. Things seem to work ok, but I have a couple strange things. First of all, PG 7.0.2, PsqlODBC 6.50, Win98. Whenever windows 'starts' ODBC (enter control panel, open ODBC connection...), I get an error message: The ODBC resource DLL (ODBCINT.DLL) is a different version than the ODBC setup dll(ODBCCP32.DLL). You need to reinstall ODB.... Do I need to? How? Is there a nifty Microsoft update for a completely new version? I think I'm due for reinstall of 98 soon, but I'm not up to it right now (kinda like changing the oil in my car..) Despite this, other things seem to work. Now here's my problem. When executing a query in Access, I get the error: Error while executing the query; ERROR: parser: parse error at or near "{"(#1) The SQL received by the back end is (get ready!): (((SELECT "T1"."TreeID" ,"T1"."Name" ,(textcat(({fn concat(({fn concat(({fn concat(({fn concat(({fn concat(({fn concat(({fn concat("T1"."Name" ,' ' )) ,"T2"."Name" )}) ,' ' )}) ,"T2"."Description" )}) ,' ' )}) ,"T3"."Name" )}) ,' ' )}) ,"T3"."Description" )}) ,"T1"."Weight" ,"T1"."NumPerBox" ,"T1"."UnitID" ,"T1"."SurID" ,"T1"."ParentID" FROM "tblStResTree" "T1","tblStResTree" "T2","tblStResTree" "T3" WHERE ((("T1"."Description" IS NULL ) AND ("T1"."ParentID" = "T2"."TreeID" ) ) AND ("T2"."ParentID" = "T3"."TreeID" ) ) ) UNION (SELECT "T1"."TreeID" ,"T1"."Name" ,(textcat(({fn concat(({fn concat(({fn concat("T1"."Name" ,' ' )) ,"T2"."Name" )}) ,' ' )}) ,"T2"."Description" )}) ,"T1"."Weight" ,"T1"."NumPerBox" ,"T1"."UnitID" ,"T1"."SurID" ,"T1"."ParentID" FROM "tblStResTree" "T1","tblStResTree" "T2" WHERE (("T1"."Description" IS NULL ) AND (("T1"."ParentID" = "T2"."TreeID" ) AND ("T2"."ParentID" = 0 ) ) ) )) UNION (SELECT "TreeID" ,"Name" ,"Name" ,"Weight" ,"NumPerBox" ,"UnitID" ,"SurID" ,"ParentID" FROM "tblStResTree" "T1" WHERE (("Description" IS NULL ) AND ("ParentID" = 0 ) ) )) UNION (SELECT "TreeID" ,"Name" ,"Description" ,"Weight" ,"NumPerBox" ,"UnitID" ,"SurID" ,"ParentID" FROM "tblStResTree" WHERE NOT(("Description" IS NULL ) ) ) The query text in Access is (equally as ugly): SELECT T1.TreeID as TreeID, T1.Name AS Name, T1.Name&' '&T2.Name&' '&T2.Description&' '&T3.Name&' '&T3.Description AS Description, T1.Weight, T1.NumPerBox, T1.UnitID, T1.SurID, T1.ParentID FROM tblStResTree AS T1, tblStResTree AS T2, tblStResTree AS T3 WHERE T1.Description is null AND T1.ParentID=T2.TreeID AND T2.ParentID=T3.TreeID UNION SELECT T1.TreeID, T1.Name AS Name, T1.Name&' '&T2.Name&' '&T2.Description AS Description, T1.Weight, T1.NumPerBox, T1.UnitID, T1.SurID, T1.ParentID FROM tblStResTree AS T1, tblStResTree AS T2 WHERE T1.Description is null AND T1.ParentID=T2.TreeID AND T2.ParentID=0 UNION SELECT T1.TreeID, T1.Name AS Name, T1.Name AS Description, T1.Weight, T1.NumPerBox, T1.UnitID, T1.SurID, T1.ParentID FROM tblStResTree AS T1 WHERE T1.Description is null AND T1.ParentID=0 UNION SELECT TreeID, Name, Description, Weight, NumPerBox, UnitID, SurID, ParentID FROM tblStResTree WHERE Description is not null; I think I understand the workings of the system (PG+ODBC+Access), but I only have a little experience in Access, and less with PG/ODBC. Help! Thanks, -Cedar
В списке pgsql-interfaces по дате отправления:
Предыдущее
От: "Sverre H. Huseby"Дата:
Сообщение: UNFINISHED code for more scalable JDBC driver available
Следующее
От: Peter MountДата:
Сообщение: RE: UNFINISHED code for more scalable JDBC driver av ailable