{"id":2397,"date":"2014-12-18T22:16:29","date_gmt":"2014-12-18T22:16:29","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2397"},"modified":"2014-12-18T22:19:24","modified_gmt":"2014-12-18T22:19:24","slug":"creating-a-file-dsn-for-minisofts-odbc-driver-2","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/creating-a-file-dsn-for-minisofts-odbc-driver-2\/","title":{"rendered":"Creating a File DSN for Minisoft’s ODBC Driver"},"content":{"rendered":"

The parameters in the standalone DSN table are also used in JDBC.<\/p>\n

\n

<\/a>Creating a File DSN based on an existing DSN<\/strong><\/h4>\n

You must create a File DSN if you are using either MSExcel or MSQuery as your client application. On the other hand File DSNs are not needed for Server Release of MSOffice.<\/p>\n

If you have already created a User or System DSN you can create a File DSN in one of these ways.<\/p>\n

\n

The first method being in the directory, indicated by the ‘options’ button in the Choose Data Source dialog; you can create a two line text file that contains:<\/p>\n

[ODBC]
\nDSN=yourdatasource<\/code><\/p>\n

The name of the file should be (yourdatasource.DSN). This file is created by following the next set of instructions. The value of yourdatasource on the line that begins with DSN, should be your existing User or System DSN.<\/p>\n

\n

Alternately, you can let MSQuery create the file DSN:<\/p>\n

    \n
  1. In the Choose Data Source dialog box select <New Data Source> under the Databases tab. Then click OK.
    \n    \"ODBC_y02\"<\/a><\/li>\n
  2. \u00a0The Create New Data Source dialog box will appear. Enter the name you want to give your data source. Select the HP e3000 Data Access Driver, then press Connect.
    \n    \"ODBC_y02\"<\/a><\/li>\n
  3. \u00a0Minisoft’s HP e3000 Data Access ODBC Driver dialog box will appear. Under the Connection tab enter your valid login information, then click OK.<\/li>\n
  4. \"dsn3\"<\/li>\n
  5. \u00a0An error message will then appear, click OK.<\/li>\n
  6. \u00a0Press the Connect button a second time in the Create New Data Source dialog box.<\/li>\n
  7. \"ODBC_Y02a\"<\/li>\n
  8. \u00a0The Select Data Source dialog box will appear.\u00a0 Under the Machine Data Source tab select your data source name, then click OK.<\/li>\n
  9. \"dsn6\"<\/li>\n
  10. \u00a0Click OK again when Minisoft’s HP e3000 Data Access ODBC Driver dialog box appears.<\/li>\n
  11. \u00a0In the Create New Data Source dialog box you should now see the name of your User or System DSN listed next to the connect button. Click OK.
    \n\"dsn7\"<\/li>\n
  12. \u00a0Your File DSN will now appear in the list of available file DSNs.<\/li>\n<\/ol>\n

    \"ODBC_Y08a\"<\/a><\/p>\n

    \n

    <\/a>Create a Standalone File DSN.<\/strong><\/h4>\n

    You can create a File DSN for your users so they will not need to learn the ODBC Administrator. The information entered in a File DSN is the same general information that would be entered when creating a User or System DSN in the ODBC\/32 Administrator. You can specify these same parameters in a FILE DSN (Connection Parameters<\/a>).<\/p>\n

    \n

    Following is an example of a File DSN that includes connection, database and table information.<\/strong><\/p>\n

    [ODBC]
    \n2DriverTable=
    \nDRIVER=HP3000 Data Access Driver
    \nDescription=Access the Demo Database
    \nDatabase0=MSDB.DEMO.MINISOFT,WRITER,N,0
    \n2HostTable=Customers
    \nServer=000.000.000.000
    \nServer Port=30006
    \nJobname=MSJOB
    \nUser=mgr
    \nUser Password=? (Note: If a question mark is entered for the User Password, the user is prompted to enter their password)
    \nGroup=DEMO
    \nAccount=MINISOFT
    \nAutoCommitDefault=ON
    \nCatalog User=
    \nCatalog Password=
    \nSecurity Password=
    \nWarningsAreErrors=YES<\/p>\n

    \n

    <\/a>SQLDriverConnect<\/strong><\/h4>\n

    SQLRETURN SQLDriverConnect(
    \nSQLHDBC ConnectionHandle,
    \nSQLHWND WindowHandle,
    \nSQLCHAR * InConnectionString,
    \nSQLSMALLINT StringLength1,
    \nSQLCHAR * OutConnectionString,
    \nSQLSMALLINT BufferLength,
    \nSQLSMALLINT * StringLength2Ptr,
    \nSQLUSMALLINT DriverCompletion);<\/p>\n

    Where InConnectionString is:<\/p>\n

    DRIVER=HP3000 Data Access Driver;2DriverTable=;Database0=MSDB.DEMO.MINISOFT,WRITER,N,1;
    \n2HostTable=Customers;Server=000.000.000.000;ServerPort=30006;Jobname=MSJOB;
    \nUser=MGR;User Password=PASSWORD;Account=MINISOFT<\/p>\n","protected":false},"excerpt":{"rendered":"

    The parameters in the standalone DSN table are also used in JDBC. Creating a File DSN based on an existing DSN You must create a File DSN if you are using either MSExcel or MSQuery as your client application. On the other hand File DSNs are not needed for Server Release of MSOffice. If you […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2397"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2397"}],"version-history":[{"count":6,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2397\/revisions"}],"predecessor-version":[{"id":2409,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2397\/revisions\/2409"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}