Thanks Javier, I tried the trusted connection option in the SConnect command. I did not receive any errors and the database connected OK. However, I am still getting the "resources not available" when issuing the INSERT command. A bit more information. I unloaded an existing record to a file and edited the primary key value. Using the LOAD command with this file name returns the same "resources not available" message. Using the browser EDIT ALL command, I can use the DUPLICATE ROW option and add a new row as long as I modify the primary key column before saving. I get no message in this method. However I need to programmatically use the INSERT command in this case. Thank you again, Bob
----- Original Message ----- From: "Javier Valencia" <[email protected]> To: "ttc inc" <[email protected]> Sent: Monday, November 30, 2015 10:47:46 AM Subject: [RBASE-L] - RE: SConnect 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
