• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

in odbc_connect(), what username and password we need to enter, please tell me in detail?

in odbc_connect(), what username and password we need to enter, please tell me in detail?
0
designersx
Asked:
designersx
  • 9
  • 5
  • 2
1 Solution
 
ValleyENTCommented:
the database username and password must be entered nothing relating to the computer you are working on, but the username and password you enter for the database must have access.
0
 
designersxAuthor Commented:
if i have uploaded my files on ftp.designerx.com , so it need that password.


am i right?
0
 
ValleyENTCommented:
What are you trying to accomplish, need a bit more detail here.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
designersxAuthor Commented:
when i run this code on localhost, msg comes connection is valid
but on server msg comes, error in the connection.

there is a problem in username and password.
<?php
echo $conn=odbc_connect('win.mdb','','');
if($conn)
	echo "connection is valid";
else	
	echo "error in the connection".odbc_error();
exit;
 
}
?>

Open in new window

0
 
designersxAuthor Commented:
i did this with asp and IIS, then it was running there and no username and password was there.

why is this? please help.
0
 
designersxAuthor Commented:
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db2.mdb")

this was the line i wrote when i made a connection with mdb database. i was successful inmaking a connection with mdb but i php i am not able to make a conection with mdb database on the server.

why is this so, it is eating me, please help me in this some how?
0
 
designersxAuthor Commented:
sir i am using wamp server but i am uploading on iis windows server, so would my code be changed to make a connection on iis server?
0
 
designersxAuthor Commented:
ok i have been able now to run on server, can u just tell me how can i count the total no. of rows in the below code. that's it.
<?php
 
    $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
    
        $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\\wamp\\www\\fantaay\\php_with_mdb\\2\\mydb.mdb");
    
        $q="SELECT myfield FROM mytable";
        
        $rs = $conn->Execute($q);
   
    while (!$rs->EOF) {
   
    $fv = $rs->Fields("myfield");
    
        echo "Value: ".$fv->value."<br>\n";
   
    $rs->MoveNext();
    
        } 
   
    $rs->Close(); 
 ?>

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to count, you have 2 options:

option 1
<?php
 
    $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
    
        $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\\wamp\\www\\fantaay\\php_with_mdb\\2\\mydb.mdb");
    
        $q="SELECT count(*) res FROM mytable";
        
        $rs = $conn->Execute($q);
   
        if (!$rs->EOF) {
           $fv = $rs->Fields("res");
           echo "Value: ".$fv->value."<br>\n";
        }
        else {
           echo "no rows<br/>\n";
        }
   
        $rs->Close(); 
 ?>

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
option 2:

<?php
 
    $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
    
        $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\\wamp\\www\\fantaay\\php_with_mdb\\2\\mydb.mdb");
    
        $q="SELECT myfield FROM mytable";
        
        $rs = $conn->Execute($q);
        $row_count = 0;
   
    while (!$rs->EOF) {
    $row_count++;
    $fv = $rs->Fields("myfield");
    
        echo "Value: ".$fv->value."<br>\n";
   
    $rs->MoveNext();
    
        } 
   
    $rs->Close(); 
        echo "Rows: ".$row_count."<br>\n";
 ?>

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in regards to the original question,
did you already check for some suggestions here:
http://php.net/odbc_connect
aka, instead of the .mdb file, you need to specify a DSN entry (on the server) that maps to the .mdb file (as seen on the server)
0
 
designersxAuthor Commented:
thanks for tha above code, working.

now can u tell me
>>instead of the .mdb file, you need to specify a DSN entry (on the server) that maps to the .mdb file (as seen on the server)

i was actually geting confused by this, where do i need to make a entry for dsn.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
on the (i presume windows) server, control panels, odbc administrator.
create a system dsn entry with ms access driver, and configure the path to the .mdb file.

the dsn name is what you use in your odbc_connect(dsn_name, '', '');
0
 
designersxAuthor Commented:
yes sir , i got it thanks for this but 1 last question. i am not getting any browse button or something else or could i write by myself to give it a path for the mdb file,

there is a dropdown showing me where i need to give the path.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have a browse button on the configure screen of the ms access dsn ...
please show the relevant screen shot .
0
 
designersxAuthor Commented:
yes sir got it, don't know what happened to me, just a stupid question i ask from you. thanks for the whole help.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 9
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now