JIWA Connections (to SQL Server)

Discussions relating to breakout scripting, .NET and COM programming with Jiwa objects.

Re: JIWA Connections (to SQL Server)

Postby Scott.Pearce » Thu Nov 26, 2015 7:42 am

Jiwa 6 requires a patch to work with Windows 8 and above.

You can get the patch here.

Download
Extract
Overwrite the existing file in the Jiwa installation folder (normally c:\Program Files (x86)\Jiwa Financials\Jiwa)
Do *not* register the dll
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 765
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 230

Re: JIWA Connections (to SQL Server)

Postby oliverb » Wed Jan 27, 2016 11:30 am

This method did not work and i still can't see my Databases on the server.

Even the Server drop down list isn't showing
oliverb
I'm new here
I'm new here
 
Posts: 2
Joined: Wed Jan 27, 2016 10:08 am

Re: JIWA Connections (to SQL Server)

Postby Scott.Pearce » Wed Jan 27, 2016 1:54 pm

Some questions:

1. What OS are you using?
2. What function were you performing (i.e. were you simply creating a new connection)?

Also, ensure that you can connect OK to the database using SQL Management Studio with the same credentials.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 765
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 230

Re: JIWA Connections (to SQL Server)

Postby oliverb » Wed Jan 27, 2016 10:17 pm

I'm using Windows 7 64bit and just simply creating a new connection.

I can connect to the SQL. I tested using ODBC with the same credentials.
oliverb
I'm new here
I'm new here
 
Posts: 2
Joined: Wed Jan 27, 2016 10:08 am

Re: JIWA Connections (to SQL Server)

Postby Mike.Sheen » Fri Jan 29, 2016 2:32 pm

oliverb wrote:I'm using Windows 7 64bit and just simply creating a new connection.

I can connect to the SQL. I tested using ODBC with the same credentials.


I've just setup a Windows x64 With SP1 and installed 06.05.13 WITHOUT the Windows 8 patch mentioned above.

65313_Success_Connection.PNG
Successful connection
65313_Success_Connection.PNG (14.18 KiB) Viewed 7979 times


I can see the databases when I select the drop-down combobox...

...and when I supply an invalid password I get an error:

65313_Error_Connection.PNG
Error when supplying invalid password
65313_Error_Connection.PNG (16.99 KiB) Viewed 7979 times


Did you apply the patch for Windows 8? If so can you remove it and try again?

Mike
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807


Return to Technical / Programming

Who is online

Users browsing this forum: No registered users and 2 guests