mibuso.com

Microsoft Business Solutions online community
It is currently Tue Sep 16, 2014 9:27 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: C/ODBC Connection Problems
PostPosted: Thu Nov 04, 2004 11:17 am 
Offline

Joined: Fri Jun 18, 2004 10:17 am
Posts: 25
Location: La Zubia
Country: Spain (es)
Hi folks!

I'm trying to connect to Navision native database through C/ODBC, everything goes fine, it connects and I see the tables, but when trying to make a select i got a message saying that i don't have the correct version of the ODBC driver... is there a new version of it?

Thanks,
Juan


Top
 Profile  
 
 Post subject:
PostPosted: Thu Nov 04, 2004 7:15 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7061
Location: L.I., New York
Country: United States (us)
does the version match your db version?

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Fri Nov 05, 2004 3:34 am 
Offline

Joined: Sat Jul 31, 2004 7:08 pm
Posts: 191
Location: Hidden Village
Country: Malaysia (my)
Hello Juan,

May I know your Navision Client version?
You couldn't do "select" on all tables?

You have to have a match version between your Navision Cleint and the C/ODBC driver.

Mine is 3.70.00.13164.

Hope this help,

Jemmy


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 05, 2004 8:31 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12440
Location: Brno
Country: Czech Republic (cz)
Sorry, but main thing is not version of C/ODBC but version of DLLs which are found in "Program folder" you entered in configuration of C/ODBC (slave.exe, nc_tcp.dll, dbm.dll) - this version must be the same too.


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Fri Nov 05, 2004 12:01 pm 
Offline

Joined: Sat Jul 31, 2004 7:08 pm
Posts: 191
Location: Hidden Village
Country: Malaysia (my)
In my DB Server machine:

Quote:
slave.exe is 3.70.0.13164
dbm.dll is 3.70.0.13164
Nc_tcp.dll is 3.70.0.13164


Kine, do you mean that there's a possibility we have different version of those file between machines (client-server)?


Jemmy


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 05, 2004 12:08 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12440
Location: Brno
Country: Czech Republic (cz)
And version of codbc.dll is?

I hope, that you have same version on you clients. I usually have more versions of client on my PC (I am a developer) and there is problem with it (when I need connect on another version of DB etc. :-)) But you must check, that there is no older version in some folder and you don't have configured this old folder in ODBC source...


Top
 Profile E-mail WWW  
 
 Post subject: Version check
PostPosted: Sun Nov 07, 2004 9:02 pm 
Offline

Joined: Fri Jun 18, 2004 10:17 am
Posts: 25
Location: La Zubia
Country: Spain (es)
Hi!

I've checked the versions of all the files....

slave.exe 3.70.0.13164
dbm.dll 3.70.0.13164
nc_tcp.dll 3.70.0.13164
CFRONT.DLL 3.70.0.13164

they're are all the same...


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 08, 2004 11:08 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12440
Location: Brno
Country: Czech Republic (cz)
and version of CODBC.DLL (can be found in C:\Program Files\Common Files\Navision\CODBC)???


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Mon Nov 08, 2004 5:40 pm 
Offline

Joined: Fri Jun 18, 2004 10:17 am
Posts: 25
Location: La Zubia
Country: Spain (es)
Sorry, version of CODBC.DLL -> 3.70.0.13164


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 09, 2004 8:34 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12440
Location: Brno
Country: Czech Republic (cz)
Can you post all parameters set in ODBC DSN?


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Wed Nov 10, 2004 5:06 pm 
Offline

Joined: Fri Jun 18, 2004 10:17 am
Posts: 25
Location: La Zubia
Country: Spain (es)
Sure!

[ODBC]
DRIVER=C/ODBC 32 bit
UID=webclient
SERVER=N
CN=Run Systems S.L. (DES)
RD=No
ML=3082
CD=No
BE=Yes
CC=No
RO=No
QTYesNo=Yes
IT=All Except DOT
OPT=Text
CS=4096
NType=tcp
SName=localhost:4074
CSF=Yes


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 15 guests


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 post attachments in this forum


Search for:
Jump to: