Unable to load SQLWNTM.dll with IIS on win2008 X64

Discussion regarding older releases of SQLBase.

Unable to load SQLWNTM.dll with IIS on win2008 X64

Postby uliat » Wed Jul 08, 2009 11:59 pm

Hello,
We have a critical error when using the Gupta SQLBase .Net Data Provider with IIS7 application on win 2008 server 64bit based machine. In fact, Gupta.SQLBase.Data.dll is not able to load the SQLWNTM.dll and show this error : "Unable to load SQLWNTM.dll SQLBase API library... check your clientruntimedir"

system variable %path% is good. sql.ini is good
we have on this machine sqlbase 9 server. we tried to use client's dll version 11.5 and the data provider version 11.0 but it doesn't work

we have done the same installation and configuration on a on a 32bit based machine, the web site work fine and there are no errors.

Someone has already encountered this problem and has resolved?
uliat
 
Posts: 28
Joined: Sun Mar 15, 2009 10:54 pm

Re: Unable to load SQLWNTM.dll with IIS on win2008 X64

Postby mvandine » Sun Jul 12, 2009 9:11 am

I have moved this topic into the SQLBase\Older Releases section so you might get more responses.

Can you please post your sql.ini file from the server?

What does a DLL dependency tool show is preventing the SQLWNTM.DLL from loading?
Mike Vandine
Gupta Technologies
User avatar
mvandine
 
Posts: 3241
Joined: Wed Feb 14, 2007 4:15 pm
Location: Perth, Western Australia

Re: Unable to load SQLWNTM.dll with IIS on win2008 X64

Postby uliat » Tue Jul 14, 2009 7:10 pm

here is sql.ini for web applications only
Code: Select all
[win32client.dll]
comdll=sqlws32


[win32client.ws32]
serverpath=Prod,localhost,2155/*


[win32client]
clientname=CHTSE_Client
secureapi=0
negotiateapi=0
clientruntimedir="C:\Programmes_dicsit\GUPTA\PROD"



here is sql.ini from server directory (sqlbase server and sqlbase administratives tools)
Code: Select all
; Win32
;--------------------------
; Use this section to specify Win32 client workstation parameters  that
; are independent of the communications protocol(s) being used.
;
; This section is for the Win32 client workstations. Here you will specify
; the COMmunication DLL(s) that the Win32 application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
;   comdll      SQLBase target
;   ------      --------------
;   sqlapipe   LOCAL database using Anonymous Pipes
;   sqlws32      REMOTE database using TCP/IP (WinSock)
;
[win32client]
clientname=CHTSE_ServeurProd
clientruntimedir="C:\Programmes_dicsit\GUPTA\PROD"

[win32client.dll]
comdll=sqlws32
;comdll=sqlapipe

[win32client.apipe]
autostartserverpath="C:\Programmes_dicsit\Gupta\Prod\dbntsrv.exe"
serverpath=Prod

[win32client.ws32]
serverpath=Prod,localhost,2155/*


[dbntsrv]
ANSIJoinSyntax=1
dbdir=d:\sqlbase\Prod
servername=Prod,sqlws32
centurydefaultmode=1
cache=256107
oracleouterjoin=0
partitions=0
secureapi=0
DBNAME=xxx,SQLWS32
DBNAME=xxx,SQLWS32
DBNAME=xxx,SQLWS32
DBNAME=xxx,SQLWS32
[dbntsrv.gui]

[dbntsrv.dll]
comdll=sqlws32

[dbntsrv.ws32]
listenport=2155


here is %path%
Code: Select all
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Programmes_dicsit\GUPTA\PROD


see in attachement the screenshot of Dependency Walker for SQLWNTM.DLL


thank for your help
You do not have the required permissions to view the files attached to this post.
uliat
 
Posts: 28
Joined: Sun Mar 15, 2009 10:54 pm

Re: Unable to load SQLWNTM.dll with IIS on win2008 X64

Postby uliat » Tue Jul 21, 2009 11:07 pm

So
We do not often configure IIS, so we did not know this little useful configuration.

On IIS, in the configurations of application pool, you must set "Enable32bitAppOnWin64" to TRUE.
Take precautions if TS Web Access and TS Gateway are installed on your server.




ps : I have not seen anything about a 64 bit version of SQLBase.
is sqlbase 64 bit version exists ? If not, when this version will be published ?
uliat
 
Posts: 28
Joined: Sun Mar 15, 2009 10:54 pm


Return to Older Releases

Who is online

Users browsing this forum: No registered users and 0 guests