it haves nothing to do with working at your machine with your connect string.
We have 5 database machines using the same scripts (around 300) for dataloads, dataconverting a.s.o. via nfs.
Our Webservers connecting to these database machines (Apache,php).
We have 2 database machines that are doing big dataloads for 5 times per day (more than 10GB). If the first is loading the webservers are switched to the second database machine.
Tell me how to do without odbc.ini.
So i can't use a connect string like:
ODBC_CONNECT("localhost:TST","user","password");Our connect string is like this:
ODBC_CONNECT("TST","user","password");if no host is given libsqlod.so in previous versions of MAXDB 7.5.08 is using the /usr/spool/sql/ini/odbc.ini.
In the odbc.ini of each machine i can define the ip-adresses as needed for the machine.
So we have to use the odbc.ini and i need a description what has changed or a fix.
regards
Albert
Jean-Michel OLTRA schrieb:
Le samedi 31 janvier 2004, Albert Steckenborn a écrit... bonjour,
ODBC_CONNECT("<IP>:<DB>","<user>","<password"); is working Can't use the previous one because machines are changing from time to time.
ODBC_CONNECT("<DB>","<user>","<password"); fails with following message: PHP Warning: odbc_connect(): SQL error: [MySQL MaxDB][LIBSQLOD SO] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in conntest.php
I used this syntax, which _was_ working, with SapDB 7.4.3.17
$dsn="DSNName"; $conn_id = odbc_connect ($dsn, "user", "passwd") or die ("odbc_connect(): erreur\n");
and had no DSN field in /nonexistent/.odbc.ini[DB1] DSN = 192.168.1.2:DB1 SERVERDB = DB1 SERVER = db_server1 SERVERNODE = 192.168.1.2
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
