Re: Visual Basic SQL Access

You do have to log onto the server first, at least the way I have done this to date. I learn quickly from example so rather than spew some code I'll point you to a few working applications that you should have access to and that I have used in the past to learn from: Look in you Orwin95 or OrwinNT dir and browse to the sample MAK files that Oracle provides. I can't remember the exact dir. There is some excellent code there for connecting to an Oracle DB. I believe that there are 4 different little apps that are very specific in their function. If you want to take a look at a more robust app that has ODBC connectivity then look at the VB/samples/VisData/VisData.VBP app that comes with VB4 and 5. You could get a good start on how to handle ODBC through VB from all this.
Hope that this helps,
DerWoud
derwoud_at_bellsouth.net

On Wed, 05 Nov 1997 22:52:35 GMT, RoAly_at_aol.com (Robin Aly) wrote:

>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 Thu Nov 06 1997 - 00:00:00 CST