| Products | Minisoft News | Events | Downloads | Product Manuals
 
   

Frequently Asked Questions

  1. What can cause a Msg 7303 in SQL Server?

    See Minisoft - OLE DB - 7303
     

  2. What are the parameters and options used to start both the client and server portions of this product?

    Click on the below link for a list of all the parameters and options used to start both the client and server portions of OLE DB:

    Common Parameters


  3. How do I create a ConnectionString

    A ConnectionString (or Provider String, or Extended Properties - depending on what application you are running) consists of the driver specific properties separated by semicolons. At the very least it needs to consist of ServerPort, logon information, and database and/or schema file references.  For example:

    ServerPort=30009;User=xxx;UserPassword=xxx;Group=xxxt;Account=MINISOFT;
    ImageDatabase0=ABC,PW,0,1,0

Property Description
Server IP Address or Host Name
ServerPort Port the server process is listening on. The default port is 30009
ServerType 0=MPE/iX  1=Unix  2=Windows. Default is 0.
IgnoreUIDPWD When set (numeric value of 1), values passed in the connection string for user or password do not supersede the value provided in the DSN or connection string. Use only if your applications passes default values that are not related to your host system. ie passing the windows user name to an MPE system.  Default value is 0.
User  
UserPassword  
Account  
AccountPassword  
Group  
GroupPassword  
Jobname  
ImageDatabase# The format is: <database name>,<database password,<automatic masters 0=No 1=Yes>,<database open mode>,<append TPI suffix 0=No 1=Yes>

ImageDatabase0=track,WRITE,0,1,0
ImageDatabase1=:8102/MSCARD,,0
Schema# The format is: <schema name>, <lockword>
SecurityPassword Security3000 password
CatalogUser  
CatalogPassword  
AutoCommitDefault ON/OFF  Default is ON
BigIntAsChar YES/No  Default is NO
CenturySplit For dates with only the year, if the date year is less than the CenturySplit year, the century will be set to 20 or else 19.
DecimalPoint Default: "."
DisableTxns Default: NO.  This only needs to be set to YES if inserting more than 1000 records in a single transaction.
ItemLocking Default: ENABLED.  Set to DISABLED to force set level locking
LockRetries Default: 1.  Suggested value is 20 if doing inserts and updates.
ServerType Default: 0.  0=HP3000  1=Unix
StandardJoins Default: YES
TraceFileName Path name to the log file.
TraceLogFlush Default: 0.  Set to 1 if tracing is turned on.
TraceLogLevel Default: 0.  While the range is 1 to 7, use 7 when creating a trace file.
TraceSysLevel Default: 0.  The range is 1 to 3. On Windows the error is written to the Application Event log.  On Unix to syslogd.
WarningsAreErrors Default: NO.
MaxCacheSize Default: 10240
MaxWriteSize Default: 16384

How do I create a Linked Server?

Prior to creating the linked server, properties of the driver must be set.  Run SQL Server Management Studio and expand out Server Objects, Linked Servers, Providers. Right click on HP3KProvider and enable "Allow inprocess". 

Right click on Linked Servers and select “New Linked Server…”

Linked Server
 

Linked Server

This is the name you will use to reference your Linked Server. It can be anything.

Server Type

Select “Other data source”.

Provider

Select the “Minisoft OLE DB Provider for Image/Eloquence”.

Product Name

This field can not be left blank, but the value can be anything. The suggested value is “HP3KProvider”.

Data Source

The IP Address or Host Name of the box running Image/Eloquence. This field can be left blank if the information is included in the “Provider String”.

Provider String

A list of properties separated by a semi-colon. At the very least it needs to consist of ServerPort, logon information, and database and/or schema file references. Please refer to "How do I create a ConnectionString" above for the list of properties.



Once the linked server is created, right click on the linked server then click properties. Click on Server Options then set "Collation Compatible" and "Rpc Out" to True.

a

a

a