Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[astalus]

Am nevoie de ajutorul D-voastra

incerc sa consult o baza fox din php

asta este erroarea

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified, SQL state IM002 in SQLConnect
in C:\Program Files\xampp\htdocs\altele01\odbc_vad.php on line 2

A functionat pana am reinstalat apache,mysql,php cu XAMPP.

Acesta este php-ul

<?php
$con_id=odbc_connect("vinzari.dbc","","");
$interogare="select j.jud,j.capitala,l.loc,c.dencl,f.nrfact from judete j
left outer join localitati l on j.jud = l.jud
left outer join clienti c on l.codpostal = c.codpostal
left outer join facturi f on c.codcl = f.codcl
order by j.jud,l.loc,c.dencl";
$rez_id=odbc_do($con_id,$interogare);

echo "<center>
<table border=\"1\" cellpadding=\"3\">
<tr><th>judet</th>
<th>capitala</th>
<th>localitate</th>
<th>client</th>
<th>factura</th></tr>";
while (odbc_fetch_row($rez_id)){
$jud = odbc_result($rez_id,1);
$capitala = odbc_result($rez_id,2);
$loc = odbc_result($rez_id,3);
$dencl = odbc_result($rez_id,4);
$nrfact= odbc_result($rez_id,5);
echo "<tr><td>".$jud."</td>
<td>".$capitala."</td>
<td>".$loc."</td>
<td>".$dencl."</td>
<td>".$nrfact."</td></tr>" ;
}
echo "</table></center>";
odbc_close($con_id);
?>
<form action="odbc02.php", method="POST">
<input type="submit" value ="Anapoi" />
</form>

[johnny]

nu ai extensia de odbc incarcata.

[astalus]

extension=php_pdo_odbc.dll

este activ in php.ini

[UnTip]

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified, SQL state IM002 in SQLConnect
in C:\Program Files\xampp\htdocs\altele01\odbc_vad.php on line 2

nu ai driver-ul odbc pentru SQL instalat....ce server de baze de date folosesti ?

[whooper]

Scrie foarte clar, numai ca e in engleza: "Data source name not found".

Te duci in Start/settings/controlpanel/Administrative Tools/Data Sources (ODBC) si adaugi acolo (in System DSN) SURSA DATELOR (ceea ce ai in FoxPro). Acolo ii specifici ca e FoxPro, alegi driver-ul si eventual in tab-ul ADVANCED ii explici cu ce parola si utilizator sa se conecteze la date. Daca n-are parola, nu pui nimic acolo.

Nu te poti conecta direct la fisierul "vanzari.dbc" .. $con_id=odbc_connect("vinzari.dbc","",""); .. trebuie sa scrii numele conexiunii ODBC acolo: $con_id=odbc_connect("vinzariDSN","",""); .. unde "vanzariDSN" e ceea ce ai pus tu in System DSN.


Citat:
ODBC is an Application Programming Interface (API) that allows you to connect to a data source (e.g. an MS FoxPro database).


Create an ODBC Connection

With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available.

Here is how to create an ODBC connection to a MS FoxPro Database:

1. Open the Administrative Tools icon in your Control Panel.
2. Double-click on the Data Sources (ODBC) icon inside.
3. Choose the System DSN tab.
4. Click on Add in the System DSN tab.
5. Select the Microsoft FoxPro Driver. Click Finish.
6. In the next screen, click Select to locate the database.
7. Give the database a Data Source Name (DSN).
8. Click OK.

[PHPRomania Bot]