DSN-Less Connection Strings

[flanakin]

I needed to get a DSN-less connecton string for an Oracle 8i database. Anybody have any clues? I've seen a couple, but none have worked. Thanks in advance! ~[ cid ]~

http://www.ciddivine.com

cid@cjd-web.com

 

[culshaja]

I know this isn't answering your question, but have you got the correct TNS Names settings for the database set up on the server along with Net8?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[flanakin]

Coincidentally, that's what the problem was. Turns out that someone messed with the TNSNames file and it was missing a paren. I looked at it for a while and then picked up on it. It's now working. If anyone else needs it, here...

PROVIDER={Microsoft ODBC for Oracle};
SERVER=instance_name_in_the_tnsnames_file;
UID=username;
PWD=password;

Hope this helps someone out there ~[ cid ]~

http://www.ciddivine.com

cid@cjd-web.com

 

[jscontreras]

Hi,

Did you have to installed the Oracle Client on your web server?

I know it's different for SQL Server. But I want to make sure before I do anything on the Web Server.

Thanks