ODBC Error

[Rick Pritchett]

Has anyone else seen this error?

[0:TEST] Tcl error:

msgId = message0

proc = ‘odbc1’

args = ”

result = ‘ cannnot find Driver keyword entry for data source MMC-SQL-TEST’

errorInfo: ‘

cannnot find Driver keyword entry for data source MMC-SQL-TEST

Topic

[Jim Kosloskey]

Rick,

Check your odbc.ini file and make sure you have a dsn enty for the driver and that the driver location for the dsn is correct.

I don’t use the odbc.ini file for specific DBs. Instad I use the dsn entries that are provided for the supported DBs and use execution time connect strings to adjust the individual settings as needed.

email: jim.kosloskey@jim-kosloskey.com

[Ron Archambault]

Check your odbc.ini file for the

[ MMC-SQL-TEST ]

driver=//driver..

Make sure the path to the driver is correct.

Here’s one for SQL Server using 5.7

Driver=/hci/qdx5.7/integrator/lib/Connect5.3/lib/CVmsss23.sl

[Rick Pritchett]

ok here is what i found.  

do i just need to copy and rename it and fill in the blanks?

[SQLServer Wire Protocol]

Driver=/quovadx/qdx5.7/integrator/lib/Connect5.3/lib/CVmsss23.so

Description=DataDirect 5.3 SQL Server Wire Protocol

Address=

AlternateServers=

AnsiNPW=Yes

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=

LoadBalancing=0

LogonID=

Password=

QuotedId=No

SnapshotSerializable=0

[Jim Kosloskey]

Rick,

No – you also need to add a dsn reference in the [ODBC Data Sources]section at the beginning of the odbc.ini file I think.

There is a full set of user documentation available from Data Direct on their web site (www.datadirect.com).

Download a copy – almost all of the answers you need will be in there.

It appeares if you foobare the odbc.ini not only will your stuff not work but it is possible other already working dsns may not function – so – make sure you backup.

That is one of the primary reasons we do not update the odbc.ini file but rather use connect time connection strings.

email: jim.kosloskey@jim-kosloskey.com

[Ron Archambault]

I agree with Jim, but if your site is like ours, they want this in the odbc.ini.

So, all you need to do is cut, paste and rename the DSN in the

[Rick Pritchett]

Jim can you briefly explain how your option works?

[Author]

Replies