Hello

I try to make a Database Connection to a MySQL db (ASP VBscript). I have define a remote server and testing server.

But when testing the Custom Connection String ( DRIVER={MySQL ODBC 3.51 Driver};Server=mysql1.ballou.se;Database=[u4521855_1];UID=[pelle];PWD=[mypassword]; ) by clicking on "Test", I get this error:

[MySQL][ODBC 3.51 Driver]Access denied for user '[pelle]'@'212.214.136.35' (using password: YES)

The password (pelle) is for the MySQL database but the IP above is for the Web Server (which have another password). And the IP for the MySQL Server is this: 212.214.136.77

I guess the mixup in password and IP is coursing the problem - but how do I solve that?

//Magnus

u tried setting your server as 'localhost'?

regards

Dave Thomas
<b>DMX Zone Forums Manager</b>
Tip: Use Google or our own Search function to find answers before asking. You'd be surprised what's already written <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
u tried setting your server as 'localhost'?

regards

Dave Thomas

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Dave

I tried with "localhost" in the FTP server field under "Testing server". But then I get the error:

An FTP error occured - cannot make connection to localhost.
Your login or password is incorrect. Please check your connection information.

I changed the login/pw (to that of the MySql server), but got the same error.

//Magnus

Edited by - Brake6 on 27 Jan 2006 16:34:37

Edited by - Brake6 on 27 Jan 2006 16:35:00

Edited by - Brake6 on 27 Jan 2006 16:35:16