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
winmail.dat
