OK one last time.....
All discussions regarding beta releases of the Witango 5 Server of Dev
Studio must take place on the betatest-talk list. This is to stop the
potential noise that is associated with beta testing software ending up in
the mailbox of people that are not on the beta program.
Questions about the beta versions will not be answered on the Witango-Talk
list. Witango-talk is for discussion of release product only.
Regards
Phil
On 10/11/02 4:46 PM, "John Newsom" <[EMAIL PROTECTED]> wrote:
> 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
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
