native sql for oracle,Connecting to SQL Server & Oracle

Hi Rakshith,

Thank you for your reply, however I am still not able to understand what, where and how I am supposed to set these enviroment variables. Linux is not my forte.

I felt my ODBC.ini file was becoming too changed with regard to the answers I was receiving, so I have retunred it to its original state and then added the changes as shown below

[ODBC Data Sources]

SQL Server Wire Protocol=DataDirect 7.0 SQL Server Wire Protocol

[SQL Server Wire Protocol]

Driver=/informatica/PCExpress/ODBC7.0/lib/DWsqls26.so

Description=DataDirect 7.0 SQL Server Wire Protocol

AlternateServers=

AlwaysReportTriggerResults=0

AnsiNPW=1

ApplicationName=

ApplicationUsingThreads=1

AuthenticationMethod=1

BulkBinaryThreshold=32

BulkCharacterThreshold=-1

BulkLoadBatchSize=1024

BulkLoadFieldDelimiter=

BulkLoadOptions=2

BulkLoadRecordDelimiter=

ConnectionReset=0

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=StephensTestDatabase

EnableBulkLoad=0

EnableQuotedIdentifiers=0

EncryptionMethod=0

FailoverGranularity=0

FailoverMode=0

FailoverPreconnect=0

FetchTSWTZasTimestamp=0

FetchTWFSasTime=1

GSSClient=native

HostName=agile-151p

HostNameInCertificate=

InitializationString=

Language=

LoadBalanceTimeout=0

LoadBalancing=0

LoginTimeout=15

LogonID=sa

MaxPoolSize=100

MinPoolSize=0

PacketSize=-1

Password=

Pooling=0

PortNumber=1433

QueryTimeout=0

ReportCodePageConversionErrors=0

SnapshotSerializable=0

TrustStore=

TrustStorePassword=

ValidateServerCertificate=1

WorkStationID=

XMLDescribeType=-10

I created a new ODBC connection in admin console as follows

Which generates the following error while testing:

What I need it someone to show me what, how and where I need to add any changes.

Sorry seeming a bit thick, bu t as I said earlier, my linux knowledge is not great.