Automating ODBC queries against Jade
Posted: Fri Nov 25, 2011 2:21 pm
Hi all.
Hoping someone can answer this one way or another.
I have a Jade Database running our financials with Greentree.
I have an Access 2003 database that has linked tables from the Jade database via odbc. The Access database runs a couple of MakeTable queries to generate some financial data for users that are not allowed access to the Greentree system.
This all works fine, but it is currently a manual system and I have to enter a Jade username and password every time the queries are run.
I am now required to automate this process to run a couple of times a day. With Oracle odbc I was able to store UID and PWD in the odbc in the registry. I know this is not ideal, but we put measure in place to minimize the risk. From what I have read so far I cant do this with the jade odbc, is there any other way I can automate the passing over of the UID and password?
Many thanks in advance.
Cheers all
Hoping someone can answer this one way or another.
I have a Jade Database running our financials with Greentree.
I have an Access 2003 database that has linked tables from the Jade database via odbc. The Access database runs a couple of MakeTable queries to generate some financial data for users that are not allowed access to the Greentree system.
This all works fine, but it is currently a manual system and I have to enter a Jade username and password every time the queries are run.
I am now required to automate this process to run a couple of times a day. With Oracle odbc I was able to store UID and PWD in the odbc in the registry. I know this is not ideal, but we put measure in place to minimize the risk. From what I have read so far I cant do this with the jade odbc, is there any other way I can automate the passing over of the UID and password?
Many thanks in advance.
Cheers all