>You wrote:
><< >For a file DSN, just specify the path to the file.>>
>
>Erik,
>
>Do you have an example of the syntax for this? I assumed that, since the ODBC DSN was configured on the server, that the client would only need to provide the server name and the DNS in the connection string. I have been experimenting with various configurations of this, such as:
>
>ox = createobject('adolib.vfpado')
>ors = createobject("ADODB.Recordset")
>sql = "Select * from codelist"
>lcConn = "DSN=codelist; remote server=bob"
It looks like you're trying to configure a system DSN. I don't know for sure, but I don't think you can do that- system DSN are for the computer they are configured on. If you want to use a file DSN, just put the qualified path to the file in the connection string.
Erik Moore
Clientelligence