|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
April 30th, 2002, 07:14 PM
|
|||
|
|||
|
Access Denied
I am using a connection string to connect to a database. Here is the connection:
oConn.Open "Driver={mySQL};Server=ap;Port=3306;Option=0;Databa se=mydata;Uid=admin;Pwd=;"' The user name and password are correct, but I have no idea why it won't let me view the record I want. Here is the error I get: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Access denied for user: 'ap@24.55.240.159' (Using password: YES) Any help will be greatly appreciated, AP
|
|
#2
April 30th, 2002, 09:26 PM
|
|||
|
|||
|
hmmm on server change that to localhost and see if that helps. also remove the password and it should work.
__________________
Apache Expert
|
|
#3
May 1st, 2002, 01:23 AM
|
|||
|
|||
|
You may need an entry in the mysql.hosts table. By default, only localhost has access to mysql, so you need to grant capabilities to the PC trying to access it.
see thes links for more info: http://www.mysql.com/doc/A/d/Adding_users.html http://www.mysql.com/doc/G/R/GRANT.html http://www.bugzilla.org/docs/html/granttables.html
|
|
#4
May 1st, 2002, 04:12 PM
|
|||
|
|||
excellent!!!!!!!!!!!!
Thank you so much, now I can get the website online!
AP
|
|
#5
May 2nd, 2002, 12:50 PM
|
|||
|
|||
|
so who helped you out me or mytch or both
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Access Denied |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
