General SQL error.[ODBC Access Driver]Jet error -1003 
Author Message
 General SQL error.[ODBC Access Driver]Jet error -1003

I have an Access 2.0 database with a numeric field defined as a double.
When I try to post any updates to this type of field thru Delphi, 1.0 I get
the following error:

EDBEngineError with message 'General SQL error.[Microsoft]
[ODBC Access Driver]Jet error -1003 returned'. Process Stopped          

Can somebody explaing why I am getting this message ?? If I change
the numeric field to a single (in the Access Database), the Post doesn't fail,
but when I stop my app. and restart it,  it seems like I'm losing some
precision. e.g. 8.99 becomes 8.989...                

Any help would be greatly appreciated.
John Walsh



Fri, 26 Mar 1999 03:00:00 GMT  
 General SQL error.[ODBC Access Driver]Jet error -1003

Quote:

>I have an Access 2.0 database with a numeric field defined as a double.    
>When I try to post any updates to this type of field thru Delphi, 1.0 I get
>the following error:
>EDBEngineError with message 'General SQL error.[Microsoft]
>[ODBC Access Driver]Jet error -1003 returned'. Process Stopped              
>Can somebody explaing why I am getting this message ?? If I change
>the numeric field to a single (in the Access Database), the Post doesn't fail,
>but when I stop my app. and restart it,  it seems like I'm losing some
>precision. e.g. 8.99 becomes 8.989...                
>Any help would be greatly appreciated.
>John Walsh


I also had similar problems with Access tables a while ago, but then I
got the "MS ODBC 2.0 Database Driver Pack" (available from Microsoft),
and the newest drivers on it solved most of my problems. Still, the
ODBC drivers seem to be rather buggy.

BTW, have you checked the Open DataBase Connectivity pages at
http://www.webbase.com/odbcC.htm? They might have the newest drivers
as well.

Regards,

Jani J?rvinen
Helsinki Finland



Sat, 27 Mar 1999 03:00:00 GMT  
 General SQL error.[ODBC Access Driver]Jet error -1003

Sm9obiBXYWxzaCA8amR3YWxzaDFAdm9pY2VuZXQuY29tPiB3cm90ZSBpbiBhcnRpY2xlIDxqZHdh
bHNoMS4yLjAwMkFERTQ1QHZvaWNlbmV0LmNvbT4uLi4NCj4gSSBoYXZlIGFuIEFjY2VzcyAyLjAg
ZGF0YWJhc2Ugd2l0aCBhIG51bWVyaWMgZmllbGQgZGVmaW5lZCBhcyBhIGRvdWJsZS4JDQo+IFdo
ZW4gSSB0cnkgdG8gcG9zdCBhbnkgdXBkYXRlcyB0byB0aGlzIHR5cGUgb2YgZmllbGQgdGhydSBE
ZWxwaGksIDEuMCBJIGdldCANCj4gdGhlIGZvbGxvd2luZyBlcnJvcjoNCj4gDQo+IEVEQkVuZ2lu
ZUVycm9yIHdpdGggbWVzc2FnZSAnR2VuZXJhbCBTUUwgZXJyb3IuW01pY3Jvc29mdF0NCj4gW09E
QkMgQWNjZXNzIERyaXZlcl1KZXQgZXJyb3IgLTEwMDMgcmV0dXJuZWQnLiBQcm9jZXNzIFN0b3Bw
ZWQJCQ0KPiANCj4gQ2FuIHNvbWVib2R5IGV4cGxhaW5nIHdoeSBJIGFtIGdldHRpbmcgdGhpcyBt
ZXNzYWdlID8/IElmIEkgY2hhbmdlIA0KPiB0aGUgbnVtZXJpYyBmaWVsZCB0byBhIHNpbmdsZSAo
aW4gdGhlIEFjY2VzcyBEYXRhYmFzZSksIHRoZSBQb3N0IGRvZXNuJ3QgZmFpbCwgDQo+IGJ1dCB3
aGVuIEkgc3RvcCBteSBhcHAuIGFuZCByZXN0YXJ0IGl0LCAgaXQgc2VlbXMgbGlrZSBJJ20gbG9z
aW5nIHNvbWUgDQo+IHByZWNpc2lvbi4gZS5nLiA4Ljk5IGJlY29tZXMgOC45ODkuLi4gICAgICAg
ICAgICAgICAgIA0KDQpFcnJvciAtMTAwMyBpcyBkZWZpbmVkIGFzICJJbnZhbGlkIEFQSSBwYXJh
bWV0ZXIiDQoNClVuZm9ydHVuYXRlbHksIHRoYXQncyBHcmVlayB0byBtZS4gSGF2ZSB5b3UgY2hl
Y2tlZCB0aGF0IHlvdSdyZSBydW5uaW5nIHRoZQ0KbGF0ZXN0IHNldCBvZiBPREJDIGRyaXZlcnM/
IFRoZSBzZXQgdGhhdCBjYW1lIHdpdGggQWNjZXNzMiBhcmUgcGFydGljdWxhcmx5DQp1c2VsZXNz
Li4uDQoNCkhUSA0KCUFkZS4=



Fri, 02 Apr 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Delphi 1.0 - ODBC and JET 2.0 - Error 1003 when writing to dB

2. Jet error 1003

3. General SQL error - Delphi 2 ODBC to Access 7.0 mdb

4. BDE error: 13059 (General SQL error)

5. General SQL error -- Win32 error 10054

6. MS Access ODBC Exception -1003: What is this?

7. Help - General SQL error with Access 97

8. HELP!!! General SQL Error with ACCESS and BDE

9. HELP! MSJet-error 1003 with MsAccess-db

10. Delphi3 and MS Access query (ODBC Ok / Native Driver Error)

11. Access ODBC driver error

12. SQL Server and GENERAL SQL ERROR

 

 
Powered by phpBB® Forum Software