Connecting to Oracle via ODBC

Hello all,

I am currently using this:

Please Login or Register  to view this content.

to connect to an oracle database. This is what I currently have as sConn

Please Login or Register  to view this content.

however I just get general ODBC error, does anyone know why this occurs or how I can correctly use the connection string?

trying to bump this question?

Originally Posted by JosephP

I reckon you're missing a closing parenthesis

Please Login or Register  to view this content.

strangely this was the right answer... i say strangely because, i must have mistyped it out because there was a bracket there... but on a lower line there was an extra ")"... thanks for the help!