Database connection
Hi
I have been trying to get to a database design {link removed} that I have created in my Bluevoda Control Panel.
However when I try and test the database using Dreamweaver, the only database it shows is "information_schema"
When I enter the password for my database I get the message "access denied for user xxxxxxx_tidus @'localhost' using password: YES
am I forgetting to do something?
all help much appreciated
thanks!!
Jess
JeevesBond posted this at 13:05 — 26th August 2009.
He has: 3,956 posts
Joined: Jun 2002
Dreamweaver is probably trying to connect to a local database, instead of the database on your Web server. The only thing I can suggest is checking the settings in Dreamweaver.
Welcome to TWF, by the way!
a Padded Cell our articles site!
kedwin posted this at 12:47 — 29th January 2010.
He has: 29 posts
Joined: Dec 2009
Hello jeeves!
You information is so good and awesome and it may be some library code access problem and for this apache server will give correct access to allow..
slicegan2 posted this at 04:46 — 18th August 2010.
They have: 1 posts
Joined: Aug 2010
<?php@ Import Namespace="System.Data.OleDb"
?>
To specify the records to retrieve from the database, we will create a dbcomm variable as a new OleDbCommand class. The OleDbCommand class is for issuing SQL queries against database tables:
sub Page_Load
dim dbconn,sql,dbcomm
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
end sub
Safia Kim posted this at 05:19 — 7th April 2010.
They have: 14 posts
Joined: Feb 2010
Hi,
ADO.NET is also a part of the .NET Framework. ADO.NET is used to handle data access. With ADO.NET you can work with databases.
Regards,
{Link Removed}
zsameer posted this at 18:55 — 11th April 2010.
They have: 4 posts
Joined: Dec 2009
thanks for great information
sandeep Kumar posted this at 07:30 — 8th July 2010.
He has: 53 posts
Joined: Jun 2010
Hi , you just try that code for providing connection between PHP and MYSQL.
<?php
$con = mysql_connect("localhost","root","");
/*
BY default Server Name : localhost, Username :root, Passeord =" ", and you change it through PHP My admin
*/
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Persons
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
// Execute query
mysql_query($sql,$con);
mysql_close($con);
?>
and still if you unable to providing connection then you mention here some snippet of code, I'll try to solve it.
trustworthy posted this at 05:00 — 8th September 2010.
They have: 1 posts
Joined: Sep 2010
This code is right. It solved my friends problem. First I thought for what it would be. I suggested this to my friend so that it would help him in some way and it did...
He had a minute problem in his project and now with this he got it solved. Thanks for this...
____________
{Link Removed}
stokes1900 posted this at 10:29 — 28th October 2010.
They have: 55 posts
Joined: Oct 2010
awesome code.. this code is good for connecting database.. it should be better if u add try and catch block to handle exceptions.
MichelBachkhem posted this at 11:58 — 16th December 2010.
They have: 10 posts
Joined: Dec 2010
Use System.Data.OleDb command . I think it will work and if not then check the settings of Dreamweaver.
rachelstevens posted this at 20:04 — 24th February 2011.
They have: 12 posts
Joined: Feb 2011
Database connections are the same whether the client machine, and in computer science to enable communication with the database server software is more. Connection, you need to send commands and receive responses.
johnpitter posted this at 06:13 — 7th March 2011.
They have: 7 posts
Joined: Mar 2011
Nice Information shared by you. This Code is very helpful for me to do database connection very easily.
Rx software
jessicaellen posted this at 00:05 — 4th May 2011.
They have: 31 posts
Joined: Nov 2010
use this command, i hope you will take help from it.
set objConnection=Server.CreateObject("ADODB.connection")
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.