- Pentium II 350 Mhz with SUSE LINUX 8,2, that works as database server.
- MaxDB 7,5,00,15 (database manager that has arisen from old SAP DB and that now they develop between SAP and MySQL).
- unixODBC 2,2,3-84 that settles when installing MaxDB.
The database manager MaxDB works and I have created a data base with him with tables and views.
What I want now is to form unixODBC to be able to accede from a page Web done with php, with which I must form ODBC locally since php is executed of the side of the servant. This is the configuration of the ODBC:
odbc.ini
[MAXDB_L] Description = MaxDB Driver = MaxDB ServerNode = localhost Server DB = BD_name
unixodbcinst.ini
[iSeries Access ODBC Driver] Description = iSeries Access for Linux ODBC Driver Driver = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so Setup = /opt/ibm/iSeriesAccess/lib/libcwbodbc.so Threading = 2 FileUsage = 1
[MaxDB] Description = MaxDB_Driver Driver = /opt/sdb/interfaces/odbc/lib/libsqlod.so Setup = /usr/lib/unixODBC/libsapdbS.so FileUsage = 1 CPTimeout = CPReuse =
[ODBC] Trace = No TraceFile = /tmp/sql.log ForceTrace = No Pooling = No
These two archives (that are in/etc/unixODBC) have their corresponding soft link in certain sites where they are necessary: /etc, /home/usuario... And when doing a test of operation from LINUX with the commando isql I obtain the following thing:
isql MAXDB_L usuario pass -v
[unixODBC][MySQL MaxDB][LIBSQLOD SO] Unable to connect to data source;-709 CONNECT: <unknown host localhost <see /etc/hosts>>
[ISQL]ERROR: Could not SQLConnect
That is, that does not connect because of that does not recognize the machine "localhost" that defines in the file "odbc.ini". Then, I have proven to put in ServerNode instead of localhost the IP of the machine in particular, IP 127,0,0,1, the name of the machine as so... and of no of the ways it connects to me (if instead of localhost I put 127,0,0,1 appears to me the same error but replacing localhost by 127,0,0,1). Also I have not proven to let the ServerNode field to emptiness be the local connection, but either.
In case it serves already as aid I have placed a variable in profile of the managing user of the data base (and that takes it) to assume a older Kernel and than it works well (this I have observed it of other forums):
export LD_ASSUME_KERNEL=2.2.5
But it does not work to me either. I have also observed the file/etc/hosts and has the following thing:
# special IPv6 addresses ::1 localhost ipv6-localhost ipv6-loopback
fe00::0 ipv6-localnet
ff00::0 ipv6-mcastprefix ff02::1 ipv6-allnodes ff02::2 ipv6-allrouters ff02::3 ipv6-allhosts
127.0.0.1 localhost 192.168.0.195 apache.local apache
That it does not seem to me that has nothing rare. Then, I believe that I have exhausted all the possibilities after visiting lists of post office in the official page of MaxDB and forums by all sides. To see if they alquien me it can help please since he is urgent. Thank you very much beforehand.
_________________________________________________________________
La informaci�n m�s fresca desde diferentes puntos de vista en la Revista de Prensa de MSN. http://es.newsbot.msn.com/
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
