6.2.15 thin client ODBC connection

For questions and postings not covered by the other forums
BobNZ
Posts: 4
Joined: Tue Apr 27, 2010 3:05 pm

6.2.15 thin client ODBC connection

Postby BobNZ » Tue Apr 27, 2010 3:10 pm

Problems setting up thin client. Ran the JADEwin32AnsiThinClient.exe which does not install the JADE ODBC Thin Client driver?
Which 6.2.15 download do I need to install the thin client driver for ODBC data source?

User avatar
BeeJay
Posts: 312
Joined: Tue Jun 30, 2009 2:42 pm
Location: Christchurch, NZ

Re: 6.2.15 thin client ODBC connection

Postby BeeJay » Tue Apr 27, 2010 3:52 pm

I don't believe the JADE ODBC Thin Client is available until the JADE 6.2.17 release and above. Once you've run the presentation client install for JADE 6.2.17 or above, you should then be able to use the Windows Control Panel Datasource Applet to create the DSN with the appropriate connection details etc. You'll have to make sure you use the 32bit Datasource Applet if you're running on a 64bit OS with the 32bit version of JADE or you won't see the JADE ODBC Thin Client driver.

Cheers,
BeeJay.

hpatel
Posts: 4
Joined: Tue Jun 30, 2009 2:41 pm

Re: 6.2.15 thin client ODBC connection

Postby hpatel » Wed Apr 28, 2010 9:33 am

Some more info here that might help: https://wiki.jadeworld.com/JADEThinClientODBC

User avatar
Jade Support
Posts: 103
Joined: Mon Aug 17, 2009 10:27 am
Location: Jade Software Corporation, Christchurch

Re: 6.2.15 thin client ODBC connection

Postby Jade Support » Wed Apr 28, 2010 10:10 am

Also, the 32-bit Data Source Administrator is odbcad32.exe and can be found in the C:\Windows\SysWOW64\ folder on 64-bit editions of the Windows operating system.

http://support.microsoft.com/kb/942976

Aaron Morgan
Jade Support
Jade Software Corporation Ltd

Email: jadesupport@jadeworld.com
Web: http://www.jadeworld.com

Jade Software – complex business problems solved beautifully.

torrie
Posts: 92
Joined: Fri Aug 14, 2009 11:24 am

Re: 6.2.15 thin client ODBC connection

Postby torrie » Wed Apr 28, 2010 10:18 am

If you've got access to Jade 6.3, then you may be able to use the odbcinst supplied with that release to install both the driver. We install the driver and the data sources manually under a different registryKey so we can have one driver per system (to support multiple Jade version on one PC) I haven't tried this utility with Jade 6.2 but it's likely that it would work.

From the Jade 6.3 Readme Install Steps file (for thin client you will need the last entry only.) Also note that the dll should exist in the binDir path specified.
To setup the JADE ODBC Driver for execution:
Run
odbcinst registryKey="JADE ODBC Driver" binDir=<JADEDIR>\bin dllName=jadodbc.dll
odbcinst registryKey="JADE ODBC Driver 6.3" binDir=<JADEDIR>\bin dllName=jadodbc.dll
odbcinst registryKey="JADE ODBC Thin Client" binDir=<JADEDIR>\bin dllName=jadodbc_c.dll

BobNZ
Posts: 4
Joined: Tue Apr 27, 2010 3:05 pm

Re: 6.2.15 thin client ODBC connection

Postby BobNZ » Mon May 24, 2010 1:39 pm

There is an issue with jade 6.2.17 the odbc dll's are the wrong version. We had to copy the jadodbc_c.dll from the server to the client bin file, connection then worked.

Jade plant are now aware of this and fixing

User avatar
BeeJay
Posts: 312
Joined: Tue Jun 30, 2009 2:42 pm
Location: Christchurch, NZ

Re: 6.2.15 thin client ODBC connection

Postby BeeJay » Mon May 24, 2010 1:51 pm

The jadodbc_c.dll file is one of the files automatically downloaded by the JADE Smart Thin Client™ automatic update facility. For our sites that use the JADE ODBC Thin Client, they are also running our main application as a JADE Smart Thin Client™ using the same /bin directory, which takes care of keeping the jadodbc_c.dll file in this /bin directory in sync with the server.

Am I correct in presuming that you are only running the JADE ODBC Thin Client from this /bin directory on the presentation client, and therefore not using this /bin directory for running any JADE Smart Thin Client™ applications?

Cheers,
BeeJay.


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 22 guests