The property .ConnectionString must always be set if connecting directly to a database.

It must be a valid OLE DB provider connection string.

Examples

• Microsoft Access: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Access\NWind.mdb"
• Microsoft SQL Server: "Provider=sqloledb;Data Source=127.0.0.0;Initial Catalog=Northwind;User Id=MyUserId;Password=MyPassword"
• Oracle: "Provider=OraOLEDB.Oracle;Data Source=serverName;User id=MyUserId;Password=MyPassword"

Good sources on the Web

Consult these web sites for an extensive coverage of OleDb connection strings.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbConnectionClassConnectionStringTopic.asp

http://www.connectionstrings.com/

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm

Remarks

Internally, AxpDataGrid use the .NET class OleDbConnection. This connection is created and available through the property AxConnection.Connection. It is created when the AxpDataGrid.ConnectionString is set.

See Also

AxpDataGrid Tutorial

---