Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sqlstate = 22005

Status
Not open for further replies.

anneoctaaf

Programmer
Dec 15, 2003
104
NL
I installed an powerbuilder application on another computer. It works with an access database. When i open a certain window (some other datawindows work fine) i get the following datawindow error:

select error sqlstate = 22005
[Microsoft][ODBC Microsoft Access Database-stuurprogramma (=driver)]bla, bla, bla

Does anyone know what is wrong??
And where can i find more information about errornumbers??

Thanx in advance!
 
SQL error 22005 is "Data type mismatch in criteria expression" Check the data types of columns in database & the col. specification of the datawindow
 
I'll do that!
But isn't it strange that the datawindow starts complaining in runtime environment. When i'm developing, it doesn't complain about data types?

Thanx!
 
i checked the datatypes in the datawindow and in the database, but there's nothing wrong...
Further more, i don't understand that i don't have that error when developing, i only get during runtime...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top