ODBC is not installed on the system

shareeman · Post by **shareeman** » Mon Jun 22, 2009 5:47 am

Hello
I've got a weird one. I'm unable to import any ODBC table definitions either via the DS Client or using the DS_CONNECT facility on the server.

SQLConnect Error: Status = -1 SQLState = IM976 NatCode = -1
[ODBC:-1] [DataStage][SQL Client][ODBC][Data source name not found, or ODBC is not installed on the system

We've deployed IS8.1 on a Redhat Linux machine.

I'm able to connect to the oracle database via SQL*Plus on the Linux box and also successfully run the /branded_odbc/example/example script to test DSN connectivity.

The .odbc.ini and uvodbc.config files on both the Project and DSEngine folders have been given a thorough going over and don't seem to be the issue.

I'm not sure if this is a permissions issue, seems like DS is looking for a path that's not available.

Has anyone come across this mega-irritant of a problem before and managed to fix it.

Muchas Gracias

ArndW · Post by **ArndW** » Mon Jun 22, 2009 7:56 am

go to TCL in your project, and try to "CONNECT {YourDataSourceName}". What happens?

shareeman · Post by **shareeman** » Mon Jun 22, 2009 8:19 am

Hi ArndW
You've lost me there, I'm assuming you're referring to a UniVerse command here. Please can you elaborate

Many Thanks

ArndW · Post by **ArndW** » Mon Jun 22, 2009 9:00 am

Sorry, I assumed you would understand what I meant. Here are the commands to execute

cd `cat /.dshome`
. ./dsenv
dssh
LOGTO {YourProjectName}
CONNECT {YourDSNName}
QUIT
QUIT

shareeman · Post by **shareeman** » Mon Jun 22, 2009 9:23 am

Urm...Ok

I did already run the ./bin/dssh (DS_CONNECT) script and end up with the same identical error message.

I've mentioned that (DS_CONNECT) on the subject, albeit not in necessary detail perhaps.

Obviously i am not aware of the correct terminology!

ArndW · Post by **ArndW** » Mon Jun 22, 2009 9:31 am

I know about the DS_CONNECT, but I wanted to ask you to try the "CONNECT" command. I expect that the "CONNECT" command will fail, but I would like to see the error message that is generated.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 9:43 am

Same Result, Identical Error Message I'm afraid.

ArndW · Post by **ArndW** » Mon Jun 22, 2009 9:48 am

Ok, then please post your additions to the odbc.ini and uvodbic.ini files, perhaps the problem lies there.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 10:02 am

Just to confirm, there are only 2 files that need to be updated with the relevant DSN details as per my understanding
.odbc.ini (DSEngine folder)
uvodbc.config (DSEngine folder and Project folder)

The Files you've mentioned are odbc.ini and uvodbc.ini , both of which do not exist on the DSEngine folder.
Should i be looking at creating and editing these files as well ?

shareeman · Post by **shareeman** » Mon Jun 22, 2009 10:02 am

Just to confirm, there are only 2 files that need to be updated with the relevant DSN details as per my understanding
.odbc.ini (DSEngine folder)
uvodbc.config (DSEngine folder and Project folder)

The Files you've mentioned are odbc.ini and uvodbc.ini , both of which do not exist on the DSEngine folder.
Should i be looking at creating and editing these files as well ?

sjfearnside · Post by **sjfearnside** » Mon Jun 22, 2009 10:16 am

I have experienced problems connecting to an ODBC source and the problem was a hidden character in one of the two files, either .odbc.ini or uvodbc.config. I used a graphical tool to save the files and it inserted characters that were not viewable using the tool (WinSCP). Try checking both files for hidden characters using the vi function.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 11:26 am

I have gone through the .odbc.ini and uvodbc.config files several times precisely looking for any hidden characters, i shall look again....

Any other leads....would be most welcome

sjfearnside · Post by **sjfearnside** » Mon Jun 22, 2009 11:28 am

Please post the file contents of the .odbc.ini and the uvodbc.config and maybe we can help.

shareeman · Post by **shareeman** » Mon Jun 22, 2009 12:25 pm

.odbc.ini file contents as follows..............

------------------------------------------------------------
[ODBC Data Sources]
DB2 Wire Protocol=DataDirect DB2 Wire Protocol Driver
dBase=DataDirect dBaseFile(*.dbf)
Informix=DataDirect Informix
Informix Wire Protocol=DataDirect Informix Wire Protocol Driver
Oracle=DataDirect Oracle Driver
Oracle Wire Protocol=DataDirect Oracle Wire Protocol Driver
SQLServer Wire Protocol=DataDirect SQL Server Wire Protocol Driver
Sybase Wire Protocol=DataDirect Sybase Wire Protocol Driver
Teradata=DataDirect Teradata
Progress Wire Protocol=DataDirect Progress OpenEdge Wire Protocol
Progress OpenEdge=DataDirect Progress OpenEdge
Progress SQL92=DataDirect Progress SQL92
Test=DataDirect TextFile(*.*) Driver

[DWTEST]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora23.so
Description=DataDirect Oracle Wire Protocol driver
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=DWTEST
UseCurrentSchema=1

[ODBC]
IANAAppCodePage=4
InstallDir=/opt/IBM/InformationServer/Server/branded_odbc
Trace=0
TraceDll=/opt/IBM/InformationServer/Server/branded_odbc/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0
----------------------------------------------------------------------------------

uvodbc.config file contents as follows...............
----------------------------------------------------------------------------------

[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<DWTEST>
DBMSTYPE = ODBC
----------------------------------------------------------------------------------

Let me know if you can spot something, i can't

Many Thanks

sjfearnside · Post by **sjfearnside** » Mon Jun 22, 2009 1:15 pm

There is no DWTEST declaration in your header for the .odbc.ini file. These should be in order of occurrence.