adolisp library: link to access 2007

[acitano]

Bye to all,
I built a 2007 access database with custom vba functions inserted in some db query.
I have to question the db through visuallisp and ado.
there is a library of functions very famous "adolisp_library.lsp" http://acad.fleming-group.com/download/adolisp/adolisp.html that allows to interface with the most famous db such as excel access sql server foxpro etc.
the library works perfectly when I interrupt the db, I can see simple query tables or even pass a sql stringas and receive the result.
when I have to question a query that contains my vba functions gives me the following error:

automation error. 'getdeltaprev3' function not defined in the expression.
description 'getdeltaprev' function undefined in the expression.
helpcontext 5003085
helpfile
nativeerror -530123806
number -2147217900
sqlstate 3085
source microsoft office access database engine

getdeltaprev3 is my function defined in a module of my db from the rest of the message you get the microsoft error codes.
looking a little here and I realized that it is not easy to digest internal vba functions to access outside so in my case to autolisp and adolsip_library.

What do I do? I make a call to a simple query and then I remake the functions in lisp? I'd like to know what death I have to die, because if that's the case, I'll put two or three more days of work.

thank you in advance and apologize if I went a little off the theme.
acitano

 

[blubossa]

hi acitano,
Can you tell me how you arranged with ado_lisp? I have tried several times to understand what could really be done and how to make it work. ...without ever reaching a conclusion...

Thank you.
bb

 

[acitano]

Hello blubossa, glad to help you if I can.
adolisp_library.lsp download it from the site of jon fleming (http://acad.fleming-group.com/download/adolisp/adolisp.html). the zip that comes down is composed of 4 files:
-adolisp.pdf --> the manual in clear concise useful to study line by line (unfortunately in English)
-adolisp_example --> some examples of connection to the access db of example adolisp_test.mdb
-adolisp_library.lsp --> the true library of the functions that allow you to connect via ado to any db provided you have the connection string
-adlisp_test.mdb --> db of example

Who is fleming?
simply he is one who sees how his bookstores are written should know "packs" on the lisp and on autocad is very famous within the American autodesk forums.

What does adolisp do?
to me has solved a whole series of communication problems between autocad and excel or between autocad and access.
for example I made a sw in lisp that allowed me to fill out carts or headers drawing (constructed obviously with a whole set of attributes) automatically reading a file of excel containing so many records how many carts were to fill out, and so many fields how many were the attributes for each cart.
As for access I am developing a sw that allows me to connect to a 2007 acess database that contains a series of reliefs that in turn contain points in continuously monitored wgs84 coordinates, the sw allows me to draw on autocad what "I see on the db" automatically, in this case the shifts in space from one relief to another.

with adolisp you can from autocad and underline by autocad:
- question a db and save a recordset in a list
-create new records in a db table
-change fields and records in db tables
-delete record from db table
- connect with most known db, just enter the right connection string that changes depending on the type of db you have to question. all the most famous connection strings are on the site: http://www.connectionstrings.com/for any other news are at your disposal
acitano:smile:

 

[blubossa]

hi acitano,
it is all clear that you should have some examples already built to understand us of +++ seeing the operation practically.

as soon as I have some time I try to force something and we see the operation. . .

Thank you.
bb