09-16-2010 10:10 AM
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
Solved! Go to Solution.
09-16-2010 01:03 PM
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?
09-16-2010 01:03 PM
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?
09-16-2010 11:42 PM
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 =)
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide