RE: [aus-dotnet] Microsoft.Jet.OLEDB.4.0

[Greg Low]

Hi Phil,

Looks pretty close but sections of connection strings are separated by
semicolons, not commas. An example from www.connectionstrings.com is:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"

It's speaks "Access" brand of SQL, which isn't really like any other
variant. Easiest way to get started on queries is to use a copy of
Access and build up a query in the query designer. Helps avoid learning
its quirks.

Regards,

Greg
 

-----Original Message-----
From: dotnet-owner@xxxxxxxxxxx [mailto:dotnet-owner@xxxxxxxxxxx] On
Behalf Of Phil Best
Sent: Friday, 3 December 2004 10:52 AM
To: Stanski DotNet Group
Subject: [aus-dotnet] Microsoft.Jet.OLEDB.4.0

Hi,
Has anybody had experience talking to Microsoft Access files?

Please advise:
 - Is this the correct connection string
"Provider=Microsoft.Jet.OLEDB.4.0,
Data Source= ......"
 - What breed of SQL does it use?

regards, Phil.

Phil Best BSc(CompSc) AscDipElecEng
C# SQL Software Developer & Electrical Engineer Applied PC Systems Pty
Ltd ABN 64.056.607.713
51 Adsett Street
TARINGA Q 4068
Australia
mailto:phil@xxxxxxxxxxxxxxxxxx
www.StrategyMap.com.au
Phone: 07.3871.0011 07.3371.4450
Mobile:  0411.123400
Overseas Callers - Replace "07" with "++617"





_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send
"subscribe dotnet Your Name" in the body of the email to:
imailsrv@xxxxxxxxxxx List managed by: http://www.stanski.com
_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com