[Mono-list] ODBC/Mono/ASP Situation - Please Help

Tim Haynes thaynes@openlinksw.com (Tim Haynes)
Mon, 26 Jan 2004 10:11:48 +0000


Antwone Walters <awalters@integrity-apps.com> writes:

[snip]
> [iODBC][Driver Manager]Specified driver could not be loaded
> in <0x0049b> System.Data.Odbc.OdbcConnection:Open () in <0x0004f>
> (wrapper remoting-invoke-with-check)
> System.Data.Odbc.OdbcConnection:Open () in <0x00055>
> KTSearch.KTSimpleSearch:AddTableToDataSet
> (System.Data.DataSet,string,string) 

Could you check 

a) the environment variable ODBCINI is exported correctly, pointing to your
odbc.ini (or ~/.odbc.ini) file;

b) the DSN section has the Driver= line pointing to a valid shared library
(`/usr/lib/postgresql/lib/libodbcpsql.so', depending on however you
installed postgresql);

c) can you make a connection using iodbctest? Use `DSN=somedsn' as a
connect string?

Cheers,

~Tim
-- 
Product Development Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: <http://www.openlinksw.com>
Universal Data Access & Data Integration Technology Providers