Hi, Have you set the value of LD_LIBRARY_PATH? Have you installed an ODBC driver manager as well as an ODBC driver? Try to you connect to the DB using 'odbctest', a provided test program, before you attempt your make. Have you defined top_srcdir via 'configure?
Pete -----Original Message----- From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 7:38 AM To: Levine, Peter W Subject: RE: Error while running odbctest thanks really for supporting me .. Can u just tell me the Driver manager and its installation procedure.. I will tell u what i did .. 1. Driver (Openlinksw single-Tier Driver for SQLserver): installation info: It installed the driver janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/lib> l total 2514 -rwxr-xr-x 1 janarthp staff 775 Sep 13 01:54 sql_st_lt.la -rwxr-xr-x 1 janarthp staff 1277520 Sep 13 01:54 sql_st_lt.so janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/lib> cd ../bin/ janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/bin> l total 150 -rw-r--r-- 1 janarthp staff 1516 Sep 17 15:45 freetds.conf -rw-r--r-- 1 janarthp staff 1413 Sep 13 01:54 freetds.conf.sample -rwxr-xr-x 1 janarthp staff 53848 Sep 13 01:54 inifile -rw-r--r-- 1 janarthp staff 1245 Sep 17 15:46 odbc.ini -rw-r--r-- 1 janarthp staff 476 Sep 13 01:54 odbc.ini.sample -rw-r--r-- 1 janarthp staff 728 Sep 17 15:29 odbcinst.ini -rw-r--r-- 1 janarthp staff 478 Sep 13 01:54 odbcinst.ini.sample -rw-r--r-- 1 janarthp staff 6172 Sep 17 15:50 openlink.ini -rw-r--r-- 1 janarthp staff 5662 Sep 13 01:54 openlink.ini.sample I got the driver as listed above at lib directory and entries are made in to the odbc.ini file. All the required setenv has been done. 2. Driver Manager (iODBC from www.iodbc.org (libiodbc-3.0.6)) Installation Info: To install this I ran the Following command as given in its Documentations a. ./configure --prefix=/u/janarthp --with-iodbc-inidir=/u/janarthp/Tar/ODBC/Single-Tier/lite/bin * here i give the odbc location as the location of the odbc.ini file i got after installing the driver. b. make c. make install It got installed. 3. DBD:ODBC (0.45.x) Installation info: ran makefile.PL and installed at /u/janarthp/Tar/ODBC/DBD_ODBC/DBD I have set the Env_variables DBI_DSN , DBI_USER , DBI_PASS as 'gel(as defined in the odbc.ini file of the driver)' , 'sa' , '' ( Database is a SQL.) My basic doubt arised here: should i ran the makefile.PL with ODBCHOME variable set? I did it but gave some error like this when i tested with a Perl script. error: install_driver(ODBC) failed: Can't locate loadable object for module DBD::ODBC in @INC (@INC contains: /u/janarthp/Tar/ODBC/DBD_ODBC /usr/local/lib/perl5/5.6.1/sun4-solaris /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl /prod/tools/packages/lib/perl5/5.6.1/sun4-solaris /prod/tools/packages/lib/perl5/5.6.1 /prod/tools/packages/lib/perl5 .) at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a module that DBD::ODBC requires hasn't been fully installed at test.pl line 6 Please clear me out here. Also i need to know as how there is a link between all these three components. what i understood while installing is: driver-->($driver/bin/odbc.ini) -- > Driver Manager (ODBCHOME= $iODBC_location) ---> DBD:ODBC -- > (used by perl) [Is this what the happenings inside ] As it is telling that it couldn't load the perl module (included it in the @INC also), i don;t think that DBD:ODBC is having any problem. help needed... thanks, Prassana -----Original Message----- From: Levine, Peter W [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:03 PM To: Janarthanan, Prasanna Subject: RE: Error while running odbctest It worked for me connecting to MS SQL server. I found their tech support to be very helpful. Pete -----Original Message----- From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:27 AM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: Error while running odbctest Ya, iam not getting any reply from their technical support. I thought that someone else in this group also wud have experienced this. Was anyone successful in using the iODCB manager with single tier lite driver? help! thanks Prassana -----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:48 PM To: Janarthanan, Prasanna; [EMAIL PROTECTED] Subject: RE: Error while running odbctest I suggest you talk to OpenLink directly regarding this. (That is, if this is still the openlink driver that you mentioned you were using in prior e-mails). Regards, Jeff > > After installing the Single-Tier lite driver and iODBC , i get error while > running odbctest. > > Error: > > janarthp@sys1:/u/janarthp/Tar/iODBC/bin> odbctest > iODBC Demonstration program > This program shows an interactive SQL processor > > Enter ODBC connect string (? shows list): DSN=gel > [iODBC][Driver Manager]Specified driver could not be loaded, > SQLSTATE=IM003 > [iODBC][Driver Manager]ld.so.1: odbctest: fatal: > /tmp_mnt/home/hyd/fs1/u5/janarthp/Tar/Single-Tier/lib/sql_st_lt.so: open > failed: No such file or directory, SQLSTATE=00000 > > Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin> > janarthp@sys1:/u/janarthp/Tar/iODBC/bin> > > I have the 'gel' entry in the odbc.ini file which points to the NTmachime > having the database. Also i have sql_lt.lic (eval licence) put in the bin > directory of the driver. > > if i try puting the username and password in the existing DSN > (sql_lite), it > gives me another error telling... > > Error: > > janarthp@sys1:/u/janarthp/Tar/iODBC/bin> odbctest > iODBC Demonstration program > This program shows an interactive SQL processor > > Enter ODBC connect string (? shows list): DSN=sql_lite > > Wed Sep 18 2002 > 16:12:58 ERROR: No valid license was found > 16:12:58 ERROR: Please contact OpenLink Customer Support > [OpenLink][ODBC][Driver]No valid license was found, SQLSTATE=08004 > > Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin> > > what could be the reason for this. > > help! > > > thanks > Prassana >