Jump to content

[SOLVED] php with access

Recommended Posts

i want to insert data from php to microsoft access ,but i got warning..



its the error that i got


PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\wwwroot\php\test.php on line 8 .


and its the code:






echo "connect";


$sql="insert into t1 values(1,'emmy')";






Link to post
Share on other sites

The string 'test' is not a dsn. Been a long while since Ive programmed in asp but from memory it would look something like...


DRIVER={Microsoft Access Driver (*.mdb)};


You'll need to research what a dsn (the expected firest perameter) is.

Link to post
Share on other sites

Since he got the error on odbc_exec and not on odbc_connect, he has the extension enabled.


@loving_php2008: can you execute a SELECT query for example?

Link to post
Share on other sites

its about odbc in (php.ini) file:





;odbc.default_db    =  Not yet implemented

;odbc.default_user  =  Not yet implemented

;odbc.default_pw    =  Not yet implemented


; Allow or prevent persistent links.

odbc.allow_persistent = On


; Check that a connection is still valid before reuse.

odbc.check_persistent = On


; Maximum number of persistent links.  -1 means no limit.

odbc.max_persistent = -1


; Maximum number of links (persistent + non-persistent).  -1 means no limit.

odbc.max_links = -1


; Handling of LONG fields.  Returns number of bytes to variables.  0 means

; passthru.

odbc.defaultlrl = 4096


; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.

; See the documentation on odbc_binmode and odbc_longreadlen for an explanation

; of uodbc.defaultlrl and uodbc.defaultbinmode

odbc.defaultbinmode = 1


Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.