Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 297 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Trying to connect to an *.fdb using NODBC and PHP
kazamax
Member Posts: 13
Hi! I´m very very novice with Navision, I have been using this program only 2 days :oops:
What I need to do: I have to use PHP to list data from a clients table from an *.fdb database.
My problem:
I use this php code:
I think the configuration of the DSN System is correct...
Can anyone help me??
Sorry about my english and my low knowledge... :oops:
What I need to do: I have to use PHP to list data from a clients table from an *.fdb database.
My problem:
I use this php code:
<html>
<body>
<?
$conn = odbc_connect("test","","");
$query = "select dni, nombre, direccion from clientes";
$rs = odbc_exec($conexion, $query);
?>
</body>
</html>
And the result is:
Warning: odbc_connect(): SQL error: [Simba][SimbaEngine ODBC Driver][DRM File Library]The operating system cannot gain access to the file C:\Archivos de programa\Microsoft Business Solutions-Navision\Client\database.fdb .Please check that the file type and attributes are correct. Error: 5, SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\index.php on line 6 Notice: Undefined variable: conexion in c:\inetpub\wwwroot\index.php on line 10 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\index.php on line 10
I think the configuration of the DSN System is correct...
Can anyone help me??
Sorry about my english and my low knowledge... :oops:
0
Answers
Make sure the file is both readable and writable (check the attributes), that it's not hidden, and that everyone has sufficient NTFS rights (assuming you do use an NTFS partition)
Viewing Navision data using ASP
NAV 4.0, ASP and ODBC
[SOLVED] Navision - PHP/SQL search
[FIXED] Navision ODBC connection with PHP
These topics could get you started.
- Poltergeist: That´s exactly the problem!, when I changed the attributes from the file always was correct.
- Luc Van Dyck: Thank you for your links, I´m sure that will be very helpfull for me