Solved

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

Posted on 2009-05-03
16
291 Views
Last Modified: 2012-05-06
in odbc_connect(), what username and password we need to enter, please tell me in detail?
0
Comment
Question by:designersx
  • 9
  • 5
  • 2
16 Comments
 
LVL 4

Expert Comment

by:ValleyENT
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
if i have uploaded my files on ftp.designerx.com , so it need that password.


am i right?
0
 
LVL 4

Expert Comment

by:ValleyENT
Comment Utility
What are you trying to accomplish, need a bit more detail here.
0
 

Author Comment

by:designersx
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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
 

Author Comment

by:designersx
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
I have a browse button on the configure screen of the ms access dsn ...
please show the relevant screen shot .
0
 

Author Comment

by:designersx
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now