如何用SQLConfigDataSource(...)来配置ODBC???见正文!急...
我用以下程序:
RETCODE retcode;
UCHAR *szDriver = "SQL Server";
UCHAR *szAttributes =
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=ly\0"
"DATABASE=pubs\0";
retcode = SQLConfigDataSource(NULL,
ODBC_ADD_SYS_DSN,
szDriver,
szAttributes);
这样能建立一数据源MyDSN,但我需要在该数据源中加上登陆ID(UID)和密码(PWD),如:
RETCODE retcode;
UCHAR *szDriver = "SQL Server";
UCHAR *szAttributes =
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=ly\0"
"UID=sa\0PWD=sa\0"
"DATABASE=pubs\0";
retcode = SQLConfigDataSource(NULL,
ODBC_ADD_SYS_DSN,
szDriver,
szAttributes);
但运行后没有成功的建立数据源,好象根本就没执行一样,各位大哥帮忙看看呀!谢谢!!!急...