CDatabase db;
//db.OpenEx(_T("Server= xxx.xxx.xxx.xx; Port=5432; User id=postgres;Password=postgresql;Database=databasebook;"), 0);
db.OpenEx(_T("Dsn=postgres;Server=localhost;Port=5432;uid=postgres;pwd=postgresql;Database=databasebook"));
//db.OpenEx(_T("Provider=MSDASQL;Driver=PostgreSQL Unicode;Server=%s;uid=%s;pwd=%s;Database=%s"));
CRecordset rs(&db);
rs.Open(CRecordset::dynaset, _T("select* from databasebook"));
CString str;
short cnt = rs.GetODBCFieldCount();
while (!rs.IsEOF())
{
for (int i = 0; i < cnt; i++)
{
rs.GetFieldValue((short)i, str);
m_List.InsertItem(cnt, str, LVCFMT_LEFT);
}
rs.MoveNext();
}
rs.Close();
odbc를 이용해서 connect하려고 하는데 연결이 안되네요ㅠㅠ뭐가 문제인가요??
|