I've read of that software in the newspaper lately. It looks like your distributor here is doing a good advertising campaign.

You did not say what the upgrade was? Was it to SQL Server or was it to the workstations OS or was it to the application? However, I'd check Windows firewall settings first since most of my access problems lately have been bound to that. Also notice that AFAIK you'd need to install client access to comunicate with an instance of SQL Server.

Enmanuel

>This a commercial application called Profit Plus.. the problem came when they made an upgrade, with the older version, all the workstations worked fine with Client Access intalled, but when they made the updgrade, only those workstations with Client Acccess intalled stopped accessing the database via Profit Plus, but the ODBC was ok.
>
>I had to initialize (format and reinstall all software excep Client Access) those workstations and enabled two PCs with client access for those user who need to use the AS-400 server..
>
>>Jonathan are you accesing the server from a workstation or is it a local server? If you're using a workstation make sure you configured an alias name for the server and that WinXP/SP2 firewall is not blocking the port used by SQL Server. Also check that TCP/IP and/or named pipes protocols are enabled because SQL Server SP3 and up disable all network protocols by default.
>>
>>HTH,
>>
>>Enmanuel
>>
>>>When starting the application, it shows the message:
>>>Couldn't find server
>>>
>>>Where sqlservername is the name of my sql server..
>>>
>>>The original message appears in spanish, i'm not pretty shure if this is the appropiated translation...
>>>
>>>I've tested the odbc and it works ok..
>>>
>>>>>Is there any known bug for applications developed in VFP6 accessing sqlserver when Client Access is installed on a XP based pc?
>>>>
>>>>Not that I'm aware of. What specifically is the problem you're having?

I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain