I am reading data from a Oracle database using VBA.
I use Set OraSession = CreateObject("OracleInProcServer.XOraSession") to make a connection.
All works fine on a 32 bit computer, but not on a 64 bit computer.
How can I get data from Oracle on a 64 bit computer ?
Is it possible to use to Lisp or ADOlisp in stead of VBA ?
Thanks in advance,
Jan
Hi,
interesting question, because AutoCAD is running then 64bit, but VBA (the internal Server that is the primary VBA engine) is running 32bit. So at the moment I would think of you have a 64bit driver for Oracle installed and the 32bit VBA engine can't get connected to it. But for that U'm really unsure about that and sorry, I have no chance at the moment to try it.
But one principle statement to that: AutoCAD-VBA runs on 64bit so slow (depending in type of operation, but for access to AutoCAD entities you will have a factor of 100 or 1000 slower comapred to 32bit). Additionally since years Autodesk tell us that VBA will not be continued, I have no idea when it really stops, but knowing that I wouldn't do any start of development now with VBA, if you are firm in LISP, do new things in LISP, otherwise I would suggest to change to VB.NET, especially if you need connection to database you will recognize that development with dotNET based languages gives you great DB-functionality!
- alfred -