PDA

View Full Version : when will we be able to test connectivity to MS SQL?



Question
2011-10-03, 06:18
when will we be able to test connectivity to MS SQL?

lianjasupport
2011-10-03, 06:19
For the latest development schedule news, please follow the updates on the Roadmap: http://www.lianja.com/resources/roadmap

Question
2011-10-03, 06:20
"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?

lianjasupport
2011-10-03, 06:20
Yes, that is the current plan. The Roadmap has the latest information on the development schedule and any changes will be reflected there.

lianjasupport
2012-02-29, 07:38
This functionality is now available as of beta6.

johnnywild
2012-03-02, 17:40
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!

lianjasupport
2012-03-02, 19:11
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.

barrymavin
2012-03-02, 19:36
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

mikemeer
2012-08-02, 16:51
Can you connect to MS-SQL data without an ODBC connection?

lianjasupport
2012-08-02, 18:44
No. We use the data source so that the product is cross platform and database independent.

HankFay
2012-08-02, 22:22
No. We use the data source so that the product is cross platform and database independent.

Mike: Note that "odbc connection" includes both a DSN and a Connection String.