Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete record ?
Message
 
To
23/04/2004 10:47:32
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00896769
Message ID:
00897616
Views:
27
Thanks Patric. I think I found the problem.
When I change Your code in cursor adapter to ADO connection set the error arise. I change ONLY follow:
* Your code
this.DataSourceType = "ODBC"
This.DataSource = sqlstringconnect([driver={Sql server};server=(local);usid=sa;pwd=kan67;database=task;);););)] + ;


*My code
this.DataSourceType = "ADO"

local loConnDataSource
loConnDataSource = createobject('ADODB.Connection')
***<DataSource>
loConnDataSource.ConnectionString = [Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Init] + ;
    [ial Catalog=Task;Data Source=ZOGRAFSKI;]
***</DataSource>
loConnDataSource.Open()
This.DataSource = createobject('ADODB.RecordSet')
This.DataSource.CursorLocation   = 3  && adUseClient
This.DataSource.LockType         = 3  && adLockOptimistic
This.DataSource.ActiveConnection = loConnDataSource
May be this is a BUG?
Thanks for your time
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform