PHPBuilder.com, the best resource for PHP tutorials, templates, PHP manuals, content management systems, scripts, classes and more.

Sr. Web Developer
mediabistro.com
US-NY-New York

Post A Job | Post A Resume

Comments for: siddarth20000228

Message # 1510481:

Date: 02/28/08 02:25
By: imran khan
Subject: PHP with Access

Hi, sir your article is extremely good but I am getting one error

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\wamp\www\DataAccess.php on line 72
no cursor returned!

please tell me what to do?

waiting for U R Reply!!!

Previous Message | Next Message

Comments:
Nice article on Php and Access	http://www.siebelintegration.com/tutorials	05/13/09 06:03
PHP with Access	imran khan	02/28/08 02:25
RE: Connecting my PHP to the Access Database	shanker pokhrel	08/15/07 06:50
RE: HTTP Error 405	GOPI	11/04/05 01:47
RE: Definitive HowTo for Linux	Ralph Quarles	10/16/05 11:17
RE: Connecting my PHP to the Access Database	kaaria	07/22/05 09:20
problem in uploading mysql table	Sumanth	06/22/05 02:46
RE: loading a record from access for an updat	Kiran	06/12/05 15:19
limit display	handi	05/22/05 06:13
It's work	faiz	05/08/05 05:15
importing excel to mysql in linux	Narendra	04/28/05 07:09
RE: Date / Time Problems	Dina	04/28/05 07:01
RE: Database_Entries	sagheer	04/27/05 06:53
data error please help !!!!!!!!!!!!!!!!!!!!	matthew	04/06/05 11:21
RE: Insert Data into linked table	meesam raza	03/29/05 16:38
Connecting my PHP to the Access Database	Basheer	03/27/05 08:22
PHP - ODBC Connectivity...	Prashant	01/28/05 00:38
Date / Time Problems	Morris Logan	12/05/04 16:19
RE: Phpmysql conncet doubt	sudheer	11/13/04 07:21
RE: Access database in Win2000	shirley	03/18/04 14:16
RE: SQL error , SQL state 07001	John	01/22/04 22:37
RE: How to create Grid in MS Access	dax	10/30/03 00:44
PHP to MS Access	Sid	10/15/03 17:15
SUMMARY of solutions 2 basic trbl in tutoria	Andrew Gearhart	10/05/03 20:06
Definitive HowTo for Linux	John Jonas	09/15/03 13:06
please give me sample of database	agus	03/17/03 16:15
ODBC Access 97 - basic ODBC	Christopher Koniges	01/01/03 17:55
RE: Error, help fix please	Roland	11/07/02 02:45
Error, help fix please	Adam Borsi	11/03/02 16:22
SQL problem in ms access 97 (round???)	KEENsBRAIN	11/01/02 08:16
RE: ODBC to a remote host	Dennis Stollman	10/24/02 06:05
RE:dataaccess page	benjamin mwamba katongo AIMIS	10/14/02 09:11
Writing to ODBC	KIswa	09/24/02 13:37
RE: Access database in Win2000	Ian Mellor	09/20/02 12:18
RE: PHP4/ Displaying records from Database.	Ian Mellor	09/20/02 12:11
PHP4/ Displaying records from Database.	Ian Mellor	09/16/02 09:32
RE: Consultant	Abhram	09/13/02 14:45
Consultant	jim charos	09/11/02 23:36
RE: DSN-less Connections	Abhram	09/11/02 15:18
Wrong character with ODBC socket server	hatemler	08/26/02 02:46
RE: ODBC to a remote host	Marcos	08/22/02 11:23
ODBC to an Access located network drive.	Marcos	08/22/02 07:51
RE: How to create Grid in MS Access	monfared	08/21/02 04:37
Database_Entries	Andrew Entwistle	08/09/02 10:33
RE: Undefined variable	Andrew Entwistle	08/09/02 08:56
RE: Undefined variable	Andrew Entwistle	08/09/02 08:52
date format	pauline	07/29/02 13:20
DSN-less Connections	Malcolm Davis	07/26/02 07:39
print a report to adobe in ms access	jeff snider	07/25/02 10:30
Minor corrections	Bryan Frazar	07/24/02 18:04
How to Duplicate Table ?	A Gunawan	07/24/02 15:41
HasData, and #ERROR when subform has nodata??	Nate	07/18/02 10:21
RE: Connecting my PHP to the Access Database	Alex Gombe	07/15/02 06:12
How to create Grid in MS Access	Parashiva Murthy KV	07/08/02 02:55
Populate province combo box after country	Carmela	07/04/02 19:24
help for insert command	George Mathew	07/04/02 00:47
Much easier way - see PHP ShareOffice library	Randy W	07/03/02 13:02
RE: Undefined variable	Peter	07/01/02 08:09
please please HELP !!	Tom	06/25/02 17:32
how i can retrieve file	ranjan	06/21/02 05:37
THANX MAN!	Teye	06/21/02 04:40
RE: ODBC to a remote host	Luis Alberto D�az	06/18/02 06:28
how to connect ms access databse on linux	sachin kosti,dhaval lade	06/17/02 08:05
Connect to project in module	Kelvin	06/12/02 13:05
RE: ms access 97 problem	Vishal Arora	06/11/02 11:45
"Data source name not found "	D Mahoney	06/10/02 12:48
RE: creating checkobx problem	aruna	06/10/02 09:33
RE: Undefined variable	V. V.	06/05/02 14:40
RE: Complex Request very slow	Lou Popovsky	06/01/02 23:58
RE: Warning: Sql error, Operation must use an up	Lou Popovsky	06/01/02 23:47
RE: 1 ODBC connec for all mdb files ? like MySQL	Lou Popovsky	06/01/02 23:36
Undefined variable	Lieven	05/29/02 16:32
No data passing.	Andreas Egneus	05/29/02 07:40
http 405 Error	Rob	05/23/02 06:51
HELP: Storing calculated values in Access	Anu	05/22/02 18:27
transfering Access to SQL	marlina	05/20/02 17:31
Not enough information to connect to this DSN	Klaus	05/20/02 14:37
PROBLEM: linked table permissions	Richard	05/18/02 08:15
Which ODBC module to use in PHP4	Ron Owens	05/16/02 04:38
RE: ODBC to a remote host	Santi	05/14/02 11:53
.dll file problem	Prashant	05/13/02 13:45
Thanx	Luxman	05/10/02 20:04
RE: 22005? Blank screen? Etc?	Bob Arnold	05/08/02 16:19
RE: 22005?	Jeff	05/02/02 17:06
RE: Access and PHP	Jeff	05/02/02 17:02
ODBC to a remote host	Santi	05/02/02 11:39
need a help	radji soraya	04/30/02 08:48
22005?	Kevin	04/27/02 22:34
RE: Warning: Sql Error	Eun	04/26/02 23:59
ms access 97 problem	Parminder Singh	04/22/02 05:50
RE: Passing VARIBLE values between forms?	Ian Mellor	04/16/02 09:09
Passing VARIBLE values between forms?	Ian Mellor	04/15/02 11:08
combo boxes	Jag	04/10/02 04:57
PHP/Access	Evelyn Currie	04/02/02 05:08
ODBC Connection to Network Drive	Thomas A. Dunlap	04/01/02 19:32
THE PORTAIL ODBC+PHP : www.odbcphp.fr.st	HELLO / SECTOR ONE	04/01/02 04:13
RE: PHP and access.	HELLO / SECTOR ONE	04/01/02 04:12
what does it mean???	aja	03/31/02 20:35
RE: query on date format??	annadurai	03/30/02 00:43
Refresh Bug	Sukhjit	03/29/02 07:19
RE: Warning: Sql error, Operation must use an up	Ongki	03/27/02 00:32
Date/Time Lock Code for Access 97 Program	Richard Plant	03/25/02 13:50
RE: No ODBC in Control Panel WinXP?	Angel	03/21/02 09:49
RE: ms access database example	Charles Robinson	03/14/02 08:23
RE: 1 ODBC connec for all mdb files ? like MySQL	Charles Robinson	03/14/02 08:18
RE: ODBC on another server	Charles Robinson	03/14/02 08:09
RE: PHP and access.	Charles Robinson	03/14/02 08:02
RE: I have a problem	Charles Robinson	03/14/02 07:58
RE: PHP and access.	hans	03/12/02 08:47
Access 97 doesn't work!!!! HELP!	Ina	03/11/02 07:33
Date / Time data type	Ryan Parasram	03/11/02 01:22
RE: PHP and access.	oneil	03/06/02 15:02
RE: I have a problem	Question re: formating display of 'Cnt. Src'	03/06/02 12:22
error in date() function	Diesel1	03/05/02 16:19
accessing msaccess/win98 from linux using php	Pravish	03/04/02 23:29
Error In Insert Into Statement	Daniel	03/03/02 14:52
Files used by MS-Access	somah	03/02/02 07:30
php-access	julio	02/28/02 16:52
RE: Connecting my PHP to the Access Database	mac-doggie	02/28/02 02:29
Nice article	Susan	02/25/02 02:42
ODBC on another server	Sergi Maudet	02/24/02 10:50
1 ODBC connec for all mdb files ? like MySQL	Jean-Marc Molina	02/22/02 11:38
MS Access 97 programming	Long Truong	02/22/02 05:46
Phpmysql conncet doubt	jayakumar	02/20/02 04:31
MS access and VB-date formats	divya	02/20/02 01:45
Connecting my PHP to the Access Database	Carl	02/19/02 10:11
MSSQL 2000	Rahim Johnston	02/16/02 17:52
URL Parameters	Mani	02/15/02 08:15
RE: No ODBC in Control Panel WinXP?	Doug	02/14/02 13:36
RE: ms access database example	Nuno	02/14/02 10:58
No ODBC in Control Panel WinXP?	Leonard	02/11/02 06:04
input data in sequence	Mhd Thabrez	02/11/02 04:10
how to insert date/time in a report header	Nick	02/08/02 14:43
getting OLE's from access with php	aliyildiz	02/08/02 10:37
RE: Warning: Sql error, Operation must use an up	Andrew	02/06/02 15:42
interfacing sql with access	Marissa	02/01/02 22:50
RE: Access and PHP	Claudiu	01/29/02 15:07
RE: Complex Request very slow	Serge Gregorio	01/22/02 01:14
transfering text	Aeneas	01/19/02 05:26
question...	Manuel Luis	01/18/02 08:32
How to create authentication again access tbl	quixman	01/03/02 19:51
RE:How to create Setup for MS Access	Jonathan	12/31/01 19:45
RE: MS Access 2000	Paul	12/28/01 18:54
RE: What about Linux and Unix	andrew	12/27/01 16:53
Odbc very slow	Michel Caramez	12/24/01 11:22
hello	Tristan	12/18/01 02:19
RE: MS Access 2000	Patricio Connon	12/17/01 14:45
Subtables in Access 97 ?	Amol	12/17/01 11:24
I have a problem	Ashraf Farag Nashed	12/15/01 14:46
Complex Request very slow	Michel Caramez	12/14/01 06:06
How do you do date calculations?	clark	12/13/01 05:43
INSERT on date format??	david	12/10/01 00:01
update php + access	hello / sector one	12/07/01 17:48
Need help : creating search and updating	Richard Hews	12/05/01 11:14
connection error	alfred	12/04/01 07:19
Access database in Win2000	God Stick	12/02/01 17:34
How to use combo box in access 2000	cris friolo	11/27/01 04:45
PHP to SQL	Michael Krueger	11/26/01 21:34
RE: trouble	Jay C.	11/22/01 23:50
what about access 2000	othman	11/19/01 07:16
how to retrlve data from access in web page	nidhi gupta	11/16/01 08:52
RE: What about Linux and Unix	Craig	11/15/01 20:06
php on solaris to access on nt?	Craig	11/15/01 20:02
loading a record from access for an update	William Kariakri	11/13/01 17:21
Distributed database	Jorge Martines	11/10/01 12:47
Text format storage	Brent	11/01/01 04:43
msaccess2000 connect &apache	Standalone	10/25/01 03:21
RE: DSN for a dummie.	Eric Torstenson	10/24/01 15:26
MySQL ODBC Configuration via Proxy Server	justin flanagan	10/24/01 08:21
RE: How to search the record of access from PHP	Johnny Ingelbrecht	10/23/01 04:35
Searching code	Johnny Ingelbrecht	10/22/01 09:52
How to search the record of access from PHP	beta	10/16/01 15:29
RE: Date / Time data type	Eric Torstenson	10/15/01 16:04
RE: ODBC connection problem	Ronald	10/12/01 06:24
problems importing excel to access	Brian Fruit	10/03/01 12:16
What if...	Al McGrath	10/02/01 10:55
php & access	vinit	09/28/01 13:06
SQL error: ????????????	Jeff	09/25/01 10:28
RE: what am I missing?	Michel	09/20/01 00:46
RE: DSN-Less connection to a .mdb in nt from php	Mr. Happy	09/17/01 20:50
How MSSQL connect to PHP?	Khishigee	09/12/01 01:42
RE: Why not MySQL?	Bob Frank	09/05/01 09:38
RE: Why not MySQL?	Revok Asek	08/30/01 12:21
DSN for a dummie.	Anton	08/20/01 16:38
what am I missing?	djmill	08/17/01 19:11
Access DataBase	Rosalind	08/17/01 04:59
ms access database example	Bhushan Bedekar	08/09/01 22:05
Editing help	Frentzen	08/09/01 04:06
Warning: Sql Error	Junior	08/08/01 17:34
Warning: Sql error, Operation must use an up	Junior	08/08/01 17:31
how to delete and update record?	fizlynn	07/23/01 18:43
RE: Launching MS access 97 program	tshine	07/23/01 16:30
RE: Remotely quering MYSQL database	Time-Out	07/18/01 21:44
Fatal Error unsupported ODBC_Connect	Jeroen	07/18/01 14:13
ODBC connection problem	Jeroen	07/18/01 14:01
RE: how to delete and update record?	Brian Wick	07/17/01 10:25
How to browse tables	Wibisono Sastrodiwiryo	07/14/01 23:31
RE: Error 22005 <=-- What's the solution?	Salman Lone	07/13/01 07:19
RE: Error 22005 <=-- What's the solution?	Salman Lone	07/13/01 05:56
Wow!! Great Man..I like this tutor!	Momon	07/12/01 22:44
calculation with date	man wiszbozy	07/12/01 04:55
SQL error , SQL state 07001	sgelinas	06/21/01 07:21
What about Linux and Unix	CDee	06/20/01 15:20
Error #1064	Kris Zani	06/19/01 01:34
Launching MS access 97 program	Mercy	06/16/01 09:42
RE: How to create Setup for MS Access	Toyin Ferreira	06/16/01 09:36
RE: Remotely quering MYSQL database	reema_sa	06/04/01 05:53
solution to most of your problems	matt	05/31/01 14:23
Thanks for the great example	Nicholas Stevens	05/29/01 09:42
error! help!	Lorell Hathcock	05/07/01 12:55
RE: Access and PHP	QRV	05/04/01 05:38
All's OK, but .....odbc_connect() arguments!	Mauro Bianchini	05/03/01 08:08
RE: DSN-Less connection to a .mdb in nt from php	Michael Tacelosky	04/26/01 20:13
Why not MySQL?	Paxton	04/23/01 01:14
RE: How to create Setup for MS Access	Patrick	04/19/01 09:44
Remotely quering MYSQL database	Paul Leverenz	04/18/01 08:35
Access 97	Anthony	04/12/01 13:36
convert timestamp in ms access	Joe Doherty	04/11/01 09:26
RE: Access and PHP	Wallace Tai	04/11/01 07:55
Access and PHP	Peter G. Limbuhan	04/06/01 05:20
HTTP Error 405	Kit Masengill	04/05/01 18:08
RE: ODBC connection problem	Leigh	04/04/01 10:09
How to create Setup for MS Access	Siti	03/31/01 23:46
error on page	hamid saeed	03/29/01 04:36
RE: Date / Time data type	George Daouros	03/28/01 16:48
RE: Error 22005 <=-- What's the solution?	barkley	03/23/01 06:23
RE: Variable Problem	barkley	03/23/01 06:06
Error 22005 <=-- What's the solution?	Jonathan Angliss	03/20/01 03:24
RE: Make query to DB	Richard Hews	03/18/01 13:15
SOLVED! RE: SQL error: ... SQL state IM002	Charles	03/16/01 02:38
SQL error: ... SQL state IM002	Adam	03/15/01 12:12
RE: Number of rows	John Pugh	03/12/01 12:35
RE: DSN-Less connection to a .mdb in nt from php	Giri Raj	03/06/01 03:17
problems with password	k.p.c. wildervanck	03/01/01 06:53
Number of rows	Fabrice	02/28/01 02:07
No Matter What Anyone Else Says, it Does Work	Michael Cook	02/17/01 11:02
RE: MS Access 2000	Luke Coe	02/13/01 18:46
: SQL error: ... SQL state IM001	Yuriy	02/13/01 10:09
Develop searh engine	Rakseh setia	02/11/01 07:59
Well Done!	DanoZ	02/07/01 18:09
Make query to DB	Richard Hews	02/06/01 15:45
RE: ODBC connection problem	Kevin	01/27/01 23:03
Input data is copied twice after input.	John C.	01/26/01 14:00
odbc-problem	tapani hanninen	01/16/01 13:27
ODBC connection problem	Eric	01/16/01 09:56
RE: SQL Error - state 22005 Win2K	Graham Jenkin	01/13/01 08:09
MYODBC	Ramiro Radjiman	01/08/01 13:58
SQL Error - state 22005 Win2K	Phillip Oldham	01/04/01 05:07
Re: MSAccess, remote	Ivan Ossander	01/02/01 19:00
MS Access, remote	Ivan Ossander	12/30/00 07:55
DSN-Less connection to a .mdb in nt from php	Galib Anwar	12/23/00 17:09
microsoft access	laura krupp	12/22/00 09:34
Formatting dates	Lorraine Howard	12/18/00 12:04
RE: SQL error - part 2...	Troy	12/14/00 01:21
SQL error - part 2...	Troy	12/12/00 23:16
SQL Error - state 22005	Troy	12/08/00 23:20
RE: MS Access 2000	Nick Allen	11/14/00 20:07
Setting up PHP and Apache	Lars Rundberg	11/14/00 06:39
RE: MS Access 2000	Herco van Brug	11/09/00 07:57
Date / Time data type	Jeff Hall	11/07/00 11:50
MS Access 2000	Herco van Brug	11/07/00 08:24
RE: DSN-Less?	Toby J Boyd	10/30/00 15:42
RE: Warning: SQL error......	Brcue van der Kooij	10/29/00 08:31
Warning: SQL error......	Bruce van der Kooij	10/28/00 15:11
ODBC module in PHP	Gerald Meunier	09/29/00 03:59
RE: SQL Error	Brian	09/27/00 12:15
SQL Error	Brian	09/25/00 15:36
RE: Error on update query with ODBC/Access97	Mike Fast	09/19/00 21:24
Error on update query with ODBC/Access97	Phil Beaushilom	09/19/00 05:58
Re: how to delete and update record?	Mike Fast	09/15/00 22:46
how to delete and update record?	Cheah Kok Wengq	09/14/00 14:24
DSN-Less	Scott Anderson	08/23/00 14:22
RE: DSN-Less?	Mukul Sabharwal	08/22/00 12:03
RE: Variable Problem	Mike Fast	08/12/00 13:17
RE: Variable Problem	Clarence Liau	08/12/00 10:16
RE: query on date format??	Josh Bowers	08/03/00 19:13
query on date format??	Niels	08/01/00 06:55
Variable Problem	Paul Malkowski	07/24/00 04:12
RE: trouble	Jim Hawley	07/11/00 12:15
fields don't exist	Aaron Prohaska	07/09/00 01:25
DSN-Less?	Dennis Williams	06/30/00 13:51
trouble	Jason Gelman	06/29/00 20:02
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly. Add A Comment: Name: Email: Subject: Message: To reduce spam posts, messages are now manually approved You are not [logged in]. That means your account will not get credit for this post.

Comments for: siddarth20000228

Add A Comment: