 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 4) |
| Author | Comment |
Marc
May 29, 07 - 5:18 AM |
Auto ODBC Connection
I am scheduling an automated task involving an Access database macro. This macro consists of a number of queries. One of these queries involves two tables that are linked to an Oracle database using the ODBC connection. Since an automated schedule does not allow you to enter any oDBC login info anywhere in the setup screens, I need to write a VB code in Access to simulate this automatic ODBC connection login process. Has anybody written such code that I can use ? |
|
Daniel P
May 29th, 2007 - 2:59 PM |
Re: Auto ODBC Connection
Check out http://www.techonthenet.com/access/questions/oracle_connect.php http://orafaq.com/faqmsvb.htm - How does one connect to Oracle from VB? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2... http://www.carlprothman.net/Default.aspx?tabid=81 One of them should get you started -- Hope this helps, Daniel P |
|
Keith
Jun 2nd, 2007 - 6:40 PM |
Re: Auto ODBC Connection
I have been attempting to use a Passthrough query after such connection is made; and that has also proven to be a huge issue. It seems that MARS could really make this process easier; The queries when run independently work no problems; but when you try to have MARS run it automatically it stinks and times out. When I spoke with TechSupport they gave me the same links shown in the thread; but still have not gotten it to work |
|
MARS Development
Jun 6th, 2007 - 12:26 AM |
Re: Auto ODBC Connection
The functionality you require is in MARS V5 Build 20070604. No need to write your own vba code. Simply fill in the security details in the new tab in the custom task and schedule your macro/query as normal. 
|
| First |
Prev |
Reply |
Forum |
Next |
Last |