odbc connector not working

[jeffsooss]

hi,

i have a problem connect to mysql database at server by using odbc connector.

senario:

under tcp/ip server option - whem i use ip address, it can be connected, but when i use server pc's name, it cannot connect. Which i cannot use ip address as a guide line because it will change randomly.

The version of the odbc connector is 5.1.13

Thank you very much
Jeff

 

[ChrisHirst]

NETBIOS name or DNS name?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[jeffsooss]

thanks for reply.

we leave DNS setting as auto obtain, same as IP setting.

NetBios name we set it to 'server', so in ODBC connector TCP/IP Server Option are set to 'server', but fail to connect.

If change ODBC connector TCP/IP Server Option to server IP address ( ipconfig to check on server current IP address ), it connect success. But, server IP changed when Windows reboot.

BTW, we using Windows 8

thanks

 

[ChrisHirst]

So the NETBIOS name. with Windows Vista onwards WINS adress resolution isn't reliable, so you need to use the FQDN of the machine you are connecting to.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[jeffsooss]

sorry,

may i know how to find the FQDN name ?

thanks in advance.

 

[jpadie]

this may help:

http://technet.microsoft.com/en-us/library/cc959322.aspx

 

[jeffsooss]

hi,

i had check, the FQDN name same as computer name, only one is in small letter, one is in cap lock ( "server" and "SERVER" ), will this affect the connection ?

But i try using cap lock to connect still fail.

thanks.

 

[jpadie]

I can't see how a fqdn could be the same as a NetBIOS name. But then again I'm not familiar with windows these days so don't put too much credence in what I write.

On a Mac the computer name might be jpadie and be accessible over wins with that name. In the absence of a domain the fqdn defaults to jpadie.local

Another question: are you configuring the connection as a system dsn?

 

[jeffsooss]

hi,

I configure it under user dns.

let me try to configure under system dns and see how's the result.

thanks

 

[ChrisHirst]

The FQDN will be;

computername.domain.localtld where 'domain' and 'localtld' will be whatever your network administrator has set.

And 'computername' will be the same for both, only the NETBIOS (WINS) name will be upper case and the DNS name will be lower case.

open a command prompt, type in, hostname <enter> to display the FQDN of any machine

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum