Proper Syntax for DSN-Less Connection

[Kevin]

I am currently importing data into Access 2002 from 3 Sybase ASA 7.0
databases over a network. At this time I am using a ODBC System DSN
connection using the proper ASA 7 driver. I would like to be able to
make a DSN-Less connection so that my software is not dependent on
having ODBC set-up with proper drivers and information.

I have done hours of searching/testing but have been unsuccessful at
making a DSN-Less connection. Could someone please help me with the
proper syntax?!?!

I am using ADO.
The Sybase DBs requires a User and Password to log in.
My actual call is Executing a SQL INSERT INTO statement.
This is a network call.

[Pieter Linden]

Go to Carl Prothman's site. He has examples of just about every kind
of connection one can make through ADO.

http://www.able-consulting.com/MDAC/...BC_DSNLess.htm

[Kevin]

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

Go to Carl Prothman's site. He has examples of just about every kind
of connection one can make through ADO.

http://www.able-consulting.com/MDAC/...BC_DSNLess.htm

Thanks for the link, I had already stumbled onto Carl's site while
searching on Google. I think I have found the answer at this link
http://www.sybase.com/detail/1,6904,1013782,00.html. I also answered
another question which was whether the ASA 7.0 Driver is required to
connect to the SQL Anywhere Database, it is. Using ODBC connections
is new to me but I think I finally am getting a grasp of the process!