Sybase SQL Anywhere

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are running Sybase SQL Anywhere. I have been using Infomaker for simple reports. I was told that Access is a much better alternative. How do you connect to database with Access 2003?
 
I would first create a DSN (ODBC datasource). You can then point to this DSN
when select to link tables. A great method of connecting to external data is
with Pass-Through queries. You can specify a DSN when building a connection
string within the P-T.

--
Duane Hookom
MS Access MVP


Michael said:
We are running Sybase SQL Anywhere. I have been using Infomaker for
Click to expand...
simple reports. I was told that Access is a much better alternative. How
do you connect to database with Access 2003?
 
You will, of course, need ODBC drivers for Sybase SQL Anywhere. When I last
observed someone set up Access and SQL Anywhere (1996, I believe) they were
using third-party ODBC drivers (possibly because they'd used them on other
combinations of Access and server databases with some success). The drivers
used were InterSolv, but I believe the company name has changed.

It's possible that there are ODBC drivers included with Sybase SQL Anywhere.
I'd make it my first order of business to determine if there are.

Larry Linson
Microsoft Access MVP
 
Back
Top