Koozali.org: home of the SME Server

Mysql Access Problems

Offline ronaldson40

  • ****
  • 96
  • +0/-0
Mysql Access Problems
« on: June 27, 2007, 08:17:32 AM »
Hi

I have an application that uses mysql on sme server as the backend db.
The program is designed in .NET 2.0 and uses the mysql.dll connector to connect and carry out the mysql transactions. As you all know I need to supply a connection string so that I have a db connection.

Now as per the instructions on the contribs wiki I have opened port 3306 for LAN.
This is my connection string
Database=tbase;Data Source=<mysmesever>;User Id=***;Password=******

I have noticed something. Whenever for Data Source, I use the netbios name of the SME server, I regualrly getting errors in my program usually connection timeouts and the program crashes.

http://img180.imagevenue.com/img.php?loc=loc478&image=24825_error_122_478lo.JPG

However when I use the IP address of the SME server, I dont get any connection timeouts and the program runs fast.

Why is this so?

Regards
Ronald