$OS 4.3.2.1 Mac Session Type VCS Connection Problem
Alain Stouder Omnis
omnis at smartway.ch
Thu Nov 24 03:09:59 EST 2016
David,
If you can install/uninstall the latest actual drivers on your El Capitan machine you could verify if the issue is with Actual drivers or with Sierra...
Just my 2 cents,
Alain
---
Learn something new every day!
> On 24 Nov 2016, at 01:04, David Ferri <davidferri at icloud.com> wrote:
>
> Hi All,
>
> This in Omnis Studio 4.3.2.1 developer on a brand new Mac running Sierra which came installed on it, i.e. not an upgraded machine. The Actual ODBC Driver for SQL Server and Sybase version 4.0.3 is installed and configured with a single data source confirmed to be connecting properly with the test at the end of the configuration panels. Then I did the following:
>
> - Launch Studio without a library running.
>
> - Create an ODBC session of Session Type SQL Browser to connect to a database on SQL Server 2014 using the sa login so permissions are not an issue. In SQL Browser open the session, it opens fine, in Interactive SQL I execute sp_who and it returns all the expected information. I close the session.
>
> - Create a second ODBC session with Session Type VCS using the sa login so permissions are not an issue. Open the session under VCS to our VCS database on SQL Server 2014 and it tells me that the resources are not there and do I want to install them. Of course not, I’m not interested in blowing away 15 years of history. No explanation of why I get that message.
>
> - Modify the second ODBC session and change nothing but the Session Type from VCS to SQL Browser. In SQL Browser I then open the session, it works fine, in Interactive SQL I execute sp_who and it returns all the expected information.
>
> - Modify the second ODBC session and change nothing but the Session Type from SQL Browser to back to VCS. In VCS I then open the session and it doesn’t find the resources.
>
> I have an older Mac running El Capitan and one running Mavericks. Both have the older Actual drivers version 2.9b running but they will not install under Sierra. Both session described above use the same data source that I created in ODBC Manager. They both work when their Session Type is SQL Browser but not when its VCS.
>
> Thoughts?
>
> Regards,
> David Ferri, President
> Word Master, Inc.
> 320 Earls Ct.
> Deerfield, IL 60015
> Ph: 847-948-9600
> Cell: 847-922-0080
> Fax: 847-948-9617
> http://www.wordmaster.com <http://www.wordmaster.com/>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
More information about the omnisdev-en
mailing list