I've never had to use username/password, but my notes say you include them in
your string with the semicolon delimiters like this:
uid=my_user_name;pwd=my_pw
Karen
-----Original Message-----
From: javier.valencia <[email protected]>
To: rbase-l <[email protected]>
Sent: Mon, Feb 11, 2019 11:10 am
Subject: RE: [RBASE-L] - Working with external databases
#yiv3937875559 #yiv3937875559 -- _filtered #yiv3937875559
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv3937875559
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv3937875559
#yiv3937875559 p.yiv3937875559MsoNormal, #yiv3937875559
li.yiv3937875559MsoNormal, #yiv3937875559 div.yiv3937875559MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}
#yiv3937875559 a:link, #yiv3937875559 span.yiv3937875559MsoHyperlink
{color:blue;text-decoration:underline;} #yiv3937875559 a:visited,
#yiv3937875559 span.yiv3937875559MsoHyperlinkFollowed
{color:purple;text-decoration:underline;} #yiv3937875559 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}
#yiv3937875559 p.yiv3937875559msonormal0, #yiv3937875559
li.yiv3937875559msonormal0, #yiv3937875559 div.yiv3937875559msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}
#yiv3937875559 span.yiv3937875559EmailStyle18 {color:#1F497D;} #yiv3937875559
span.yiv3937875559EmailStyle19 {color:#1F497D;} #yiv3937875559
span.yiv3937875559EmailStyle20 {color:windowtext;} #yiv3937875559
span.yiv3937875559EmailStyle22 {color:#1F497D;} #yiv3937875559
span.yiv3937875559SpellE {} #yiv3937875559 .yiv3937875559MsoChpDefault
{font-size:10.0pt;} _filtered #yiv3937875559 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv3937875559 div.yiv3937875559WordSection1 {} #yiv3937875559 Thanks Buddy,I
don’t believe the Access database requires an userid and password; I can open
it from Access directly. I will check with the creator of that database. Where
would I add the userid and password on the SCONNECT command? Javier, Javier
Valencia, PEO: 913-829-0888C: 913-915-3137 From: [email protected]
[mailto:[email protected]] On Behalf Of Buddy Walker
Sent: Monday, February 11, 2019 7:50 AM
To: [email protected]
Subject: RE: [RBASE-L] - Working with external databases Javier Is it access
rights. You may need a user (uid) and password (psw). Buddy From:
[email protected] <[email protected]> On Behalf Of
[email protected]
Sent: Monday, February 11, 2019 1:58 AM
To: [email protected]
Subject: [RBASE-L] - Working with external databases I am connecting to an
external database using the DSNless command: SET VAR vcommandC = ('SCONNECT '
+ '''' ++ ';Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Program Files
(x86)\sPMS Program\SAMS.mdb;' + '''')&vCommandC And then SATTACH a table using
the command:SATTACH 'SegmentData' AS 'ASegmentData' USING ALL ALIAS
+ASubSection, +ASegmentID, +ARoad, +ABegSeg, +AEndSeg, +ADistrict,
+APavementType, +ALength, +AWidth, +ATotalSize, +ALanes, +ADirection, +AClass,
+ARightOfWay, +ABegMilepost, +AendMilepost, +AUtilities I can access the table
and data and run queries but I am having problems trying to delete and insert
rows to the attached table. For example, the following command does not seem to
work:DELETE ROWS FROM ASegmentData WHERE(ASubSection+ ASegmentID) +NOT IN
(SELECT seg_chk FROM features WHERE sub_sys = 'CJC') If a project the attached
table to a local table: PROJECT TEMPORARY BSegmentData FROM ASegmentData USING
* And run the DELETE ROWS command on the projected table it works correctly so
I know the syntax is correct, same thing with theINSERT INTO…command, works
great on the projected table but not on the SATTACHEd table. I am obviously
missing something because I am pretty sure R+Base can add/delete rows on
external databases/tables and I believe I have done this before but I can’t
seem to find that particular application. Any help will be greatly appreciated.
Javier, Javier Valencia, PEO: 913-829-0888C: 913-915-3137 From:
[email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Thursday, February 07, 2019 11:22 AM
To: [email protected]
Subject: RE: [RBASE-L] - SQL tutorial You can easily check this yourself.
Place the following code in a command file makings sure that vPOID has a valid
value SET ERROR VAR hold
SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus
= 'P'
IF hold = 0 THEN Trace the code one line at the time looking at variables hold
and vchk.Look at the value for vchk and hold after the code executes the second
line.This should tell you how the ERROR VAR changes depending on whether you
get a valid value for vchk or not. Javier, Javier Valencia, PEO:
913-829-0888C: 913-915-3137 From: [email protected]
[mailto:[email protected]] On Behalf Of jan johansen
Sent: Thursday, February 07, 2019 11:09 AM
To: [email protected]
Subject: Re: [RBASE-L] - SQL tutorial Group, Part of this didn't get answered,
maybe obliquely. In the OLD codeIF Hold = 0Does that mean success or failure?
Jan From: "jan johansen" <[email protected]>
To: [email protected]
Date: Tue, 05 Feb 2019 15:41:06 -0800
Subject: [RBASE-L] - SQL tutorial
All, I think I need a SQL refresher.I need to update old code that looks like
this. SET ERROR VAR hold
SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus
= 'P'
IF hold = 0 THEN So isIF hold = 0 the same asIF SQLCODE = 0? Sorry such a dumb
question. Jan --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
