Database connection

They have: 1 posts

Joined: Aug 2009

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's picture

He has: 3,955 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! Smiling

a Padded Cell our articles site!

kedwin's picture

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..

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

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}

They have: 4 posts

Joined: Dec 2009

thanks for great information

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.

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's picture

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.

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.

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.

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's picture

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.