I had just finished installing it when I read your post. I figured out that I was missing something, and that was probably it. I will be doing testing this afternoon. Thanks for the heads up.
Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley Sent: Monday, April 11, 2011 12:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help accessing a MS SQL database Javier, Do you have MS SQL server installed on your system? Every SQL database I connect to has always been running in SQL Server. My 2 cents worth. Paul Buckley -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Monday, April 11, 2011 10:09 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help accessing a MS SQL database Steve, I have been on 9.1-64 for close to a year and it has worked great for me. The only problem I have encountered so far, is connecting to the SQL database itself and this is not an R:Base issue, but a function on how the SQL database was installed and my lack of knowledge of MS SQL Server. Most every other application I interface are Access based, and as long as I know where the *.mdb file is located, DSN-less connections are a breeze; SQL seems to be a little more complicated. Once I get the SCONNECT going, it should be downhill from there on. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wills, Steve Sent: Monday, April 11, 2011 8:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help accessing a MS SQL database Javier, and All, FWIW, I heartily endorse Razzak's mention/suggestion/exhortation(!) about R_anything (64). In our environment, I have to connect to Oracle or SQL Server DBz regularly. Given the use of LONG_......_NAMES I've so often seen in some of these databases, the move from RB%32 to RB%64 was worth it in time savings alone. Yes, I still have to alias/rename some of the columns from the other tables, but I don't have to rename everything that has more characters in the name than whatever the limit is (18?). That was HUGE. I'm not sure who made that suggestion to me, John Minyo, Razzak, Bill_D, or who, but I am still grateful for it and having taken it as GOOD advice. So, Thanks Again, Steve in Memphis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, April 08, 2011 7:04pm 19:04 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help accessing a MS SQL database At 05:47 PM 4/8/2011, Javier Valencia wrote: >R:azzak, > >I just need information on how to connect to a MS SQL database. >Is there a write-up somewhere with instruction on how to do this? > >Is there a way to get just the "Integrating RBASE with ODBC >Compliant Databases" application from the SAT package? I need >to resolve this issue by Monday, since they are planning to >bring the other application by that date. > >Thanks in advance for your help. Javier, Wow! You need to resolve this issue (BTW who's issue is that?) by Monday and you are just starting now? <g> You should have come and joined me a week ago. I would have shown you how to do this (hands-on) and create an R:BASE eXtreme 9.1 (64) application that manages MS SQL Server 2008 R2. Note: The latest enhancements in R:BASE eXtreme 9.1 (64) are a result of such first-hand experience and customer requests. In any case ... Setting up a connection from R:BASE eXtreme 9.1 to MS SQL Server is fairly easy, using the command prompt or built-in utilities. Once the database systems are in place (R:BASE eXtreme 9.1 (64) and MS SQL Server for this example), it becomes a fairly simple matter (well, almost). Keeping the MS SQL Server defined DSN (Data Source Name) and User Permissions in mind, for your own learning purpose, try the simple approach first. Here's how: First things first. Make sure that you are using the latest update and build of R:BASE eXtreme 9.1 (64). http://www.rupdates.com/ 01. Start R:BASE eXtreme 9.1 (64) - Build: 9.1.2.10317 or higher (I am using 9.1.3.10408) 02. First CONNECT to your R:BASE database 03. CONNECT to SQL Data Source Database Explorer | Main Menu | Utilities ... Select "Connect SQL Data Source ..." Click on [Machine Data Source] Click on appropriate Data Source Name Enter User Name and Password, when prompted. 04. Attach SQL Database Table(s) Database Explorer | Main Menu | Utilities ... Select "Attach SQL Database Table ..." Highlight appropriate table from the list of "Tables" and click on [Attach] button. You may attach this table as "Alias" and/or "Temporary". Make sure to click on appropriate CheckBox prior to clicking on [Attach] button if you wish to attach the table as "Alias" and/or "Temporary". Checking the "Alias" box will prompt for Alias Name. 05. Once all tables are attached successfully, click on [Close] button to close Attach Table(s) window. 06. While in Database Explorer | Tables ... Notice the SATTACHed tables with a slightly different icon with "SERVER" for column labeled as "Rows". Double-Clicking on the appropriate server table will open Data Browser/Editor. 07. You may turn these SATTACHed server table(s) as native R:BASE table(s) by using the Copy option from the Database Explorer or using the PROJECT command at the R> prompt. 08. Now you may design Forms, Reports, Labels, and more ... based on these server table(s), just like you would do anything with R:BASE tables. 09. You may automate the whole process using the SCONNECT and SATTACH commands. For complete details, please type the following at the R>: HELP SCONNECT HELP SATTACH HELP SDETACH HELP SDISCONNECT That is your quick 5 minute tutorial and step-by-step instructions to get started. Good luck! Very Best R:egards, Razzak. P.S. Nothing is impossible when you are using the right tools, such as R:BASE eXtreme 9.1 (64). Thanks to R:BASE Technologies, Inc., for designing great products to provide us all with such opportunities! P.P.S. R:BASE eXtreme 9.1 (64) is the only R:BASE version that supports and smoothly interacts with MS SQL Server and Oracle supporting BIGNUM and BSTR data types.
