ReportBuilder & Clientruntime Dir

Discussion forum about all things Report Builder (all versions).
MSpecht

ReportBuilder & Clientruntime Dir

Post by MSpecht » 30 Jun 2011, 08:25

Hello,

when I want to start the Report Builder I get an error that the SQL.ini is incorrect.
I found out that this is because the Client runtimedir which goes to the sqlbase Directory.

If I comment the clientruntimedir out, the reportbuilder starts.

please fix it.
You do not have the required permissions to view the files attached to this post.

Ana Paula Bonani

Re: ReportBuilder & Clientruntime Dir

Post by Ana Paula Bonani » 06 Jul 2011, 09:35

Hello,

By default, the clientruntimedir keyword of the sql.ini located into the TD folder points to the Team Developer root directory - which is where the Report Builder files are located.

Your SQL.INI must have been changed for some reason, or you're picking up the sql.ini from the \sqlbase sub-folder under the TD directory.

There's nothing for us to fix in this case.

Here's a TD6 default sql.ini example:
[dbntsrv]
dbname=ISLAND
servername=server1
cache=2000
sortcache=2000
readonly=0
oracleouterjoin=0
logfileprealloc=0
partitions=0
optimizerlevel=2
ansijoinsyntax=0
dbdir=C:\Program Files (x86)\Unify\Team Developer 6.0
tempdir=C:\Program Files (x86)\Unify\Team Developer 6.0

[dbntsrv.dll]
comdll=sqlws32

[win32client]
clientname=ANAM1530
clientruntimedir="C:\Program Files (x86)\Unify\Team Developer 6.0"

[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
; comdll=sqlora32
; comdll=sqlsyb32
; comdll=sqlodb32
comdll=sqlws32

[win32client.ws32]
serverpath=td60srv,localhost/*
autostartserverpath="C:\Program Files (x86)\Unify\Team Developer 6.0\sqlbase\dbntsrv.exe"

;[win32client.ws32]
; Resource Manager (sqlmpipe uses port 2156 explicitly declared instead of
; default port 2155
;serverpath=server1,localhost,2156/*
[oragtwy]
remotedbname=ora10g,@tns:ora10db
longbuffer=32767
fetchrow=20
substitute=SYSSQL.,
[sybgtwy]
remotedbname=test, hostname, master, 0
[odbcrtr]
odbctrace=off
odbctracefile=sql.log
longbuffer=250000
Thanks,

kwkonrad
Germany
Posts: 290
Joined: 24 Jan 2018, 13:10
Location: Karlsruhe Germany

Re: ReportBuilder & Clientruntime Dir

Post by kwkonrad » 13 Sep 2011, 13:23

You should also mention that Report Builder needs the SQL.INI file in the ProgramData folder ...

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest