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:35 (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. | + | In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. |
- | * Login to System5 | + | {{: |
- | * Go to Setup Wizard | + | |
- | * On the right side, click on ODBC button | + | |
- | {{: | + | OR |
+ | - go to Control Panel | ||
+ | - Administrative Tools | ||
+ | - ODBC Data Sources 32bit | ||
+ | - Then follow the steps above to create the DSN Database | ||
- | Switch to " | + | OR |
- | {{:systemdsn.jpg?500|}} | + | If you can't find the (32 bit) from the Control Panel\\ |
+ | Run "c:\Windows\SysWOW64\odbcad32.exe" | ||
- | Select the driver “Pervasive | + | Steps: |
- | {{:dsndriver.jpg?500|}} | + | - Once you have ODBC 32bit loaded |
+ | - Switch to " | ||
+ | - Click on " | ||
+ | - Scroll down and select " | ||
+ | - Click on " | ||
+ | {{:odbc32.jpg|}} | ||
- | Give the connection a name and click CREATE button below and leave everything else as is.\\ | + | 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 | ||
- | * Give the DSN a name | + | Under " |
- | * Enable “Long Metadata (V2 metadata) | + | * click on "Get list" button |
- | * Locate | + | * then from the drop-down selection box, select |
- | * Click OK button | + | * Then click on "OK" |
- | {{: | + | |
- | YOU"RE DONE!!! You will need to exit out of the Setup Wizard and back in to reload before you can see the connection you have just created. | ||
- | Now you can enable DSN as either Pervasive.SQL Database connection or Pervasive.SQL DSN-Less Connection. | ||
- | ---- | ||
- | ====== 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