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