Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP-SqlServer-Client Access
Message
From
13/12/2005 17:30:23
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01077584
Message ID:
01077673
Views:
22
>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?

How are you trying to do the connection?

I usually use SQLSTRINGCONNECT() (from my data object):
this.SQLConnectionString = "Driver={SQL Server};server=myserver;uid=userid;pwd=password;database=myData"
this.SQLHandle = SQLSTRINGCONNECT(this.SQLConnectionString)
If the returned handle value is less than 1, you can use AERROR() to find out what the error is.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform