Hi Guys,
There is the access DB, and the SQL server. I'm building an
application that can insert a new person, and details, into a DB.
(simple stuff?!) i'm however using a typed dataset created in visual
studio to an OleDb datasource. i then use the insert function to try
to insert into the DB.
the problem is it keeps raising errors depending on the DB chosen
(access or SQL) . if i create the dataset with access, it inserts only
to access. And when created with SQL server, it inserts only to SQL
server. Another prob is that even if i create the two datasets, how do
i determine which one to use depending on the DB the end user will be
using?
thanx for ur anticipated response.