Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

odbc connector not working

Status
Not open for further replies.

jeffsooss

Programmer
May 18, 2010
7
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
 
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
 
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
 

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
 
sorry,

may i know how to find the FQDN name ?

thanks in advance.
 
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.
 
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?

 
hi,

I configure it under user dns.

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

thanks
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top