Andrew:

Thanks very much for the feedback.  I had read the README and tried those
but must have combined them incorrectly
the first time.  After some more experimentation, the following worked for me:

        "DRIVER={TSM ODBC
Driver};UID=admin;PWD=adminpassword;TCPADDR=myserver.company.com;TCPPORT=1500;FETCHSIZE=50"

Thanks again and best regards!

--PLB


At 06:03 PM 4/30/2004, Andrew Raibeck wrote:

Yes, you can call SQLDriverConnect() with a valid connection string. The
ODBC driver README file includes information on creating file DSNs. The
parameters discussed therein apply to the SQLDriverConnect() string as
well, and can be used to created DSN-less connection strings.

Example of a string:

   driver=tsm odbc
driver;uid=myadmin;tcpaddr=my.tsm.server.address;tcpport=1500;pwd=xxxxx

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Peter L. Buschman" <plblists AT iotk DOT com>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/29/2004 12:22
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
DSN-Less Connection String for TSM ODBC






Subject line says it all... anybody know how to properly format a
connection string for use with the TSM
ODBC driver so that you don't need to create a DSN beforehand?

--PLB