Windows odbc manager11/18/2023 ![]() This new window contains all the ODBC drivers installed on your computer. Select the tab (“UserDSN” or “SystemDSN” depending on which type of links you want) and then click on the button. If you use “simple User DSN” inside a Windows Service, the ODBC connection will be refused inside Anatella because the user executing the Windows Service is not allowed to use “User DSN”. If you run some Anatella scripts as part of an automated Windows Service, you should rather create “System DSN’s”. This type of DSN’s are available to all users on this machine (including users running NT Services). The button is used to create a new DSN, Remove button is used to delete an existing DSN, and the Configure button is to reset the configuration of a DSN. Only the current user of this machine can see these DSN’s. ![]() This is the type of DSN that you will create for most of your applications. We should now see the standard “ Microsoft ODBC Administrator” window (This is nearly the same window for the 32-bit version and the 64-bit version of the “ Microsoft ODBC Administrator”): * To run the 32-bit “Microsoft ODBC Administrator” software (on a 64-bit Windows System), write “C:\Windows\SysWOW64\odbcad32” into the textbox and click the OK button: * To run the 64-bit “Microsoft ODBC Administrator” software, write “odbcad32” inside the textbox and click the OK button: Here is another procedure to run the “ Microsoft ODBC Administrator ”: Press the + keys simultaneously (the “Run” windows pops up) and then: If you are using Anatella 32-bit, you must use the 32-bit “Microsoft ODBC Administrator” software to define your ODBC DSN.ĭon’t worry: When you click the “ Open the MSWindow ODBC Manager ” button inside Anatella, the correct version of the “Microsoft ODBC Administrator” software appears automatically and there are no risks of errors. If you are using Anatella 64-bit, you must use the 64-bit “Microsoft ODBC Administrator” software to define your ODBC DSN. To add more confusion, these 2 different “Microsoft ODBC Administrator” software looks (nearly) exactly the same. When using a 64-bit Windows OS, there is a little “twist” related to the “Microsoft ODBC Administrator”: There are actually 2 completely different “Microsoft ODBC Administrator” software: one for 32 bit applications and one for 64 bit applications. The easiest way to run the “ Microsoft ODBC Administrator” is to click the “ Open the MSWindow ODBC Manager” button located at the bottom of the “ Manage OBC Connections” window: You’ll find additional information for the proper setup of an ODBC connection to an Oracle, Teradata, MySQL& Sybase database in the sections 5.1.6.3. The technique is the same for all the databases (Oracle, Teradata, SQL Server, My SQL, DB2, etc.). In the below example, we’ll create a “link” to access the content of a “MySQL database”. ![]() The first operation that you need to do when working with a “Type 1” ODBC datasource is to use the the “ Microsoft ODBC Administrator” to create a “link” (also named an “ODBC DSN”) toward the database that you want to use.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |