O$ ODBC Trusted connection

[Mayada Al-Kishtini]

Hi Steve,

I've done this once in Omnis 5.1 (Unicode), I think this is what you need to set:

oDbcSess is an object of type ODBCSESS

Calculate connectionString as 'DRIVER=SQL Server;SERVER=bkbas-svr2;DATABASE=wpb1;Trusted_Connection=Yes'
Calculate oDbcSess.$unicode as kTrue
Calculate oDbcSess.$uselogonprompt as kODBCPromptDsnLess
Calculate oDbcSess.$trustedconnection as kTrue
Do oDbcSess.$logon(connectionString,,,sessionName)

HTH,
Mayada

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Steve Finger
Sent: Sunday, February 28, 2016 8:02 PM
To: OmnisDev - English
Subject: O$ ODBC Trusted connection

Hi all,

Using Studio 4.2 (Unicode) we want to have the log in to SQL Server with ODBC to use a trusted connection

Has anyone done something like this in Omnis? Here is the example the DBA gave me:

Sample Trusted ODBC connection:
CurrentProject.OpenConnection "ODBC;DRIVER=SQL Server;SERVER=bkbas-svr2;DATABASE=wpb1;Trusted_Connection=Yes” 

Thanks,
Steve Finger
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com