Oracle Connection strings

Posts   
 
    
grjoseph
User
Posts: 7
Joined: 03-Mar-2010
# Posted on: 05-Mar-2010 14:57:38   

Hello,

just a quick question. I was only given the TNS name for the oracle DB and in order for me to connect to this DB from LLBLGen was to install the Oracle Client and set up the TNS name in the tnsnames.ora file...then I was able to connect to the Oracle DB.

so my question is this. am I going to have to install the Oracle client on the server in which this application will run from in order for it to connect to the DB?

thanks..

P.S. I am using LLBLGen Pro 2.6 and connecting to a Oracle 10g db using VB.net.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 05-Mar-2010 20:49:37   

Yes, you need to install the client in order the application can connect to the correct TNS (the one specified in connection string on your app's *.config file.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39866
Joined: 17-Aug-2003
# Posted on: 06-Mar-2010 14:42:22   

with 'client' we mean: ODP.NET which contains both the ADO.NET provider and Oracle's client software, if you're using ODP.NET.. If you're using MS Oracle provider, it's sufficient to install just the Oracle client software (for 9i or higher).

Frans Bouma | Lead developer LLBLGen Pro