Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Working with MSSQL

  1. #11
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    Well VFP does not have virtual tables so perhaps you have the uid and psd somewhere in your code such as the named connection.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #12
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    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 stage by doing that.

    A VT is the equivalent in VFP terms as combining:

    - a connection
    - a view
    - a cursoradaptor

    But looks like a normal table so can be used in desktop/web/mobile apps without any messy coding required.

    They can be paramerized and can be Requeried
    They handle fetch on demand of individual rows or pages or rows from any database type
    They handle syntax translation
    They handle conflict resolution
    Etc...
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #13
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,377
    Slightly old screenshot, but the entry fields still apply:

    Modify Virtual Table with uid/pwd

    From:

    Virtual Tables - Further Configuration and Troubleshooting


    Regards,

    Yvonne

  4. #14
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    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.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #15
    Junior Member
    Join Date
    Apr 2019
    Posts
    14
    Thanks very much both
    I assumed that when the virtual tables are created from the menu - As I had to enter the UID & Password - it would somehow propagate that detail to the vt
    I understand now that each virtual table has to be manually set up with the UID & PWD after they have been created using that method
    So I'm guessing I can issue a line of code that cteates a vt with the UID/PWD, I'll look at that
    I get it now, thanks for clearing this up

  6. #16
    Junior Member
    Join Date
    Apr 2019
    Posts
    14
    I'll revisit the DSN, that seems to be the issue, Local MS-SQL works fine, I only get the issue for remote MS-SQL
    I can see why now so I'll leave you in peace - thanks

  7. #17
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,210
    Not sure if this is helpful, but I have created several procs that I use when connecting to MSSQL, which I do for a good portion of my applications.

    Here is an example of one.

    This is a proc called getremotefulltable.
    param tablename, cursorname


    gnConnHandle =sqlconnect("matchbackODBC","servicename","service pwd")
    lianja.writelog(str(gnConnHandle))
    strw1 =' select * from '+tablename+' '
    =SQLPREPARE(gnConnHandle,strw1,'cresult')
    =SQLEXEC(gnConnHandle)
    macro = 'select * from cresult into cursor '+cursorname+' readwrite'
    &macro
    use in cresult
    =sqldisconnect(gnConnHandle)
    I use it like this.

    getremotefulltable('exceptions','c_exceptions')

    So then in Lianja, I have a cursor called c_exceptions which exists after the connection string is closed.

    I the same thing for filtered tables where I also pass in a where condition.

    Just my 2 cents.

    Herb

Page 2 of 2 FirstFirst 12

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us