O$ ODBC Trusted connection

[Steve Finger]

Hi Mayada,

Thanks!

I will see if this works in Studio 4.3.

Steve


> On Feb 28, 2016, at 8:52 PM, Mayada Al-Kishtini <mayadadb at hotmail.com> wrote:
> 
> 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
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com