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)
ODBC connection failes as dstage group user
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: