Hi all, 😢
I posted a thread tomorrow 'bout problems connecting myself to Access database..here is the link
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10229933
I apply advices that comes and now It says
SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect., SQL state S1000 in SQLConnect in c:...
Well, now and dunno what is it for error so does someone can explain me how to "use" the SQLDriverConnect???
I'm using PHP as language if it can help..
I read 'bout SQLDriverConnect but I don't understand a thing!!
PLEASE...it has been 2 days i'm working on it and it doesn't work...
Also, I tried the DSN-less Connection with some instruction like this
$doc_root=$HTTP_SERVER_VARS['DOCUMENT_ROOT'];
$dbc = new COM("ADODB.Connection");
$dbc->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db\ABN.mdb;Persist Security Info=False");
?>
Well I was happy 'cause it works at first time but when I try another "select" from the database, wich is a bigger one...It says me :" Invoke() failed, Exception occured "!!
My query works but I wonder if there is special characters to work with or if it limits the number of character in the instruction $dbc->Execute(.....) 'cause my query is bigger
I'm dunno what to do and I'm stuck since 2 days...
PLEASE HELP ME!!! 😢
Thx
Ben
