I have one of my prospect who is wiiling to have Navision with SQL server option,he is also having some other web based application which is running on sql server.
what they want that we also have the Navision Database on same sql server & then have some integration with that application to fetch data from that Database to Navision.
so we have both database on same sql server & now we have to acheive connectivity.
what will be possible way of connectivity between these two database.
any Example using odbc ?
can we write sql query from Navision sql server option to fetch data from other database.
please help me out.