However, I am unable to remove the "test" ODBC connections, nor configure new ones once they are created. I am able to connect to and read from the MySQL database. 2011 Licence Free OS Support Windows Downloads. As Jimmy said, the DSN definition would not be tied to the admin account, but would use whatever Windows Authentication account you were logged in as when using the connection later. The program works both with system DSNs and with user DSNs. Here is an example Command Prompt command: runas /netonly /user:domainadminusername 'C:WindowsSystem32odbcad32.exe'. The rest of this setup follows the same steps as Step 4 of Setting up an ODBC System Data Source Name (DSN). The 32-bit ODBC Data Source Administrator will appear: 4. The program allows you to export data source definitions into a file and then restore it on a local or remote system. In the Open: field enter 'C:\Windows\SysWow64\Odbcad32.exe': 3. What is truly odd is that the System DSN appears to work when creating a linked server within Microsoft SQL Server 2008 Management Studio. DTM ODBC Manager is a simple and easy-to-use ODBC Data Sources manager. The contents of the pop-up indicate: Errors Found: Invalid attribute string. However, once the System DSN is created, it can not be configured or removed.Ī pop up window appears titled: Driver's ConfisDSN, ConfigDriver, or ConfigTranslator failed I have configured the 32 bit ODBC Access drivers instead of the 64 bit drivers by running the ODBC driver setup page at: C:\Windows\SysWOW64\odbcad32.exe. I am now trying to run the application with Windows 7 64 bit. Via the ODBC Data Source Administrator I am able to create a System DSN that successfully "tests". This works fine on all 32 bit platforms from XP, Vista and I can easily configure and run it with ODBC. In both cases the installation appeared to complete without any problem. I've been installing the 11.2 version of Oracle, both the full package with ODBC and the instant-client with ODBC. Open the ODBC manager via: Control Panel > Administrative Tools > Data Sources (ODBC) Select 'File DSN'. The only driver showing in Reg: HKLM\Software\ODBC\ODBCINST.INI\ODBC Drivers is the default SQL server. On a Windows Server 2008 R2 system (Amazon EC2) I installed the 64-bit version of the MySQL Connector-OCBC 5.1.7 package using both the MSI Installer and the ZIP (no installer) archive. I have tried downloading both the 64bit and 32bit installation packages, and there is no change.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |