Netware, ODBC and ASP !

[Meander365]

Hi,

Im trying to get some data from an Access 2000 database that's stored on a Novell Netware Server 5.1 running TCP/IP. Im using a Windows2000 machine as a local web server, so the idea is to grab the data from the database and display in ASP via ODBC. Except, it doesnt work.

I've set up the DSN to be the following. I've called it iminore1:=
------------------------------
\\novellservername\myfolder\database.mdb

And here's the ASP code :=
------------------------------
Dim dbConn, dbSQL, PWebRS, SubjRS

set dbConn=Server.CreateObject("ADODB.Connection&quot
call dbConn.Open ("iminore1","","&quot
set session("iminore1_dbConn&quot = dbConn

dbSQL="select * from PenWebParms"
set PWebRS=Server.CreateObject("ADODB.Recordset&quot
call PWebRS.Open(dbSQL, dbConn)
call PWebRS.MoveFirst()
...

When I open the page I get Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] '\\novellservername\myfolder\database.mdb' is not a valid path.

I have another ms access database stored my Windows2000 machine and can grab data via ODBC and ASP from that - no problem! So I know ASP and ODBC work OK.

But I can't seem to access the datasource from the novell server ??!

Any ideas ???

Thanks,

Meander365 !

 

[robrichardson]

I had the same problems and this worked:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q178045&GSSNB=1

Let me know how you get on

Rob

 

[JaseUK]

Mapping the UNC path to a network drive will always solve this problem!

 

[robrichardson]

Reply to above

Not with a netware server. You'll get "disk/network error". Gateway services for Netware is required, a NTGATEWAY account must be created on both servers and a share must be created within GSNW Control Panel.

 

[JaseUK]

Hosting the database on a server across a network is not recommended as a bottleneck will almost certainly occur when the ODBC tries to access the data (at least for the first time - caching and connection pooling may help out later). If you are looking for HIGH performance, put the database on the same machine that has the ODBC source on it and provide access for network users the other way around (eg: They look to the Windows machine not the Netware one).

 

[Meander365]

Thanks for your help on this one - it's now all working !

The root of the problem was that I was running it under windows 2000 professional and not server. So, I transferred the ASP pages over to an NT Server (setting up the IIS). I then loaded the latest MS Data access components (2.6) and also Jet 4.0 service pack 3 - all available from

http://www.microsoft.com/data.

I then followed the instructions from the following ms-support page as recommended by robrichardson (thanks!) :-

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q178045&GSSNB=1

And it all works now ! However, worth to note that it's quite slow even though our network is running at 100Mbps. I think it's due to the problems highlighted JaseUK.

Anyway, thanks all again!

;-) Meander365...