how to create dsn on windows 7
DESCRIPTION
HOW TO CREATE DSN ON WINDOWS 7. Step 1. Click Start. Step 2. Click Control Panel. Step 3. Double-click Administrative Tools. Step 4. Double-click Data Sources (ODBC). Step 5. Click System DSN. Step 6. Click Add. Step 7. Scroll down. Step 8. Double-click MySQL ODBC 3.51 Driver. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/1.jpg)
HOW TO CREATE DSN ON
WINDOWS 7
![Page 2: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/2.jpg)
Step 1. Click Start
Step 2. Click Control Panel
![Page 3: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/3.jpg)
Step 3. Double-click Administrative Tools
![Page 4: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/4.jpg)
Step 4. Double-click Data Sources (ODBC)
Step 5. Click System DSN
![Page 5: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/5.jpg)
Step 6. Click Add
Step 8. Double-click MySQL ODBC 3.51 Driver
Step 7. Scroll down
![Page 6: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/6.jpg)
Step 9. Input Data Source Name = dsnPOS. Server = localhost. User = root. Database = tanaytech.
Step 10. Click dropdown
Step 11. Select tanaytech.
![Page 7: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/7.jpg)
Step 12. Click Connect Options
Step 13. Input 3306
Step 14. Click Advanced
Step 15. Check Don’t Optimize Column Width. Check Returns Matching Rows. Check Allow Big Results. Check Use Compressed Protocol. Click OK.
![Page 8: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/8.jpg)
Step 16. Click Test
Step 17. Click OK
![Page 9: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/9.jpg)
Create ODBC for Windows 7 – Create dsnPOS ODBC manually. Click Start. Click Control Panel. Click System and Security. Click Administative Tools. Double click Data Sources (ODBC). Click System DSN. Click Add. Select MySQL ODBC 3.51 Drive. Data Source Name = dsnPOS. Server = localhost. User = root. Database = tanaytech. Click Connection Option. Port = 3306. Click Advanced. Click Flags1. Check Don’t Optimize Columnd Widht. Check Returns Matchin Rows. Check Allow Big Results. Check Use Compressed Protocol. Click OK.Note : %windir%\SysWOW64\odbcad32.exe
![Page 10: HOW TO CREATE DSN ON WINDOWS 7](https://reader036.vdocuments.us/reader036/viewer/2022062423/568142df550346895daf3cde/html5/thumbnails/10.jpg)
THANK YOU!
www.tanaytechnologies.comDate created : 03-07-2012