MS-SQL and C/ODBC Problem

zimba

Hi all;
Today I have problem…
Our Company have C/ODBC,SQL,NAS and NAVISION SERVER License. But we are useing only Microsoft SQL Server Option for Microsoft Business Solutions-Navision on MS-SQL 2000. I know C/ODBC dosen’t working on MS-SQL. But My company want useing C/ODBC ….
Plase Tell me more about how to connect MS-SQL and C/ODBC….
Thank you for help.

oclist

You can't. If I understand it correctly C/ODBC is the ODBC implementation for accessing the Navision proprietary database (ie. not the SQL one). If you want to access the data in the SQL server database you have to use the ODBC sql server driver.

When I did this I ran into two issues.

1) there wasn't a read-only option in the ODBC sql driver. I handled this by using views and setting permissions on the view as read-only.

2) MS Access didn't like the periods (.) in the field names when I tried to connect using ODBC. I had to create aliases in the SQL server view to remove the periods form the field names. I heard in 3.6 there's an option to change the periods to underscores but I can't confirm or deny it.

I hope this helps. Good luck.

RobertMo

i can confirm... underscores instead of periods.
you can specify which chars to convert. by default:
."\/'

zimba

Thank you Oclist and ROmert Mo