Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql server - vfp how?
Message
From
12/04/2012 11:21:14
 
 
To
12/04/2012 08:20:33
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01541027
Message ID:
01541224
Views:
53
I tried that but the inserts did not work.
But now I have an even bigger problem
yesterday i could connect to sqlserver just fine. today it times out
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)
but the sql serve manager connects just fine

What do I need to do???

Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform