vb and sas tables 
Author Message
 vb and sas tables

Can you access SAS tables from VB? If so, how? Some sort of ODBC
connection code I presume?

I can run SAS code, but I would like to display the results in a VB
table or report.



Fri, 28 Jun 2002 03:00:00 GMT  
 vb and sas tables
Hi

I have not accessed SAS data using VB, but I did test the SAS ODBC
Driver a couple of years ago with Delphi.  We did not use it in the end,
but it worked easily enough and should also allow access to SAS data
using VB.

I'm afraid that I can't  give you a description of exactly how to
proceed.  I am now retired and don't have SAS on my home computer.
However, I do have in front of me the SAS ODBC Driver Technical Report:
User's Guide and Programmer's Reference, Release 6.11, report # 55272.
It is 50 pages long.  This is what I used to figure out how to install
and configure the SAS ODBC driver.  It was prettty straightforward.  If
you can get hold of this, or later documentation, you should have no
trouble from the SAS side.  (If you have not made a full installation of
SAS, you may need to install the ODBC driver from your CD.  I believe
that it is a separate module.)

If you then have trouble from the VB side, you could post a more
specific message to the relevant VB news-group(s). There is one specific
to ODBC:  microsoft.public.vb.database.odbc.

Regards,

John.....

Quote:

> Can you access SAS tables from VB? If so, how? Some sort of ODBC
> connection code I presume?

> I can run SAS code, but I would like to display the results in a VB
> table or report.



Fri, 28 Jun 2002 03:00:00 GMT  
 vb and sas tables
I suspect that you want

http://www.sas.com/rnd/itech/doc/dist-obj/winclnt/winvbpro.html

good luck

Quote:

>Can you access SAS tables from VB? If so, how? Some sort of ODBC
>connection code I presume?

>I can run SAS code, but I would like to display the results in a VB
>table or report.



Sat, 29 Jun 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. vb and sas tables

2. Unable to import SAS data into ACCESS97 or EXCEL 2000 using the SAS ODBC driver

3. VB 4.0 Enterprise with SAS & ODBC

4. Contract for SAS, VB, Oracle in Chi

5. VB / SAS Binary

6. VB and SAS

7. Excel to SAS

8. SAS connection string

9. SAS - Canada

10. SAS Dataset

11. sas odbc

12. Accessing SAS files

 

 
Powered by phpBB® Forum Software