DSN-LESS and TNS-Less Oracle Connection?

[richard9]

I want to make a DSN-Less connection to Oracle, usin no TNSNames, using the connectstring method. However, Im struggling to find the exact syntx, and keep getting the message 'DBMS is not supported in you current installation'. Is an Oracle 8.0.4 database. Thanks.

 

[OlanKnight]

Richard -

In order to connect to an Oracle database, the Oracle Client must be installed on each client PC. That automatically means that the TNSNames.ora file is installed on the PC.

If the Oracle client is NOT installed, you'll get that "DBMS is not supported" msg. This most un-helpful msg also comes up for a variety of other reasons.

So ensure that the Oracle client is installed on your client PC and is installed correctly. Test this by making a connection to the database by using the PB Database Painter.

If you can connect using the DB painter, then you can connect using a transaction object in your script.


Olan

 

[richard9]

but is there a way I can connect via the app, without having to modify their tnsnames? I've been asked to make rollout more streamlined, and if We could avoid updating tnsnames, it would be a help?

 

[OlanKnight]

Richard -

OK, now I'm confused. Why would you want to change the TNSNames file? The only reason I know of to do so is 1) because the physical connection to the database has changed (like the port number), or 2) because you are adding a new connection to a new database.

If you are adding a new connection, you still need to update the TNSNames.ora file, but you can do so from within a script by opening the file, appending the new entry, then closing the file.


Olan

 

[richard9]

Olan,

Err..thanks. Good point, We only need to change the TNSNames rarely. Think I've got carried away with trying to do something that was pointless. I'll change it through the code.

regards
Richard