[E2ESolutions/AOAISearchDemo] Missing prerequisites in documentation

[renepajta]

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [X] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

git clone
cd openai/End_to_end_Solutions/AOAISearchDemo
azd auth login --tenant-id
azd up

Any log messages given by the failure

Running "populate_sql.py"
Connecting to SQL Server
Traceback (most recent call last):
File ".\AOAISearchDemo\End_to_end_Solutions\AOAISearchDemo\scripts\prepopulate\populate_sql.py", line 15, in
cnxn = pyodbc.connect(args.sql_connection_string)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

Expected/desired behavior

The azd up finishes successfully. Documentation is missing prerequisites for latest ODBC Driver. I had ODBC v17 but it couldn't find it as SQL connection string was expectign ODBC v18

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)
Windows 11

Versions

Mention any other details that might be useful

---

Thanks! We'll be in touch soon.