General information
Category:
West Wind Web Connection
Title:
Forcing DSN on server to be used rather than on client
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only