I use SqlDataAdapter to my VB.NET project.

I drag a SqlDataAdapter1 to a Form and I configure it.

The default OLE DB Provider of SqlDataAdapter is Microsoft OLE DB Provider for SQL Server but I select Microsoft Jet 4.0 OLE DB Provider as my provider but I encounter this message!

"The connection you have created does not work witht he current adapter."

My PC is not connected with network. Kindly help me what do? Can I still use Microsoft Jet 4.0 OLE DB Provider?