Visual Basic SQL Access

From: Robin Aly <RoAly_at_aol.com>
Date: 1997/11/05
Message-ID: <345adf06.3941756@omega.gmd.de>#1/1

Hi,

I'm searching a way to access my oracle server from word (97) and visual basic (5.0). I have the possibility to access ist via access linked tables.
I tried VB with the same connect string as access. I use dao 3.5. First create a workspace, then a connection everything goes right until now. But when I do a cn.OpenRecordset("SELECT * FROM TABLE")

The message appears that the odbc-call faild. Am I actualy loged onto the server ? Is this probably an access permission problem. Can I test the connection somehow on a different way ?

many thanks
Robin Received on Wed Nov 05 1997 - 00:00:00 CST