ODBC configuration problem

Discussions specific to Team Developer 5.1.

ODBC configuration problem

Postby narasareddykr » Wed May 09, 2012 8:47 pm

Hi All,

I have install the team developer 5.1 version in WINDOWS 7, and install the MY SQL server 5.5 and ODBC driver installation.

I went to the control pannel --> administrative tools --> ODBC connection and configure the ODBC and tested, the message shows connection successfully.

I went to the sql.ini in team developer and added the below code.

[odbccrtr]
remoredatabase=test, DNS=test;

Created the new application in centura with
set database = 'test'
set user = 'root'
set password = 'sysadm'
call sqlconnect( hsqlconnect )

and run the application i am receving the error message "Couldn't connect the database".

Please help on this how to configure the ODBC connection in teamdeveloper 5.1 with windows 7.


Thanks all
Narsareddy
narasareddykr
 
Posts: 1
Joined: Wed May 09, 2012 8:38 pm

Re: ODBC configuration problem

Postby clemdoc » Thu May 10, 2012 1:39 am

Hi!

Do you have an entry "comdll=sqlodb32" in section "[win32client.dll]"? If I remember correctly, that entry must be the first, before any other entry (such as sqlws32).

narasareddykr wrote:[odbccrtr]
remoredatabase=test, DNS=test;

Assuming that "remoredatabase" and "odbccrtr" are just typos and you really have put "remotedbname" and "odbcrtr": We also have the server in the remotedbname: "remotedbname=test,DNS=test,server=mysqltestserver" (no semicolon either).
narasareddykr wrote:Created the new application in centura with
set database = 'test'
set user = 'root'
set password = 'sysadm'
call sqlconnect( hsqlconnect )

Assuming again, that you really have SqlDatabase, SqlUser and SqlPassword: You can also try to connect using SqlTalk. There, you can check, which sql.ini file is used (Menu Help -> About SQLTalk for Windows -> Config File) and if you're editing the right one.
Can you connect using the MySQL Command Line client?

HTH, clem
clemdoc
 
Posts: 238
Joined: Tue May 12, 2009 8:18 pm
Location: Graz, Austria

Re: ODBC configuration problem

Postby jmcnamara » Thu May 10, 2012 6:25 am

Make sure you're using the 32 bit ODBC driver - 64 bit won't work.
jmcnamara
 
Posts: 117
Joined: Thu Dec 13, 2007 9:39 am

Re: ODBC configuration problem

Postby Jeff Luther » Fri Jul 20, 2012 2:36 pm

CLEMDOC: Thanks for your reply earlier, but just to clarify what you wrote a bit about the sqlodb32 comdll order. Here's this section in question in my SQL.INI file with all comdll= uncommented, but the important parts I'll put in bold:

[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
comdll=sqlifx32
comdll=sqlora32
comdll=sqlsyb32
comdll=sqlodb32
comdll=sqlws32


I don't believe the order of any of the other uncommented listings matters, as long as sqlodb32 = 2nd to last, sqlws32 (SQLBase & SQL/API) is last.

Oh, and 2 further points as long as I'm thinking of it -- both have been 'gotchas' with other users and their edited INIs:
1 -- I recall there should be no spaces in any of those entries. "comdll = sqlws32" would be wrong.

2 -- Some users don't install SQLBase so think they can comment out the last entry, which is always UNcommented in SQL.INI when TD is installed.
This is wrong! "comdll=sqlws32" must be last and be UNcommented, even if you don't connect to SQLBase. Why? Because that's needed for the router to call the SQL/API functions for other DB brands even if no SQLBase DB.
Jeff Luther
 


Return to Team Developer 5.1

Who is online

Users browsing this forum: No registered users and 1 guest

cron