Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi for PHP/Database    [ Add a report in this area ]  
Report #:  45299   Status: Closed
MS Access database doesn'connect
Project:  HTML5 Builder Build #:  1.0.1.414
Version:    1.0 Submitted By:   massimo manca
Report Type:  Basic functionality failure Date Reported:  5/1/2007 9:07:57 AM
Severity:    Critical / Show Stopper Last Updated: 9/5/2012 4:18:03 AM
Platform:    All platforms Internal Tracking #:   252466
Resolution: Cannot Reproduce (Resolution Comments) Resolved in Build: : latest
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
I have my database in c:\Database\PrimaNota.mdb and I try to do a simple test with a window with a multipage component (one page for one db table) and in every page there is a dbgrid. So I used a db component and in obj inspector I wrote:

Connected = true
DatabaseName empty
Debug = 1
Dictionary empty
DriverName = access
Host = Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\\Database\PrimaNota.mdb;
Name = Db
Username = admin
Password empty

so I have a table where:
Active = true
Database = Db
Name = Tbl
TableName = Operazioni (it is not a combo as in C++ Builder, it is ok?)
all other fields are empty.
Grid is connected to the table.
When program runsthis is the output:

: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][Driver ODBC Microsoft Access] Syntax error in proposition FROM., SQL state 37000 in SQLExecDirect in C:\programmi\CodeGear\delphi for php\1.0\vcl\adodb\drivers\adodb-odbc.inc.php on line 530
37000: [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi nella proposizione FROM.

Application raised an exception class ADODB_Exception with message 'odbc error: [37000: [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi nella proposizione FROM.] in EXECUTE("select * from ")
'

What is wrong?
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.