Hi all, I'm trying to link to a TSM DB using ADO through TSM ODBC driver. When I'm linking a TSM table into Access, everything works perfectly well and I get prompted for the UserID/Password pair. On the other hand, when using Microsoft ADO (ActiveX Data Objects) I get a "Catastrophic error" when I open the connection. The problem, IMHO, is that the UID/PWD is not sent (properly or at all) pair when the connection is made. I defined a system DSN named "TSM Database". The server & the client ODBC app' are on the same Win2000 (pro) machine. ADO is version 2.5 on Windows 2000 pro. I used several ways to transmit the UserID/password pair when opening the connection (i.e. typing them in a file DSN or using them when opening with ADO) but I always get an error (either "catastrophic" or "undefined" errors). What I'd like to do is provide the UID/PWD pair in a form and make a silent connection to TSM using ODBC. I can create an Access DB that is linked to TSM DB but I'm prompted for TSM Server ODBC identification when I open the connection... How can I do or what's wrong ? Thanks in advance, Vince
