In my WWC_PROCESS class in webconnect I trying to connect to an oracle table using sqlstringconnect: lnConnHandle=sqlstringconnect('PrdfinConn'),
where PrdfinConn is a DSN defined on my server. However, when I send my request from the web I'm prompted to select a data source. When I use a DSN define on my local machine it works fine.

I can use a connection string like "Provider=MSDAORA;Data Source=PrdfinConn;User ID=XXXXXX;Password=XXXXXX" on an ASP page and it works fine. How do I get webconnect to use the DSN on the server.

Keith