LMS 3.2 ODBC Access with php

Answered Question
Sep 16th, 2010
User Badges:

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

Correct Answer by yjdabear about 6 years 10 months ago

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?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
yjdabear Thu, 09/16/2010 - 13:03
User Badges:
  • Gold, 750 points or more

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 Thu, 09/16/2010 - 23:42
User Badges:

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 =)

Actions

This Discussion