create_dsn_database_through_odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
create_dsn_database_through_odbc [2016/03/03 16:12 (8 years ago)] – [Another way of doing this is through CONTROL PANEL] fgabiana | create_dsn_database_through_odbc [2019/01/09 11:37 (5 years ago)] – fgabiana | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Create a DSN via ODBC ====== | + | ====== Create a DSN via ODBC32 bit ====== |
- | <note tip>A way of creating | + | <note important> |
+ | <note tip>This is a Windows 10 & PSQL V12 compatible. This is an updated version of the article and the old one had been overwritten.</ | ||
- | Make sure you are at the server with Administrative Rights. | + | ===== This setup or steps is done from the Client Workstation ===== |
- | * Login to System5 | + | |
- | * Go to Setup Wizard / Network Settings / Pervasive.SQL Database | + | |
- | * On the right side, click on ODBC button | + | |
- | {{: | ||
- | Switch | + | In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. |
- | {{:systemdsn.jpg?500|}} | + | {{:odbc32-2.jpg|}} |
- | Select the driver “Pervasive | + | OR |
- | {{: | + | - go to Control Panel |
+ | - Administrative Tools | ||
+ | - ODBC Data Sources 32bit | ||
+ | - Then follow the steps above to create the DSN Database | ||
- | Give the connection a name and click CREATE button below and leave everything else as is.\\ | + | OR |
- | {{:liveconnection.jpg? | + | If you can't find the (32 bit) from the Control Panel\\ |
- | < | + | Run "c:\Windows\SysWOW64\odbcad32.exe" |
- | * Give the DSN a name | + | Steps: |
- | | + | - Once you have ODBC 32bit loaded |
- | | + | - Switch to " |
- | | + | |
- | {{:dsnname.jpg?500|}} | + | |
+ | | ||
+ | {{:odbc32.jpg|}} | ||
- | YOU"RE DONE!!! | + | You will then get the Window above |
+ | * Data Source Name = the actual DSN name you create in PCC. This must be the same name | ||
+ | * Description = leave it as is | ||
+ | * Server Name/IP = is either the Server HostName or IP Address | ||
+ | * Transport Hint = leave it as is | ||
- | Now you can enable DSN as either Pervasive.SQL | + | Under "Database |
+ | * click on "Get list" button | ||
+ | * then from the drop-down selection box, select the DSN Database you create via PCC | ||
+ | * Then click on " | ||
- | ---- | ||
- | ====== Another way of doing this is through CONTROL PANEL ====== | ||
- | - go to Control Panel | ||
- | - Administrative Tools | ||
- | - ODBC Data Sources (32/64) bit | ||
- | - Then follow the steps above to create the DSN Database | ||
- | |||
- | Or if you can't fine the (32 bit) from the Control Panel\\ | ||
- | Run " |
create_dsn_database_through_odbc.txt · Last modified: 2021/07/07 16:43 (3 years ago) by jege