Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Read NODBC (NativeDB) from SQL 2005 SP?
slmaluwa
Member Posts: 366
hi
I am trying to create a stored procedure using .NET in SQL 2005 (SQLCLR) to refer the customer table in Nav 4 SP3 native DB in another server.
Is there any samples of the connection strings any one has? I tried using ODBC (and DSN) and it doesn't work.
TIA
I am trying to create a stored procedure using .NET in SQL 2005 (SQLCLR) to refer the customer table in Nav 4 SP3 native DB in another server.
Is there any samples of the connection strings any one has? I tried using ODBC (and DSN) and it doesn't work.
TIA
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
0
Comments
Is it an unchartered territory??
Search also the forum for C/ODBC or / and N/ODBC.
a quick overview:
1.
Create an ODBC DSN for Navision data access (after installing the ODBC drivers).
Select Control Panel -> Administrative Tools -> Data Sources (ODBC). Then, select the System DSN tab and press the Add button.
You'll use a C/ODBC 32-bit data access driver. As to the database (Database button), select \Installation Folder\Client\database.fdb.
Then, click the Company button; use the CompanyNameInYourDatabase.
It is important for C/SIDE correct database access to set up the proper options for the C/ODBC connection.
Press the Options button and look at the options available. You'll need the Identifiers parameter; it defines the identifiers types that will be transferred to the client application. To work correctly with MS SQL Server with N/ODBC source, you need to use these types: "a-z,A-Z,0-9,_".
Now, DNS is done. Create Linked Server.
2.
Open the SQL Server Management and add this ODBC Source as Linked Server.
Now you are able to select the table and there datas.
3.
The next step is your sp
Hope understandable ......
regards
Thank you for your advice. I completed the step one (though I didn't know what exactly to enter in in the create linked server dialog box) and now it appears under Linked Server list.
Can you give a sample SELECT statement to list customers from the customer table? ](*,) Because, the Books Online says the format to refer the table is "linked_server_name.catalog.schema.object_name".
What to type in catalog and schema (i know what they mean but dunno know the values in this case). Sorry, this is the first time I am doing it with a navision DB.
In my ODBC DSN, I have already given the user name, password and the company hoping that I only have to call the tables directly.
TIA