Automatically Connecting to Oracle database in code...

[THoey]

I am reposting this question to see if I might be able to figure out a problem I am having. I have an Oracle 7.3.4 table that I want to download nightly into Access 97. I have almost everything else set up to automatically run this process except I can't get Access to connect or link to the Oracle database without someone being there to provide the login and password.

I think my problem boils down to the connect string. Does anyone have an example of a connect string to an Oracle database that they run in VB? I have all the information and connect to this table manually all the time, but just need to figure out the format to do it in code. I have read and reread the help and example and, well, they are very vague due to the numerous "other" databases that Access will link to.

All help would be appreciated. Thanks...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[raygg]

Try making the connect variable a single concatenated var instead of 3 separate variables -- ex: v_connect_var = "v_user" + "/" + "v_password" + "@" + "v_db_alias"

 

[dkidman]

Try this method to re-link to your DSN then use the autoexec macro to execute the function. I have used this successfully for several off-hour downloads of data. I use launchpad to launch the MDB at the hour I need to process the downloads.

http://support.microsoft.com/support/kb/articles/Q159/6/91.ASP

Dan