Linking to Advantage database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TnCoder - 29 Jul 2005 13:42 GMT

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

Reply to this Message

Ron Weiner - 29 Jul 2005 14:09 GMT

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

> Hi;
>
[quoted text clipped - 14 lines]
> Thanks
> Dale

Reply to this Message