Witango-Talk: adventures in iODBC land

[John Newsom]

I have followed all the different directions as best I can, and was finally able to create a taf which accessed mysql using iODBC.

What I have learned:

1. using printenv, saw that the HOME environment variable was set to my home directory

2. created datasources with the ODBC administrator, one in /library/odbc and one in ~/library/odbc along with links from the dot odbc.ini to the library files

[12-228-192-2:/library/odbc] newsomj% ls -al
-rw-rw-r-- 1 root admin 483 Nov 9 06:00 odbc.ini

[12-228-192-2:/library/odbc] newsomj% ls -al /var/root
lrwxr-x--- 1 root wheel 22 Nov 8 21:56 .odbc.ini -> /library/odbc/odbc.ini

[12-228-192-2:~] newsomj% ls -alf
lrwxr-xr-x 1 newsomj staff 21 Nov 9 06:46 .odbc.ini -> library/odbc/odbc.ini

[12-228-192-2:~] newsomj% ls -al library/odbc/
-rw-r--r-- 1 newsomj staff 408 Nov 9 06:05 odbc.ini

I played around with creating links from /var/root to the user datasource to avoid having to edit two files, but that didn't work. The system data source stopped working altogether, and I tried defining two drivers in the ODBC administrator, one for user and one for system, both using the same /usr/lib/libodbcmy.dylib. But as of now, after 3 hours of trying different combinations, the user data source works when Tango server is running under the current user, but the system datasource does not work when Tango server is running as system. Here are my two odbc.ini files,

system:

[ODBC Data Sources]
test = mysql

[test]
Description = try with system driver
database = test
server = localhost
port = 3306
driver = /usr/lib/libodbcmy.dylib

user:

[ODBC Data Sources]
test = usermysql

[ODBC]
Trace = 0
TraceAutoStop = 0
TraceFile =
TraceLibrary =


[test]
Driver = /usr/lib/libodbcmy.dylib
Description = try with user driver
database = test
port = 3306
server = localhost



3. As pointed out, I have discovered that if the server is running as a system daemon, the studio needs the datasource in the user's directory.

It is easier to use a unix editor to make the data source files than to use the ODBC administrator, which complains when you create a user and a system datasource with the same name.

Questions:

1. Is there a way to set up the environment so that the studio can use a system datasource? Or set up the server so it can use a user datasource when running as system?

2. What have I done wrong with the server in system mode?

Thanks,

John Newsom

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body