虾米碗糕 发表于 2006-5-23 04:04:03

与数据库连接的问题

#include "cvi_db.h"
#include <cvirte.h>
#include <userint.h>
#include "a.h"
static int panelHandle;
static int hodbc;
int main (int argc, char *argv[])
{
if (InitCVIRTE (0, argv, 0) == 0)
return -1; /* out of memory */
if ((panelHandle = LoadPanel (0, "a.uir", PANEL)) < 0)
return -1;
DisplayPanel (panelHandle);
RunUserInterface ();
DiscardPanel (panelHandle);
return 0;
}
int CVICALLBACK Run (int panel, int control, int event,
void *callbackData, int eventData1, int eventData2)
{
int a=1;
int hstate;
int rescode;
long lstatus;


switch (event)
{
case EVENT_COMMIT:
   hodbc = DBConnect ("DSN=db1");
   
   hstate = DBActivateSQL (hodbc, "select VALUE from table1 where password=2153062");
   
   rescode = DBBindColInt (hstate, 2, &a, &lstatus);   
   rescode = DBFetchNext(hstate);
   rescode = DBDeactivateSQL (hstate);

   rescode = DBDisconnect (hodbc);
   
   
   
   
   SetCtrlVal (panelHandle, PANEL_A, a);
   
   
   
   
   
   break;
}
return 0;
}
int CVICALLBACK quit (int panel, int control, int event,
void *callbackData, int eventData1, int eventData2)
{
switch (event)
{
case EVENT_COMMIT:
    QuitUserInterface (0);
   break;
}
return 0;
}

为什么一直说找不到数据源和驱动器？？？我用的ACCESS？还是数据库要怎么设置？

cpubbs 发表于 2006-5-23 08:12:45

<P>我看了一下这方面，它要在系统里面新建DSN，在控制面板里面的数据源里面新建一个数据源，比如你程序中的DSN=db1！所以你要新建一个DB1的数据源！</P>

虾米碗糕 发表于 2006-5-23 17:23:23

<P>我已经设置了但是还是不行啊，这是什么原因？</P>
页: [1]
查看完整版本: 与数据库连接的问题