cant connect to MySQL database

[pidobearBUSsb9q]

global gConnID

//connection to DB
on connectToDB
put the dbhost of me & ":" & the dbport of me into tHost
put revOpenDatabase(the dbtype of me,tHost,the dbname of me,the dbUser of me, the dbPasswd of me) into tConxn

# it's a good idea, but not required, to check for a successful connection here
if tConxn is a number then
put tConxn into gConnID
return empty
else
put "Unable to connect to database '" & the dbName of me & "': " & tConxn into tErrMsg
answer error tErrMsg as sheet
put empty into gConnID
return tErrMsg
exit to top
end if
end connectToDB

//disconnect from DB
on closeDB pConnID
revCloseDatabase pConnID

# this ensures that you'll never have a left-over connection number in the global var
if pConnID = gConnID then
put empty into gConnID
end if
end closeDB

i use the code above but i cant connect to the database. it returns error

thanks for your help

CHeers

[bangkok]

i use the code above but i cant connect to the database. it returns error

first, you should tell us... what is the error you get. That would help.

second, the code you use is too complicated (from a debuging point of view).

Use something more straight :

Code: Select all

put revOpenDatabase("MySQL","XX.XXX.XX.XX","NameOfMyDB","Mylogin","Mypassword") into tConxn
if tConxn is not a number then answer tConxn

Voila. Those 2 lines will tell you if you have a DB problem (connexion, network, wrong password whatever) or a script issue.

[pidobearBUSsb9q]

i use the code above but i cant connect to the database. it returns error

first, you should tell us... what is the error you get. That would help.

second, the code you use is too complicated (from a debuging point of view).

Use something more straight :

Code: Select all

put revOpenDatabase("MySQL","XX.XXX.XX.XX","NameOfMyDB","Mylogin","Mypassword") into tConxn
if tConxn is not a number then answer tConxn

Voila. Those 2 lines will tell you if you have a DB problem (connexion, network, wrong password whatever) or a script issue.

Hi sorry i miss that bad
i try your code
it return Cant connet to Mysql server on "myserver" (0)

thank for your help

[Klaus]

Hi

will delete the other thread now.

Please add this line and tell us whqt the ANSER Dialog will tell you:

Code: Select all

on connectToDB
  put the dbhost of me & ":" & the dbport of me into tHost
  put revOpenDatabase(the dbtype of me,tHost,the dbname of me,the dbUser of me, the dbPasswd of me) into tConxn
  ANSWER tConxn
...

And make sure all those custom properties (the xxx of me) contain correct values!

Best

Klaus

[Mark]

Hi,

Apparently, you don't understand that the dbtype of me,tHost,the dbname of me,the dbUser of me and the dbPasswd of me are properties of an object. The object is what "me" refers to. You can't simply copy and paste the code as it won't work. You need to enter the correct host address, database type and name, port number, user name and password. I wonder if you even installed MySQL?

Kind regards,

Mark

[pidobearBUSsb9q]

Hi,

Apparently, you don't understand that the dbtype of me,tHost,the dbname of me,the dbUser of me and the dbPasswd of me are properties of an object. The object is what "me" refers to. You can't simply copy and paste the code as it won't work. You need to enter the correct host address, database type and name, port number, user name and password. I wonder if you even installed MySQL?

Kind regards,

Mark

Ya i input those values in the properties and they are getting it when i run the program but its just cant go through

the MySQL server is created by my company using phpmyadmin. i have no control over that as i am just an intern

Thanks

[pidobearBUSsb9q]

Hi

will delete the other thread now.

Please add this line and tell us whqt the ANSER Dialog will tell you:

Code: Select all

on connectToDB
  put the dbhost of me & ":" & the dbport of me into tHost
  put revOpenDatabase(the dbtype of me,tHost,the dbname of me,the dbUser of me, the dbPasswd of me) into tConxn
  ANSWER tConxn
...

And make sure all those custom properties (the xxx of me) contain correct values!

Best

Klaus

ya have checked countless times,
i am very sure they are correct as they are provided from the full time staff in the company as i am an intern.

Thanks

[bangkok]

ya have checked countless times,
i am very sure they are correct as they are provided from the full time staff in the company as i am an intern.

OK. Do you confirm that the MySQL Server you try to access is distant (hosted on a server somewhere on the Internet) or on your local network ?

If that's the case, you need :
-to check if the MySQL Server does accept "remote connexion" (it's an option usually found in PHPMyAdmin)
That's the first step. Usually for security purposes MySQL server hosted do not accept remote connexions.

-to check the properties of the login/password you are using to access the database.

[pidobearBUSsb9q]

ya have checked countless times,
i am very sure they are correct as they are provided from the full time staff in the company as i am an intern.

OK. Do you confirm that the MySQL Server you try to access is distant (hosted on a server somewhere on the Internet) or on your local network ?

If that's the case, you need :
-to check if the MySQL Server does accept "remote connexion" (it's an option usually found in PHPMyAdmin)
That's the first step. Usually for security purposes MySQL server hosted do not accept remote connexions.

-to check the properties of the login/password you are using to access the database.

Hi

i will check with the staff of the company about the MySQL server first thing tomorrow morning

what do you mean by the properties?

[pidobearBUSsb9q]

Hey guys

Great News it working

Thanks for all your help and your time
Greatly appreciated

Cheers

[Klaus]

Would you mind telling us what the problem was?