ODBC connection for ORACLE

tatikramos · Post by **tatikramos** » Tue May 18, 2010 3:26 pm

I am trying to setup an odbc connection to connect to an oracle database. I have been researching just for my understanding do i need to install the oracle client in order to odbc to works?
I was just editing the .odbc.in file and uvodbc.cngf file.

chulett · Post by **chulett** » Tue May 18, 2010 6:53 pm

Do you have to? No. The wired driver doesn't need a client. The "non-wired" one does but if you have the client installed you should be using the native Oracle stages rather than ODBC.

So... why ODBC? To me that's the "access of last resort", hence the question.

tatikramos · Post by **tatikramos** » Wed May 19, 2010 2:38 pm

why ODBC. because we dont have the oracle client software installed on the server. so I guess i will use the ORACLE Wire Protocol instead.
Thanks

chulett · Post by **chulett** » Wed May 19, 2010 3:12 pm

Yup, that or get one installed... it's rather painless and well worth the effort! IMHO, of course.