By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Proper Syntax for DSN-Less Connection

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.