Phil,
I have had the same type of issue. I was able to resolve it by using Access to connect to the SQLServer, alias the columns in Access, and then establish an OBDC connection from Rbase to Access. There was some impact on speed, but this did eliminate the need to export (as suggested using excel ) and then re-import into Rbase. Hope this helps.
Rich Young
Advance Business Systems
10755 York Road
Cockeysville, Maryland 21030
(410) 252-4800
[EMAIL PROTECTED]
From: Phil Nolette (NCS Group, Inc.) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 9:49 PM
To: [EMAIL PROTECTED]
Subject: RE: ODBC Connection to SQLSERVER
Interesting.... Use the Excel ODBC. It is a one-time conversion. It is not like we will be keeping it hot forever.
I will give it a try.
Thanks,
Phil
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 6:15 PM
To: [EMAIL PROTECTED]
Subject: RE: ODBC Connection to SQLSERVER
Hi Phil,
In that case you could always connect to the SQLServer database with Excel and the save out the data as CSV.
Ben Johansen
www.pcforge.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 2:41 PM
To: [EMAIL PROTECTED]
Cc: Bill Dorsey
Subject: RE: ODBC Connection to SQLSERVER
I was afraid that you would say that. The Server is in Virginia and I am in Atlanta. But, if this is what has to be done, then I will do it.
Thanks for you expedient reply.
Phil
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 4:43 PM
To: [EMAIL PROTECTED]
Subject: RE: ODBC Connection to SQLSERVER
Hi
Create Views on SQL Sever with Alias names <= 18 chacters that are also not in the ANSI list (CODE [short for codelock], Etc). that match the field in SQLServer 1-for-1 and make sure the alias names are different that the receiving R:Base table column names.
then once you have sattached the table, then use the project statement to create an rbase table.
project TempRBTable from SQLAttachedTable using *
Now you will have a table that you can use in R:Base to complete the process of getting the data into the R:Base Tables.
Ben Johansen
www.pcforge.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 1:16 PM
To: Rbase-L
Subject: ODBC Connection to SQLSERVER
I connected to a SQLSERVER database through our LAN. I was able to attach the table and can view the data.
The problem that is unresolved is: not all the columns came in because of illegal names. Apparently the allowable size of the column names on SQLSERVER is greater than the column size in RBase. I need the approximately eight tables to have valid data. Has anyone had this moving experience? What did you do?
Appreciate any help,
Phil
NCSGroup
