Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-05-03
16
Medium Priority
?
323 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
ID: 24292543
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
ID: 24292558
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
ID: 24292564
What are you trying to accomplish, need a bit more detail here.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:designersx
ID: 24292573
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
ID: 24292650
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
ID: 24292768
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
ID: 24293790
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
ID: 24294698
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 24297267
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24297283
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24297298
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
ID: 24301576
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24301685
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
ID: 24301715
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24301735
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
ID: 24301837
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

879 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