when will we be able to test connectivity to MS SQL?
when will we be able to test connectivity to MS SQL?
For the latest development schedule news, please follow the updates on the Roadmap: http://www.lianja.com/resources/roadmap
"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?
Yes, that is the current plan. The Roadmap has the latest information on the development schedule and any changes will be reflected there.
This functionality is now available as of beta6.
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!
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.
You can specify a full ODBC connection string. Try looking here and try a few until you get a connection.Originally Posted by Question
http://www.connectionstrings.com/sql-server-2005
Can you connect to MS-SQL data without an ODBC connection?
No. We use the data source so that the product is cross platform and database independent.
Posting Permissions
Reply With Quote
Bookmarks