Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: when will we be able to test connectivity to MS SQL?

  1. #1

    when will we be able to test connectivity to MS SQL?

    when will we be able to test connectivity to MS SQL?

  2. #2
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    For the latest development schedule news, please follow the updates on the Roadmap: http://www.lianja.com/resources/roadmap

  3. #3
    "Lianja CloudDB configurable support for alternate databases; MySQL, PostgreSQL, Oracle, MS SQL Server, and ODBC. The application publisher will automatically perform data and schema conversion when publishing to the CloudDB. This enables one App to be built for many different database engines."

    Next year then? Not in the beta as per your previous comments to Frank?

  4. #4
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    Yes, that is the current plan. The Roadmap has the latest information on the development schedule and any changes will be reflected there.

  5. #5
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    This functionality is now available as of beta6.

  6. #6
    Junior Member
    Join Date
    Feb 2012
    Posts
    11
    Has anyone actually connected to a SQL Server database yet? We use integrated Security because no SQL logins are allowed due to security. I tried the normal VFP way but have had NO success. We also cannot use ODBC local data sources. I must use the CREATE CONNECTION <conn name> CONNECTIONSTRING (), etc and then SQLCONNECT(<conn name>) as in VFP! This does not work at all and shows no errors. I tried CREATE CONNECTION ? and this LOCKS up my machine!

    Help!

  7. #7
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    If you look at the blog entry for BROWSE on Lianja.com you will see that this is done against adventure works in MSSQL. You can use either an ODBC DSN or an ODBC connection string. There have been some issues fixed in beta6 R2 which may be affecting you ability to connect. Once that is released try it again using a ODBC connection string. CREATE CONNECTION is not supported so we will fix the issue of it locking up. Please submit a ticket on Lianja.com so it is scheduled for fixing.

  8. #8
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,515
    Blog Entries
    15
    Quote Originally Posted by Question View Post
    when will we be able to test connectivity to MS SQL?
    You can specify a full ODBC connection string. Try looking here and try a few until you get a connection.
    http://www.connectionstrings.com/sql-server-2005

  9. #9
    Can you connect to MS-SQL data without an ODBC connection?

  10. #10
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    No. We use the data source so that the product is cross platform and database independent.

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