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 <[email protected]> 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
