🚀 go-pugleaf

For Access and ADO it is better to use OLEDB provider for Access. Connection 
string is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb

However for Access 2007 database connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data 
Source=C:\test.mdb.accdb

First provider (for Access 2003 and lower) in isntalled with most versions 
of Windows and does not require MS Access, second one (for Access 2007) 
requires MS Office 2007 installed on user's computer.

Sincerely yours,
Viatcheslav V. Vassiliev


"billaras" <billaras1234@hotmail.com> �������/�������� � �������� ���������: 
news:46102211@newsgroups.borland.com...
> sorry i mistyped in my original post i used "," and it says the error,both 
> "," and ";" doesnt work with
> ado and access 2007. is there a bug with the odbc drivers and access 2007?
>
>
> "Vassiliev V. V." <support@oledbdirect.com> wrote in message 
> news:460f6f6c$1@newsgroups.borland.com...
>> Access SQL used in ADO differs from SQL in Access itself. Correct syntax 
>> should be ',' instead of ';' as column separator:
>>
>> select a, b from peers where ab = 'a1'
>>
>> //------------------------------------------
>> Regards,
>> Vassiliev V. V.
>> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
>> ADO.Net
>> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>> MS Jet (Access) and Interbase (through OLEDB)
>>
>>
>>
>> "billaras" <billaras1234@hotmail.com> �������/�������� � �������� 
>> ���������: news:460f0952@newsgroups.borland.com...
>>> im trying to run the following simple query through an adoquery in
>>> borland c++ builder 2006(the borland developer studio)
>>>
>>>  ADOConnection1->Connected=true;
>>> ADOQuery1->SQL->CommaText="SELECT a;b from peers where ab='a1'";
>>> ADOQuery1->Active=true;
>>>
>>> i get an error message saying operator missing between a and b....
>>> if i run it through access it runs normaly.
>>>
>>> i have connected the adoquery to an adoconnection and with odbc access 
>>> drivers to access database
>>>
>>>
>>> any ideas?
>>> thks
>>>
>>
>>
>
>