With 7.0, I was able to insert notes and companies without a problem but 8.0 has a different back end and Im not sure what the deal is... Anybody tried using Pervasive Datamanager to execute queries on a Maximizer db?

Basically, anything like what I have listed below except for Maximizer Enterprise 8.0

7.0 was simple to figure out,

INSERT INTO ADDRESS (Client_ID, Name, Address_Line_1, Address_Line_2, City, State_Province, Country, Zip_Code)
VALUES ('000407002942191021500C','Alternate Address', 'Address Line 1', 'Address Line 2', 'City', 'State / Prov', 'Country', 'Zip / Postal')

INSERT INTO APPOINTMENTS (App_Date, App_Time, [Text])
VALUES ('11/11/00', '08:30:00:00','Inserting Appointments')

INSERT INTO COMPANY (Company_Name)
VALUES ('New Company')

INSERT INTO HOTLIST (Schedule_Date, Schedule_Time, [Text])
VALUES ('11/11/00', '08:30:00:00', 'Inserting Hotlist')

INSERT INTO NOTES (Client_ID, Contact_Number, [Text])
VALUES ('000512009323076431425C',0,'Inserting Note')

INSERT INTO NOTES (Client_ID,Contact_Number, [Text])
VALUES ('000717000013303932693O',0,'Inserting Note for Opportunity Record.')

INSERT INTO OPPCOMP (Opp_Id, Opp_Number, Comp_Client_ID,Comp_Contact_Num, Comment)
VALUES ('RRR',0,'010119005241918463257C',0,'Comments for Opportunity competitor')

INSERT INTO OPPORTUNITY (Client_ID,Team_Id)
VALUES ('980204100691730339346C',-1)

INSERT INTO PEOPLE (Last_Name)
VALUES ('Smith')

INSERT INTO PROB_CLOSE_RANGE (Range_Min,Range_Max,Name)
VALUES (90,100,'Closing')

INSERT INTO RELATED_ENTRIES ( Related_To_Id, Related_To_Number, Related_From_Id, Related_From_Number, [Desc] )
VALUES ( '010604000023743326227C', 0, '010604000033743326227C', 0, 'Description for Related Entry.')

Create a System DSN using the Maximizer ODBC driver and then use that to execute the queries.

quote:

---

Originally posted by Gord:
Create a System DSN using the Maximizer ODBC driver and then use that to execute the queries.

---

Yea... seemed to work. Too bad I cant connect cleanly with Pervasive's driver because the datamanager and other tools like that are very useful. I connect the Maximizer DBs via Pervasive and then I get a ton of crazy named tables that are way harder to figure out than MAximizers ODBC driver.

That customization suite is sweet, I must admit. We finally got it... Not bad. My suggestion would be to create a function executor tool of sort with the driver if Maximizer was into suggestions.