vb apps with navision sql database
triciaallison
Member Posts: 20
I have some vb apps that run outside of Navision. I was thinking about creating new tables in my Navision SQL Database, and repointing my vb programs to use these new tables. Navision would never update them, but I might have some forms or reports to read the data only. Has anyone ever done anything like this, or know of any reason I should stay away from doing this?
Thanks!
Thanks!
0
Comments
-
Your applications tables do not need to be in the Navision SQL Database, but needs to be on the same server.
So what you do is use MSSQL Enterprise manager to create a view in you Navision database, let's say v_vbapp_table1.
Open Navision, create a new table (call it v_vbapp_table1), create the fields exactly as in your view. You are not allowed more fields.
View the properties of a blank line, set the property LinkedObject = true.
Save your table and you should be able to see the data when your run the table.
Regards,
gus0 -
Hi
I am doing the same thing but with ASP and getting the error as im not using DSN can u suggest me the connection string to access navision table using asp if i write code in asp.
Thanks in advance
Vishal0 -
Here are some links:
http://www.connectionstrings.com/
For creating a view and using it in Navision, you could use the Application Designers Guide (cfr eromein):
http://members.home.nl/eromein/adg/w1w1adg.zip0 -
Hi
Thanks for ur reply but i have seen that site but couldn't find the connection string to neter into Navision DB as i am getting error in asp as
for this codding
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/db/test.fdb"
Error Type:
Microsoft JET Database Engine (0x80004005)
Unrecognized database format 'C:\db\test.fdb'.
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
Pls Suggest
Vishal0 -
-
Hi
Thanks
Thats true i m using native db and even if i use DSN in system dsn as navision it is also not working . i don't know why as i am using this code
can u pls tell me what is the error now in this coding
<%
myDSN="DSN=Navision"
set conn=server.createobject("adodb.connection")
conn.open myDSN
mySQL = "SELECT * from item"
response.write mySQL & "<br><br>"
set rstemp=conn.execute(mySQL)
If rstemp.eof then
response.write "No data found!<br>"
else
response.write "<table border=""1"" style=""font-family: Verdana; font-size: 10pt"">"
response.write "</font>"
rstemp.movenext
loop
end if
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

