Advantage in .net for VO developers – using OLE DB driver

Note: this is an old post I’m clearing from my draft queue dating from 2007.  I’m not sure it’s really relevant any more but what the heck.  I think Advantage are on version 10 now.

If you aren’t using Advantage 8 and need to use Advantage 7 you can still use it all from .net. You just need to use the OLE DB driver that they provide.

A sample connection string for the OLE DB provider is,

Provider=Advantage OLE DB Provider;
Data Source=c:\datapath;
ServerType=ADS_REMOTE_SERVER|ADS_LOCAL_SERVER;
TableType=ADS_CDX;CharType=ADS_OEM;
FilterOptions=RESPECT_WHEN_COUNTING;
TrimTrailingSpaces=True

The main difference between this and the .net data providers connection string is the server type.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s