Net*SQL connection string ?

I am working with a web application which needs to connect to an Oracle database. For this, I am running everything locally (Windows 2K, Apache and Oracle 9i) and all features seem to be working fine.

All I need now is the syntax for the Net*SQL connection (from the web application to the Oracle server) and, although I've done a lot of googling for syntax examples, I can't seem to get it working.

The application asks for the following:

1. Net*SQL connection string
2. collation sequence (sort order?)
3. User ID and password

I entered MYHOST.mysid as the connection string and entered User ID and password as requested (I wasn't sure about collation sequence), ran the test utility and got the following diagnostics:

^User ID:^?Password:;LOCAL;OR;ORACLE@%s_at_MYHOST.mysid_at_COLSEQ=

Of course the connection failed.

I sniffed around in the documentation and got the following syntax example:

(description=(address=(host=myhost)(protocol=tcp)(port=1521)(connect_data=(sid=(mysid)))

... and tried that: This sysntax just replaced MYHOST.mysid and the connection failed again.

I know that I am 'clutching at straws' so it would be really great if someone out there could give me a little example of a Net*SQL connection string.

Many thanks,
Alan Searle

PS: and what is meant by collation sequence / sort order ? Received on Fri Sep 02 2005 - 09:25:56 CDT