Thread View: borland.public.cppbuilder.database.ado
5 messages
5 total messages
Started by billaras
Sun, 01 Apr 2007 01:22
query in access
Author: billaras
Date: Sun, 01 Apr 2007 01:22
Date: Sun, 01 Apr 2007 01:22
16 lines
1350 bytes
1350 bytes
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
Re: query in access
Author: Vassiliev V. V.
Date: Sun, 01 Apr 2007 08:36
Date: Sun, 01 Apr 2007 08:36
34 lines
2107 bytes
2107 bytes
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 >
Re: query in access
Author: billaras
Date: Sun, 01 Apr 2007 21:20
Date: Sun, 01 Apr 2007 21:20
43 lines
2419 bytes
2419 bytes
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 >> > >
Re: query in access
Author: Vassiliev V. V.
Date: Wed, 04 Apr 2007 20:16
Date: Wed, 04 Apr 2007 20:16
65 lines
3285 bytes
3285 bytes
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 >>> >> >> > >
Re: query in access
Author: billaras
Date: Wed, 04 Apr 2007 22:25
Date: Wed, 04 Apr 2007 22:25
80 lines
3793 bytes
3793 bytes
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 >>>> >>> >>> >> >> > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads