O$ ODBC Trusted connection
Steve Finger
steve at srptech.com
Sun Feb 28 22:11:56 EST 2016
Thank you Jim. I will see what happens with the $trustedconnection
Steve
> On Feb 28, 2016, at 9:57 PM, Jim Edison <JimE at EDIConcepts.net> wrote:
>
> Hey Steve,
>
> Long time since I did anything here so hope this helps. I am assuming Windows as I know nothing about Mac
>
> I think you just setup your odbc Data Source connection, log on in Omnis and then you should have a $ trustedconnection property in your session properties, just Do ioSess.$trustedconnection.$assign(1).
>
> I am not certain whether your odbc setup will need to specify authentication using Integrated Windows or whether the dba wants authentication using the SQL server in which case you will need the account and pw which I don't see in your connection string but you will probably need a login and pw for your ioSess.$logon(odbcname,User,Pass,Sessname) The only time I had to fool with this I noted that Trusted connection = Yes means a user account is used to establish this connection. (SQL user account or Windows account?? I don't know)
>
> Best Regards,
> Jim Edison CPCU
> EDI Concepts Inc. – Data Conversion and Programming
>
> Privileged/Confidential Information may be in this message. If you are not the intended addressee, please treat this message as confidential, contact me immediately, discard the message, and do not use or retain its contents. Dictation software may be used in constructing this message and at times may substitute words not intended by the writer. No offense is meant if a word substitution may appear offensive. Thank you.
>
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Steve Finger
> Sent: Sunday, February 28, 2016 6:02 PM
> To: OmnisDev - English <omnisdev-en at lists.omnis-dev.com>
> 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
More information about the omnisdev-en
mailing list