2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPrintShop Mail Connect

301

302

303

304

305

306

307

308

309

310

Table Of Contents

l

Connection string:Displaysthefullpathtothedatabase.

l

Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe

appropriatedataset.

l

Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe

table.

l

Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending

(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnum-

bers,itwillbesortedasatext.

3. ClickFinishtoopenthedatabase.

Microsoft Access

1. Entertheappropriateinformationtoconnecttothedatabase:

l

File name:BrowsetoyourMicrosoftAccessdatabasefile(.mdb,.accddb).

l

Password:Enterapasswordifoneisrequired.

2. ClickNextandentertheinformationforthesourcetable.

l

Connection string:Displaysthefullpathtothedatabase.

l

Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe

appropriatedataset.

l

Encoding:Usethedrop-downtoselecttheencodingwithwhichtoreadthedatainthe

table.

l

Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending

(Z-A)order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnum-

bers,itwillbesortedasatext.

3. ClickFinishtoopenthedatabase.

ODBC DataSource

1. SelecttheODBCsystemdatasource.Note:Only32-bitdatasourcesarecurrentlyshowninthis

dialog,evenifyoursystemis64-bits.

2. ClickNextandentertheinformationforthesourcetable.

l

Connection string:Displaysthefullpathtothedatabase.

l

Table:Usethedrop-downtoselecttheappropriatetableorstoredquerytoretrievethe

appropriatedataset.

Page 304