AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Easysoft Data Access How can I create an ODBC data source on Windows without using ODBC Administrator Article: 01084 Last Reviewed: 1st September 2016 Revision: 2.The other data source creation methods that are listed in this article cause ODBC configuration dialogs boxes to display.
These dialog boxes may also be affected by the same issue that is preventing you from using ODBC Administrator to add a data source. System ODBC data sources are stored in HKEYLOCALMACHINESOFTWAREODBCODBC.INI. User ODBC data sources are stored in HKEYCURRENTUSERSoftwareODBCODBC.INI. This shows the contents of a.reg file, that if imported into the registry would create a System data source for the MongDB ODBC driver. Edit Hkey Local Hine Without Admin Rights Drivers From OtherYou will need to alter it for ODBC drivers from other vendors (i.e. Refer to the documentation for your ODBC driver for further information). On 64-bit Windows, System data sources for 32-bit ODBC drivers are stored in HKEYLOCALMACHINESOFTWAREWow6432NodeODBCODBC.INI. Edit Hkey Local Hine Without Admin Rights Install And ConfigureUse ODBCConf. ODBCConf is a Windows command line utility that enables you to install and configure ODBC drivers and configure ODBC data sources. Example: Creating a System ODBC Data Source odbcconf A CONFIGSYSDSN Easysoft Salesforce ODBC Driver DSNSalesforce System DSNUIDmynamemydomainPWDp455w0rdTokenA1B2cDefG3HijKlMNOPQRS45 Example: Creating a 32-bit System ODBC Data Source on 64-bit Windows WINDIRSysWOW64odbcconf A CONFIGSYSDSN Easysoft ODBC-Derby Driver DSN32-bit Derby System DSNServerlocalhostDatabaseseconddb Use ODBC Test. ODBC Test, which is included in the Microsoft Data Access Components (MDAC) 2.8 Software Development Kit, provides a graphical way to run ODBC API calls. To create an ODBC data source from ODBC Test, on the Installer menu, choose Data Sources and then choose SQLConfigDataSource. The following example values are for Easysofts Salesforce ODBC driver: fRequest ODBCADDDSN lpszDriver Easysoft Salesforce ODBC Driver lpszAttributes DSNSalesforce User DSN;UIDmynamemydomain;PWDp455w0rd;TOKENA1B2cDefG3HijKlMNOPQRS45 For Windows 8 and later, use Windows PowerShell Cmdlets for ODBC. Windows PowerShell is a command-linescripting environment from Microsoft. Built-in Windows PowerShell commands, called cmdlets, enable users to control and automate the administration of the Windows operating system and applications that run on Windows. Starting in Windows 8, a number of PowerShell cmdlets are provided for listing and managing ODBC drivers and data sources. This sample cmdlet adds a 64-bit System ODBC data source for Easysofts Derby ODBC driver. PS C: Add-OdbcDsn 64-bit Derby System DSN -DriverName Easysoft ODBC-Derby Driver. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
0 Comments
Read More
Leave a Reply. |