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.