Linking to Advantage database

[Guest]

Hi;

I am trying to, in code, link to an Advantage database using Access
2003. I try to setup a current connection along the lines of:

With CurrConect
.Provider = "Microsoft SQL Server ODBC "
.ConnectionString = "data source = MyDataSource "; user id = IDNAME;
password = PASSWORD"
..Open

The error message is: Provider is unknown or not installed

I've used "Microsoft SQL Server ODBC" before without problem. Has anyone out
there successfully linked to an Advantage Database before?

Thanks
Dale

 

[Ron Weiner]

You might want to motor over to http://www.connectionstrings.com/ and peruse
the site. This is probably the best place on the web to find ADO connection
strings for the most popular and obscure data sources.

Ron W
www.WorksRite.com