Home > DeveloperSection > Forums > Access database datatype problem
Jenry Hock
Jenry Hock

Total Post:18

Points:126
Posted on    February-21-2012 6:00 AM

 C# C# 
Ratings:


 0 Reply(s)
 1093  View(s)
Rate this:

I am creating a table in access database using OdbcConnection class as I am using DSN but I was unable to create table. An error is generated "Syntax error in field initilizer." I am using c# 3.5.

Query which I had written for creating table is

create table [tblEmployee] ([ID] long not null , [EmployeeSalary] decimal null)

I think problem is with decimal datatype in Odbc driver but when I am using OleDbConnection then no problem arises.



Don't want to miss updates? Please click the below button!

Follow MindStick