How to use ActiveConnection on VB

Article View: comp.databases.ms-access

Article #576

Back to comp.databases.ms-access Previous Next

#576

From: Wilkins Kwok
Date: Sun, 15 Jun 1997 00:00

32 lines
2014 bytes

I am a beginner of VB. Now, I am using VB
to develop an application that use ODBC
to link the database. 

Now, I have some problem on using 
ActiveConnection. Because when
I want to run a SQL, VB requires me
to put something in ActiveConnection.
But I don't know put what contents in 
ActiveConnection.

I would appreciate it if you can give me a
solution and give me an e-mail

Thanks You
Wilkins

The following is the sample program:

Dim rdoCn As New rdoConnection
Dim qd As New rdoQuery
Dim s_sql As String

cn.Connect = "uid=;pwd=;DSN=Currency;"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection rdDriverNoPrompt
s_sql = "CREATE TABLE CurInfo " _
      & "(InDate date, Buy dec 5.2, Sell dec 5.2, type int);"
qd.SQL = s_sql
'qd.ActiveConnection '???????'
qd.Execute

Technical Details

Message-ID: <01bc793c$38d7d9c0$413a55ca@kwkwok>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1143a7,44c18e1720c5adb6,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: f938a,44c18e1720c5adb6,start
X-Google-Attributes: gidf938a,public
X-Google-Thread: ff0ac,44c18e1720c5adb6,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f4db5,44c18e1720c5adb6,start
X-Google-Attributes: gidf4db5,public
X-Google-Thread: 1137fc,44c18e1720c5adb6,start
X-Google-Attributes: gid1137fc,public
X-Google-Thread: 10c4e6,44c18e1720c5adb6,start
X-Google-Attributes: gid10c4e6,public
X-Google-Thread: 10fab3,44c18e1720c5adb6,start
X-Google-Attributes: gid10fab3,public
X-Google-Thread: 1162a5,44c18e1720c5adb6,start
X-Google-Attributes: gid1162a5,public
From: "Wilkins Kwok" <kwkwok@net.polyu.edu.hk>
Subject: How to use ActiveConnection on VB
Date: 1997/06/15
Message-ID: <01bc793c$38d7d9c0$413a55ca@kwkwok>
X-Deja-AN: 248506284
Organization: Asia On-Line Limited, Hong Kong.
Newsgroups: comp.databases.ms-access,comp.databases.visual-dbase,comp.lang.basic.visual.database,hk.comp.pc,hk.comp.software,hk.entertainment,hk.forsale,hk.networks.technology,hk.rec.videogame,hk.talk.love,hk.talk.sex,microsoft.public.vb.database