[Jprogramming] ODBC with DSN-less connection string

[Cox, Ed]

Thanks Bill,
I am looking in the odbc script (could not find one named jodbc).  In it I see the definition for ddcon, and inside it has this line:
z=. sqlconnect LASTCONNECT=: HDBC;(bs dsn),(bs uid),bs pwd

But at the top of the file I see this definition for sqlconnect:
sqlconnect=: 'odbc32 SQLConnect s i *c i *c i *c i' &cd

So is this the one I want to modify?  So that it would become:
sqlconnect=: 'odbc32 SQLDriverConnect s i *c i *c i *c i' &cd

I just want to make sure I understand you, and also get it into the archives for anyone else who looks for this.

Thanks,
Ed

------------------------------

Message: 8
Date: Sat, 1 May 2010 08:26:07 +0800
From: bill lam <bbill.lam at gmail.com>
Subject: Re: [Jprogramming] ODBC with DSN-less connection string


DSN-less connection require a patch to the verb ddcon inside jodbc
script.  Search for the api sqlconnect and modify it to use another
api sqldriverconnect.


???, 30 ??? 2010, Cox, Ed ?????(?):
> I have tried numerous times to get ODBC working in J using DSN-less connection strings but have never gotten it to work.  (Most often trying for SQL Server and/or Excel.)  I have done so successfully in other languages so I think that should eliminate about 95% of the possible newbie mistakes.  Has anyone been able to get this working, and if so could you share some examples of how you did it?
>
> Thanks in advance,
> Ed Cox
> CareFusion, Inc.
>

_________________________________________________

This message is for the designated recipient only and may contain privileged, proprietary
or otherwise private information. If you have received it in error, please notify the sender
immediately and delete the original. Any other use of the email by you is prohibited.

Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - Norsk - Portuguese
Svenska: www.cardinalhealth.com/legal/email