I am writing a C program requiring database connectivity, can someone help/provide resources with the same. I am trying to connect with SOL Server 2000.
Also provide resources for Oracle 11g, MySQL and SQL Server 2005/2008.
Code:
#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
EXEC SQL INCLUDE sqlca;
int main(void)
{
clrscr();
int number;
char fname[80];
char lname[80];
printf("Enter a number : ");
scanf("%d",&number);
printf("Enter your first name : ");
scanf("%s",&fname);
printf("Enter your last name : ");
scanf("%s",&lname);
EXEC SQL INSERT INTO Table1 values(:number,:fname,:lname,);
getch();
return 0;
}