用ADO连接SYBASE怎么老是连不上？CAS是ODBC的数据源

[jiek0808]

_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
m_pConnection.CreateInstance(_uuidof(Connection));
try
{
m_pConnection->Open("DSN=CAS;uid=cas;pwd=cascas;","","",0);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
m_pRecordset.CreateInstance(_uuidof(Recordset));
m_pRecordset->Open("select * from dm_parameter",
m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);

[opentuxedo]

建个.udl文件,双击运行,打开你的数据源看能不能成功.成功的话用notepad打开.udl文件,把里面的连接字符串拷到程序里.