FWIW, this is how I generate the SCONNECT string for a SQL database:
SET VAR vCommandC = ('SCONNECT ' + '''' +
+';driver={SQL
Server};server=PWVSC-SHARE\SQLEXPRESS;database=FUELMASTERPLUSSQL;Trusted_Connection=YES;'
+ '''')
Notice the Trusted_Connection=YES part; I am not sure if you need it for and
Access database. I have the command somewhere for an Access database; I will
see if I can find it.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, November 30, 2015 10:31 AM
To: [email protected]
Subject: [RBASE-L] - SConnect
I have an app that was running version v8 for several years. I finally got a
chance to convert it to
v9.5. However I am having an issue with an SConnected table.
In v8, I was able to Insert, Edit and Delete rows to the SAttached table from
the SConnected database.
In v9.5, I can edit and delete existing rows, but not insert a new row using
the insert command.
I receive a message "Resources required by command are not available" when
attempting the insert
in v9.5
Nothing has changed in the program. The v8 version still works using the same
user name etc.
What is a bit odd is that in v9.5, I can edit a record using "Edit all
from..." syntax and then click the Edit
button and select Duplicate row and the new row will be Duplicated / Inserted.
However the
INSERT command gives me the resources not available message.
The SConnect command is as follows:
SConnect ';Driver={Microsoft Access Driver
(*.mdb)};DBQ=\\192.168.3.100\Outlet\cre2000.mdb'
Has there been new or additional requirements with the v9.5 SConnect or
SAttach commands that
I may have missed?
Thank you,
Bob
