Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Thu, May 29 2008 11:50 PM	Permanent Link
"Al Vas"	Hi, We have been developing a web-based portal in Visual Studio that reads DBISAM data through ODBC driver. Its worked fine in our testing on local PCs and Windows erver 2003 but now we are ready to beta tset and have installed at a client with Windows Server 2000. When we first tried to connect it mentioned that the MDAC version needed to be upgraded (was 2.5x but needed to be at least 2.6). We did this and that message has disappeared but we still cant get database connection. The error we are getting is: 'Using Microsoft DataReader and Command Object MDOconnectionString: DSN=WebAllocationsOdbc Exception Caught in adc.getSettings():=Microsoft.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be loaded due to system error 5 (DBISAM 3 ODBC Driver). at Microsoft.Data.Odbc.OdbcConnection.Open()' Any idea what the system err 5 is? Could it be security issues? Any guidelines on the setup. It is as mentioned a windows 2000 server and we have not experienced this issue in tests on client o/ses or windows 2003. Help appreciated Alex
Fri, May 30 2008 7:28 AM	Permanent Link
Jan Ferguson Data Software Solutions, Inc. Team Elevate	Al, A " System error 5" is an access error (see http://support.microsoft.com/kb/555644). From what you describe it seems like one of the two possibilities listed below can be causing you to receive this error. * Missing permission to access the remote computer (Share, NTFS, GPO). * Firewall and/or third party product may eliminate connection to the remote computer. There are numerous cases of the same error you are receiving with other RDBMS's like Oracle, DB2, Sybase and others. Some of the research I've seen points to disabling anonymous access in IIS as well as impersonating the user in Web.config to resolve the issue. Hope this puts you on the right track to solving your issue. -- Regards, Jan Ferguson [Team Elevate] Al Vas wrote: <<Any idea what the system err 5 is? Could it be security issues? Any <<guidelines on the setup. It is as mentioned a windows 2000 server <<and we have not experienced this issue in tests on client o/ses or <<windows 2003.