morvin Posted May 5, 2010 Share Posted May 5, 2010 I have form created in AutoIt that connects to an Oracle 10 database using an ODBC connection (see below). I've been told I can't use ODBC because it's not encrypted, and it's not a secure connection to the db. Any idea's on the best way to get a secure connection to the Oracle DB from a Windows computer? $DSN = "DSN=MY_ODBC_CONECTION;UID=xxxxxxxxxx;PWD=xxxxxxxxxx" $adoCon = ObjCreate("ADODB.Connection") $adoCon.Open ($DSN) $adoRs = ObjCreate("ADODB.Recordset") $adoSQL1 = "select * from table" $adoRs.Open ($adoSQL1, $adoCon) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now