mibuso.com
Home› SQL General
Options

Where is the code??

asieraiesasieraies Member Posts: 49
edited 2007-05-15 in SQL General
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

Comments

  • Options
    WaldoWaldo Member Posts: 3,412
    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.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    asieraiesasieraies Member Posts: 49
    And dou you know, how can i retrive this information from BLOB field??

    thanks

    Asier
  • Options
    WaldoWaldo Member Posts: 3,412
    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

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    NobodyNobody Member Posts: 93
    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.
Sign In or Register to comment.