Connecting sybase thru ms-access odbc

[murali.kothuru]

Hi,



We are using ms-access ODBC to connect sybase. We are able to connect and able to access all the tables. surprisingly we are getting "Admin" failure attempts in sybase audit db whenever we execute queries in MS-Access design view. We verified there is no admin id is present in sybase db and we are using our own logins which are valid. Please help us in resolving this.
Thanks a lot.

Regards
Murali Kothuru

[pkstormy]

I'm guessing the tables are linked into the MSAccess mdb and that you checked the "Save Password" when linking the tables.

Have you tried editing the table itself versus via a query? If you still get an Admin failure, I might see if you can use a different type of ODBC driver. Perhaps the ODBC driver you're using isn't compatible.

If you don't get an error when editing the table, it might have something to do with the query itself. I'd try a very simple query (ie. no relational joined tables). I'm not versed in sybase so I couldn't say for sure.

[murali.kothuru]

I'm guessing the tables are linked into the MSAccess mdb and that you checked the "Save Password" when linking the tables.

Have you tried editing the table itself versus via a query? If you still get an Admin failure, I might see if you can use a different type of ODBC driver. Perhaps the ODBC driver you're using isn't compatible.

If you don't get an error when editing the table, it might have something to do with the query itself. I'd try a very simple query (ie. no relational joined tables). I'm not versed in sybase so I couldn't say for sure.

Save password is not highlited in ms-access. Yes we tried still we are getting failure attempts. Can you please elaborate regarding different ODBC driver. if i need to use another ODBC driver please let me know where i will get it. I am using 4.20.00.15 sybase ase driver. do i need to upgrade driver to 5.x. Please let me know where i will get it.
Regards
Murali Kothuru