473,385 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Unknown database ('database_name')

4
hi,

I used MySQL database server and VB.Net for my project and need to make a client-server connection.

can anyone help me? i have successfully connected my 2 laptops as server and client using ODBC connector.., but when I tried to access the database on the remote laptop, "Unknown database 'database_name'" appears. Can anyone tell me what is missing or wrong with my connection or configuration?

Main PC ODBC Config:
Data Source Name=MyConnection
Server=localhost
User=root
Password=""
Database=mydb

Remote PC ODBC Config:
DSN=MyConnection
Server=192.168.1.1 (IP ADD of the Server )
User=ivory
Password=mypass
DAtabase=mydb

this configuration is successful, but when I tried running my system project, the system was unable to access the database 'mydb' with error "Unknown database 'mydb'".
Note:

I already issue the command GRANT ALL PRIVILEGES *.* TO 'ivory'@192.168.1.2 IDENTIFIED BY 'mypass'; on MYSQL Command Line at the main PC.

Please help me with this one.

Thanks
Jan 17 '13 #1
1 5189
PsychoCoder
465 Expert Mod 256MB
Show us how you're connecting, i.e your connection string. And which computer are you running the application from, the system which has the instance of MySQL on it or the client machine?
Jan 18 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Useko Netsumi | last post by:
Is it possible to set a user's default database for MySQL database? Instead of having an additional line of command, i.e: mysql> use database <database_name> Perhaps there are parameters I...
6
by: Eric W. Holzapfel | last post by:
Hello PHP group, I have mysql running on a linux box. I have apache (2.0.4) running on a diff linux box. I have php 4.X. I can connect to the mysql db using odbc from a windows box, but...
16
by: John | last post by:
Hello. If I want to set up my first database and start using it in Dreamweaver what do I need to do? The book I'm working on has a CD with the database on. It is telling me to put it in the...
2
by: bryja_klaudiusz[at]poczta[dot]fm | last post by:
Hi, How to copy database diagram (all data) to other server using only MSDE server and VS.Net Proffesional? I have no Enterprice manager. I have to move database (create on my machine) to my...
0
by: Walter | last post by:
Hello, I want to fill a dataset with a random database (mdb-database or SQL-server database), from which a don't know the tables, relations or anything. So after this, the dataset will be 1:1...
5
by: Kevin | last post by:
Can anyone recommend the easiest way to get a full copy of a database from one server to another. The servers are not part of the same organization or network. I have received a backup of the...
3
by: Hrvoje Vrbanc | last post by:
Hello all! Scenario: - web server at one location (domain) with VS 2003 - SQL server at a remote location (domain) - VPN connection on port 1433 between the two domains I have no troubles...
1
by: =?Utf-8?B?aXdlYg==?= | last post by:
Hi, How to create a website URL alias and related SQL Database automatically from the front end using .NET? I mean, our application has to have a control panel to design the above without the...
4
by: scout3014 | last post by:
Hi I am using WAMP5 to create web applications. I have a problem as far as accessing the database is concerned. This following code is used to access database: $con =...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.