INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

odbc connector not working

odbc connector not working

(OP)
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

RE: odbc connector not working

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

RE: odbc connector not working

(OP)
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

RE: odbc connector not working


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

RE: odbc connector not working

(OP)
sorry,

may i know how to find the FQDN name ?

thanks in advance.

RE: odbc connector not working

(OP)
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.

RE: odbc connector not working

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?

RE: odbc connector not working

(OP)
hi,

I configure it under user dns.

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

thanks

RE: odbc connector not working

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close