Search:

Type: Posts; User: barrymavin

Search: Search took 0.05 seconds.

  1. Replies
    16
    Views
    10,371

    Normally the simplest solution to get started is...

    Normally the simplest solution to get started is to put the credentials in the odbc DSN itself. Once you have everything working you can revisit this.
  2. Replies
    16
    Views
    10,371

    As I mentioned in your ticket and for the benefit...

    As I mentioned in your ticket and for the benefit of others.

    You need to put the uid and password in the connstr.

    This is not the only way to do it but you will allow you to proceed past this...
  3. Replies
    16
    Views
    10,371

    Well VFP does not have virtual tables so perhaps...

    Well VFP does not have virtual tables so perhaps you have the uid and psd somewhere in your code such as the named connection.
  4. Replies
    16
    Views
    10,371

    You have not authenticated. Unless your username...

    You have not authenticated. Unless your username / password is in the DSN.
  5. Replies
    16
    Views
    10,371

    Your connection is succeeding. DIR in the ODBC...

    Your connection is succeeding.
    DIR in the ODBC tab is working.
    SET DEBUG ON in the Lianja/VFP tab.
    go to data workspace and double click your database
    exit lianja
    look in c:\lianja\debug...
  6. Replies
    16
    Views
    10,371

    Connecting to the server using a username and...

    Connecting to the server using a username and password will only grant you rights for that user. If no tables are listed using DIR then you have no access. You can troubleshoot by issuing a SQL...
  7. Replies
    16
    Views
    10,371

    Working with MSSQL

    It is simple to work with third party databases in Lianja.

    Apart from Virtual Tables you can perform queries very quickly with minimum coding.

    Take a look at this screenshot which demonstrates...
Results 1 to 7 of 7
Journey into the Cloud
Join us