go to post Robbie Luman · Nov 17, 2023 I'm amazed at how little code is actually required to get a fully operational server application running! Nice work!
go to post Robbie Luman · Jun 14, 2017 I ended up changing over to use the CacheActiveX method for connecting and running the query which works really well. I do have a question, though: Is there any way to use a defined ODBC DSN in the connection string using CacheActiveX?
go to post Robbie Luman · Jun 14, 2017 Thanks! I figured out my issue, I had set up my ODBC connection incorrectly and was referencing the wrong namespace. Thank you for the assistance!
go to post Robbie Luman · Jun 14, 2017 Thank you for the responses so far, I greatly appreciate them!I found some information online about using ADO and ODBC to make the connection which has gotten me close. Here is what I have in Excel VBA:and here is the error I get when I run this code:The "GETSQLLBIMA7" query exists in the USER namespace under the USER package. I'm not sure where "SQLUSER" is coming from or how to specify a different namespace or package.
go to post Robbie Luman · Jun 14, 2017 Thank you both for your responses, I greatly appreciate the help!I tried going down the ODBC route using ADO based on some other information I have found and I seem to be getting hung up by something not getting specified in the call to Cache through ODBC. Here's what I have in the Excel VBA:When I try to run this, I get this error:The Query "GETSQLLBIMA7" exists in the USER namespace under the USER package. I'm not sure how to specify to look under USER rather than SQLUSER when calling Cache.