LMS 3.2 ODBC Access with php

[patrickpeuten]

Hey folks,

i want to connect to the CiscoWorks LMS 3.2 Databases (e.g. Campus Manager ) with php.

I wrote a script to export some data from the Database with a .vbs. For that i created a System-DSN ODBC connection - That works fine so far.

Here is explained how to do that : http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html#wp23144

Now I want to do the same with my php Server and a php web site.

I tried to use the System-DSN but I just get the massage "[Sybase][ODBC Driver]The system does not support conversion between Unicode and the requested character set, substituting the current ANSI codepage"

<?php
     $conn=odbc_connect('System-DSN','User','Pw');
     if (!$conn)
     {exit("Connection Failed: " . $conn);}
?>

Has anyone tried this before? Any Code Samples for me?

Maybe I have to use the sybase_connect() methode of php - but how? I don´t get that working

Thx,

Patrick

[yjdabear · Accepted solution]

A quick search of  "[Sybase][ODBC Driver]The system does not support conversion between  Unicode and the requested character set, substituting the current ANSI  codepage" returns this KB article: http://search.sybase.com/kbx/solvedcases?id_number=11584299

Can you install the two missing DLLs on your Windows client to see if it resolves the issue?

[patrickpeuten]

Hey,

thx for your answer.

I found this link, too. But I don´t have the "dbodbc11.dll". I have "dbodbc10.dll" which comes with the Cisco Works 3.2 installation.

So maybe I need the files "dbicu10.dll" and "dbicudt10.dll". I found them in CSCOpx\objects\db\win32\. I will copy them to my php Server.

I just try it, I´ll post if it work or not

Patrick

Edit:

It worked by copying the "dbicu10.dll" and "dbicudt10.dll" files to my php server. THX =)