Ken Levy wrote ...>> About upgrades. What I said at DevCon is that the Fox community can help Microsoft (the Fox team) in upgrading to VFP 7.0. Sometimes people wait a while to upgrade but we feel that VFP 7.0 is a product that is ready for upgrading now with the great new features, great stability, etc.
Ok, ok ... so I bit and upgraded to VFP7... Now I have this problem below, as posted earlier today....
Can anyone help me on this, please .. please!
Thx Scott
======================================================================
>Hi there.
>
>I have now updated my pc to VFP7. But now I cannot access a client's SQL server (sql6.5) using my odbc.
>
>Access to it was working fine previous to the install of VFP ... which seems to have updated my ODBC..
>
>Here are the odbc version numbers from before and after the VFP7 install...on my pc ...
>
>About\Administrator: Old - 3.520.4403.2 New - 3.520.6526.0
>Drivers\SQL Server: Old - 3.70.08.20 New - 2000.80.194.00
>
> The production SQL 6.5 server odbc currently shows:
>About\Administrator: - 3.510.4202.0
>Drivers\SQL Server: - 3.70.06.90
>Now when I try to connect odbc (control panel) to the sql server ... I just timeout. And on the sql server there is an event that indicates that it cannot read the login packets.
>
>My ODBC connection to the sql server is configured to use TCPIP.
>
>Interestingly enough, this particular server has multiprotocol installed, and if I change my pc to use multiprotocol ... I can access that server.
>
>I need to use TCPIP as not all servers have Multiprotocol installed.
>
>Can someone with more experience in this area please explain to me what is wrong and how I can correct this situation?
>
>TIA, Scott Barker
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only