| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| creating a Datasource in solaris |
« View previous topic :: View next topic » |
| Author |
Message
|
| srinivas.ganapathi |
 Posted: Mon Jun 09, 2008 12:21 am Post subject: creating a Datasource in solaris |
 |
|
Newbie
Joined: 09 Jun 2008
Posts: 7
|
Guys,
I am trying to create a new datasource in solaris environment . Can anyone please let me know how can we create a datasource ...
tnx .. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Jun 09, 2008 1:01 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
if you are good on Database
go to ODBC64.ini file and create DSN's over there.
best answer is to search google or contact DBA or system administrator.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| srinivas.ganapathi |
| Posted: Mon Jun 09, 2008 1:04 am Post subject: |
|
|
Newbie
Joined: 09 Jun 2008
Posts: 7
|
| Tnx for the reply .. where is this file placed .. is it under /var/mqsi/odbc directory ???? |
|
| Back to top |
|
|
| DIPU@2007 |
| Posted: Mon Jun 09, 2008 1:08 am Post subject: Re: creating a Datasource in solaris |
|
|
Novice
Joined: 13 Dec 2007
Posts: 18
|
| srinivas.ganapathi wrote: |
Guys,
I am trying to create a new datasource in solaris environment . Can anyone please let me know how can we create a datasource ...
tnx .. |
Every application that supports database connectivity, maintains its own version of a ‘.odbc.ini’ file. It is this file that contains the different DSNs that the particular application uses for database reference. Note that this is a hidden file, beginning with a ‘.’. In our environment, the file where all DSNs are created is present under ‘/var/mqsi/odbc’.
A sample file could look something like this... 
Solaris (SPARC platform)
###################################################################################
########## 32 bit ODBC database driver manager initialization file ################
###################################################################################
# It is recommended that you take a copy of this file and then edit the copy. #
# #
# #
# 1. Complete the 'Mandatory information stanza' section at the end of the file. #
# #
# #
# 2. For each data source, add the name of the data source into the 'List of #
# data sources stanza' section. #
# #
# #
# 3. For each data source, create a stanza in the 'Individual datasource stanzas' #
# section. #
##########################################################################################################################
#### List of data sources stanza ######
#######################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.2 64bit Oracle Wire Protocol
SYBASEDB=DataDirect 5.2 64bit Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 5.2 64bit Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 5.2 64bit SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver##########################################################
########## Individual data source stanzas ################
########################################################### DB2 version 8 stanza
[DB2V8DB]
Driver=<Your DB2 v8 install directory>/lib/libdb2.so
Description=DB2V8DB DB2 ODBC Database
Database=DB2V8DB# DB2 version 9 stanza
[DB2V9DB]
Driver=<Your DB2 v9 install directory>/lib32/libdb2.so
Description=DB2V9DB DB2 ODBC Database
Database=DB2V9DB# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKora22.so
Description=DataDirect 5.2 64bit Oracle Wire Protocol
HostName=<Your Oracle Server Name>
PortNumber=<Port on which Oracle is listening on HostName>
SID=<Your Oracle SID>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKase22.so
Description=DataDirect 5.2 64bit Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKase22.so
Description=DataDirect 5.2 64bit Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC64/V5.2/lib/UKmsss22.so
Description=DataDirect 5.2 64bit SQL Server Wire Protocol
Address=<Your SQLServer Server Name>,<your SQLServer Port Number>
AnsiNPW=Yes
Database=db
QuotedId=No
ColumnSizeAsCharacter=1# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper64.so
Description=IBM Informix ODBC Driver
ServerName=<Your Informix Server Name>
Database=<Your Database Name>#########################################
###### Mandatory information stanza #####
#########################################
[ODBC]
Trace=0 # To turn on ODBC trace set = 1
TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace64.out
TraceDll=<Your Broker install directory>/ODBC64/V5.2/lib/odbctrac.so
InstallDir=<Your Broker install directory>/ODBC64/V5.2
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8 |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
