Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't connect from VFP
Message
 
 
To
12/04/2012 15:02:16
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01541233
Message ID:
01541264
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.

>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform