Linking to SQL

[Banana]

All right...

Would it be practical to first try to connect using internal IP; if this fails, try again but use external IP?

Does SBS handling the handling or ...?

 

[burrelly]

How do you mean is SBS handling the handling?

 

[Banana]

Doh! I garfunkled that one. I mean does SBS handles routing or is that done by a separate router?

 

[burrelly]

Doh! I garfunkled that one. I mean does SBS handles routing or is that done by a separate router?

Ah routing is handled by the router, the sbs is really only there to provide logins and as a file share.

DHCP come from the phone system.

 

[Banana]

And to be clear-

When you said you can connect to it externally, what did you used to connect to it- MySQL client or ?? But you can't connect via MyODBC? (even outside of Access environment, too?)

I'm not quite sure how 'DHCP come from the phone system'... Normally, the router is a DHCP server as well. Is that the case with your network setup?

Does the MySQL box have a hostname?

 

[burrelly]

And to be clear-

When you said you can connect to it externally, what did you used to connect to it- MySQL client or ?? But you can't connect via MyODBC? (even outside of Access environment, too?)

I'm not quite sure how 'DHCP come from the phone system'... Normally, the router is a DHCP server as well. Is that the case with your network setup?

Does the MySQL box have a hostname?

I can connect to the mysql externally using ODBC. The problem is I cant connect to the box from inside the network using the external IP.

No the router is not the DHCP, The phone system is the dhcp server.

 

[Banana]

Gotcha.

So I take it that you do not have control over the DHCP server and can't get/give hostnames?

I would go back to my earlier suggestion of first trying to connect to the box using internal IP. This will definitely fail for users connecting from their home, but you can trap for that error then re-try the connection using external IP (and you can do it without the user knowing at all expect for a bit of delay).

 

[burrelly]

I have sorted the IP issue but I am looking to go for the dsnless connection option but where do I put the connection string?

 

[Banana]

Perhaps this will help?