Connect to DSN on users machine

Results 1 to 2 of 2

Thread: Connect to DSN on users machine

  1. #1
    Join Date
    Dec 1969

    Default Connect to DSN on users machine

    Hi,<BR><BR>I&#039;m having trouble connecting to a SQL Anywhere database.<BR><BR>If I use the connection string:<BR><BR>oConn.Open "DSN=mySystemDSN;" & _ <BR> "Uid=myUsername;" & _ <BR> "Pwd=myPassword"<BR><BR>... this doesn&#039;t work as it cannot find the DSN. I know that this is because the DSN is on my machine and not on the server where the ASP page is stored.<BR><BR>How can I connect to the DSN on the users machine ? i.e. on the machine in each case.<BR><BR>I&#039;ve tried DSN-less connections but I can&#039;t get this to work either, I think because I do not know the default path to the database or the file as its not in the ODBC connection info.<BR><BR>Thanks,<BR><BR>Hal.

  2. #2
    Join Date
    Dec 1969

    Default Not using ASP.

    You cannot connect to a client-side database using any server-side language. You could write some client-side VBScript to do it if you want.<BR><BR>In which case, it&#039;ll obviously depend on the clients&#039; security settings as to whether you can actually access it...<BR><BR>Craig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts