Where is the code??

asieraies

Hello,

I run Nav against SqlServer 2005. Some questions:

1. Does Nav use OledDB to access SqlServer?? or what does it use??
2. Where does Nav record the C/AL code that I write??

Thanks

Asier

Waldo

What NAV is using is unknown. Probably oledb. It's all inbedded in the C/SIDE clients, which you connect to the SQL database... . The file ndbcs.dll connects to the database, translates to SQL statements, ... .

Furthermore ... the C/AL code you write is stored in the object table ... in the BLOB field. So the entire application is stored in the database, and that's what makes it easy to deploy customizations.

asieraies

And dou you know, how can i retrive this information from BLOB field??

thanks

Asier

Waldo

You can't, I'm afraid.

you can't export the blob content to a readable txt-file. What you get is a binary file (fob).

There are several threads on this forum that handle about this. e.g.:
http://www.mibuso.com/forum/viewtopic.php?t=17702

Nobody

NAV connects to SQL Server via the SQL Server 2000 ODBC driver (regardless of whether you are using 2000 or 2005). It essentially creates a DSN on the fly and the NDBCS.DLL generates the create cursor statements and sends them through ODBC connection to SQL.