🚀 go-pugleaf

i was connecting by using the odbc drivers, if i use the jet ole db it says 
that there isnt installed isap...
if i select ace oledb i cant select the database that i want to open,(in the 
next page of the ado )

do you believe that the drivers that i select to connect to a database might 
play some role to why
some sql queries arent executed correctly?thks


"Vassiliev V. V." <support@oledbdirect.com> wrote in message 
news:46140804$1@newsgroups.borland.com...
> 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
>>>>
>>>
>>>
>>
>>
>
>