mibuso.com

Microsoft Business Solutions online community
It is currently Thu Oct 02, 2014 6:24 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: 3.56 and PHP
PostPosted: Tue Nov 26, 2002 12:27 pm 
Offline

Joined: Tue Nov 26, 2002 12:08 pm
Posts: 7
Location: Denmark
Country: Denmark (dk)
Hi

I'm trying to make a connection from a Navision 3.56 database to a website through ODBC and PHP.

I've managed to create a System DSN and tested it with MS Excel XP and it works fine.

But when i try to connect to my SystemDSN using PHP nothing happens... :?:
no error message. It just takes forever to load the webpage into IE and eventually it is timed out.

Here's my PHP code:

<?php
$db = odbc_connect("SysNavi","",""); // password and user not defined

$SQLresult = odbc_do($db, "SELECT Nummer, Navn FROM Kreditor");

While (odbc_fetch_row($SQLresult))
{
$num = odbc_result($SQLresult,1);
$name = odbc_result($SQLresult,2);
echo "number: " + $num + "name: " + $name;
}
odbc_close($db);
?>

any help would be appreciated....

Rasmus Torpe

_________________
Regards

Rasmus Torpe


Top
 Profile  
 
 Post subject:
PostPosted: Thu Nov 28, 2002 10:25 am 
Offline

Joined: Tue Nov 26, 2002 12:08 pm
Posts: 7
Location: Denmark
Country: Denmark (dk)
Well here I am replying to my self. But I found the answer so I think it's fair... :D

The reason that it wouldn't work is because the Navision 3.56 ODBC requeres access to the system32 folder! Once I had allowed this, the query succeded and I got my result.

regards,

Rasmus

_________________
Regards

Rasmus Torpe


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 17, 2003 7:56 pm 
Offline

Joined: Mon Mar 17, 2003 7:29 pm
Posts: 8
Country: Poland (pl)
Hello,

I need an acces from our WebPage (ISP server, PHP, FreeBSD) to the Navision database (a server in our company, Win2000, Navi 3.56). Will it work :?: :?: :?: I cannot check it because I do not have an ODBC driver :? . So, I ask you before I ask my boss to pay for the ODBC driver :lol: .
Thx for help,

Rafal


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 18, 2003 10:14 am 
Offline

Joined: Tue Nov 26, 2002 12:08 pm
Posts: 7
Location: Denmark
Country: Denmark (dk)
Hello Rafal,

I haven't tried using PHP from one computer running FreeBSD to access a database on a Win2000 server, so my reply is based on a qualified guess... :!:

It's not straight forward as I see it because you cannot directly access the ODBC driver on a win2000 from FreeBSD. The ODBC needs to be on your FreeBSD computer and I don't know of any Unix ODBC driver to Navision...

So my "solution" is this:

1. install Navision 3.56 ODBC on Win2000
2. install an ODBC socket server on Win2000, thereby making an interface to the FreeBSD server to connect to. Here's a link to ODBC socket server:
http://odbcsock.sourceforge.net/
3. connect to the socket server from PHP/FreeBSD. This could be tricky... :?

Hope this helps your decision!

Rasmus Torpe

_________________
Regards

Rasmus Torpe


Top
 Profile  
 
 Post subject: Hey venner fra dK!
PostPosted: Sun Feb 05, 2006 12:54 am 
Offline

Joined: Thu Feb 02, 2006 10:10 am
Posts: 4
Location: Denmark
Country: Denmark (dk)
Hello im from denmark.

Are you using Naviosion 3.56a or do you have it lying around somewhere? I really need a license for it, because my license to 3.55 is not working in 3.56, and i cant buy it anywhere.

It would be trufully nice of you, if you could help me..

Hilsen Mikkel


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: