Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't connect from VFP
Message
From
12/04/2012 16:19:33
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01541233
Message ID:
01541277
Views:
27
>Another thing to check. If you are running Windows 7, you may have to open VFP as Administrator. Or the program from which you are connecting to SQL Server.

it worked yesterday and I made no changes to my VFP
the only difference is yesterday I was connected to my work network domain and today I am working from home, but the SQLserve is installed locally on my laptop

the only difference is yesterday I was connected to my work network domain and today I am working from home, but the SQLserve is installed locally on my laptop



>
>>that's the name of my laptop
>>it worked yesterday
>>
>>
>>>To me the server name seems to be "questionable." In my experience the server name usually something like
>>>computername\SQL2008 or computername\SQLEXPRESS. Check the name you see in the SSMS.
>>>
>>>HTH.
>>>
>>>>yesterday I installed SQL2008 developer
>>>>
>>>>I could connect with this:
>>>>
>>>>
>>>>strConnectionString	= [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Uid=sa;pwd=]
>>>>strConnectionString	= [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Trusted Connection]
>>>>
>>>>strSQL				  = [select * from claims where 1=1 ] && or what ever sql statement you are passing.
>>>>csrCursorToBeReturned = [csrNames]
>>>>
>>>>intHandle = SQLSTRINGCONNECT(strConnectionString)
>>>>
>>>>intResults = SQLEXEC(intHandle, strSQL, csrCursorToBeReturned)
>>>>
>>>>
>>>>
>>>>today it times out
>>>>with SQL management studio I connect just fine
>>>>
>>>>what could be wrong?
>>>>
>>>>Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform