ODBC connection failes as dstage group user

[ramesh_dw]

Hi Guys,

I am trying to configure a MYSQL ODBC connection using a mysql library ( libmyodbc3-3.51.23.so) that comes in the unix installation.

After configuring the connection, I was able to connect to the database as dsadm. When I try to connect as some other user in dstage group. I get the following error.

Can you guys help me resolve this issue?

Thanks in advance.


Attempt using dsadm user

>DS_CONNECT BI-SOURCE02
Enter username for connecting to 'BI-SOURCE02' DBMS [dsadm]: bi_user
Enter password for bi_user:
BI-SOURCE02> select 1;
1
----------
1

1 row selected

Attempt using dstage group user

>LOGTO ALPS-V2
>DS_CONNECT BI-SOURCE02
Enter username for connecting to 'BI-SOURCE02' DBMS [adchemy]: bi_user
Enter password for bi_user:
SQLConnect error: Status = -1 SQLState = 08S01 Natcode = 2002
[ODBC:2002] [unixODBC][MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[ray.wurlod]

What are the permissions on /tmp ?

[ramesh_dw]

What are the permissions on /tmp ? ...

Here are the permissions on /tmp
drwxrwxrwt 8 root root 4096 Apr 10 15:13 tmp