| |
|
|
Frequently Asked Questions
-
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
-
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 it: <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 |
| 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
|
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.
|
|
