Solved Report Builder -- SQL INI Error

Report bugs and possible workarounds.
rleffew

Report Builder -- SQL INI Error

Post by rleffew » 29 Nov 2012, 04:35

I've installed SQLWindows 6.1 SP2 test drive on Windows 7. SqlWindows is working fine---connecting to a SqlBase db and well as using OLEDB to connect to SqlServer. I try to launch ReportBuilder, either from SqlWindows Tools or from Start menu, it pops up a dialog that says " SQL INI File Initialization failed. Check if INI files exists or is a valid INI file".

Installed into folder: C:\SQLWindows6.1 --- in that folder no SQL.INI files exists. There is one in C:\SQLWindows6.1\Sqlbase. I launched Conectivity Administrator and created a SQL.INI file in C:\SqlWindows6.1 folder. Same error. Searched the message boards and documentation, nothing on this error or mention of anything I might have not done correctly with the install.

All I want to do is create a QRP file and use with SQLWindows -- I don't even need it to connect to any data source.

Sirius7

Re: Report Builder -- SQL INI Error

Post by Sirius7 » 30 Nov 2012, 08:53

Look at Virtual Storage-Directory - there could be another SQL.INI.
Greetings
W.P.

rleffew

Re: Report Builder -- SQL INI Error

Post by rleffew » 01 Dec 2012, 02:12

If any one is interested, I found a solution.

The folder that Report Building is running in has a valid SQL.ini file -- so I knew that wasn't the problem even though it was being reported as "bad". So I went searching through the registry to see if perhaps Report Builder was trying to open a different Sql.ini file. I found HKEY_CURRENT_USER\Software\Unify\ReportBuilder 6.1\Settings\INIFilePath = "C:\SqlWindows6.1\sql.ini" -- which appears correct. I deleted the key value and presto...Report Builder now loads without errors.

ajthomas12
United States of America
Posts: 51
Joined: 03 Apr 2018, 00:03
Location: USA

Re: Report Builder -- SQL INI Error

Post by ajthomas12 » 26 Mar 2015, 01:18

Hello and thank you!

This is just what I needed to fix my issue, similar but not the same.

You helped me salvage my days work.

I love it when people come back and post their solutions.

Thanks again.

~Andy

vmarrero

Re: Report Builder -- SQL INI Error

Post by vmarrero » 07 Apr 2015, 08:52

Thanks buddy! I was THIS close to reinstalling ReportBuilder for the same reason! Clap yourself on the shoulder :wink:

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 301
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

Re: Report Builder -- SQL INI Error

Post by Steve Leighton » 01 Sep 2022, 03:01

.
Wow . This is an old post, but deleting the registry key value works like a charm.
Never had ReportBuilder complaining about sql.ini before - albeit sql.ini is all A-Ok, ( and I too don't even use it ) but RB still wont start.
I too was about to re-install, until I read 'delete the registry key'.
Its new to me - but it works !
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests