Active Connection

Article View: comp.databases.ms-access

Article #478

Back to comp.databases.ms-access Previous Next

#478

From: Wilkins Kwok
Date: Sat, 14 Jun 1997 00:00

26 lines
1903 bytes

I am a beginner of VB. Now I am using VB to develop
an application but I have some problems on using
Active Connection. The Problem is I don't know
put what contents in the qd.ActiveConnection.
So, I can't execute the SQL.

I would appreciate it if you can give me a
solution. The following is my sample program.

Thank you very much!!

Wilkins

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: <01bc78ab$8fb6e4c0$213a55ca@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: f62b4,e31265e6d4355ba9,start
X-Google-Attributes: gidf62b4,public
X-Google-Thread: 12ea1a,e31265e6d4355ba9,start
X-Google-Attributes: gid12ea1a,public
X-Google-Thread: ff0ac,e31265e6d4355ba9,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 116288,e31265e6d4355ba9,start
X-Google-Attributes: gid116288,public
X-Google-Thread: 1143a7,e31265e6d4355ba9,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: 103f0b,e31265e6d4355ba9,start
X-Google-Attributes: gid103f0b,public
X-Google-Thread: f8dc0,e31265e6d4355ba9,start
X-Google-Attributes: gidf8dc0,public
X-Google-Thread: 1162a5,e31265e6d4355ba9,start
X-Google-Attributes: gid1162a5,public
From: "Wilkins Kwok" <kwkwok@net.polyu.edu.hk>
Subject: Active Connection
Date: 1997/06/14
Message-ID: <01bc78ab$8fb6e4c0$213a55ca@kwkwok>
X-Deja-AN: 248323109
Organization: Asia On-Line Limited, Hong Kong.
Newsgroups: comp.databases.ms-access,comp.databases.rdb,comp.databases.visual-dbase,comp.databases.xbase.fox,comp.databases.xbase.misc,comp.lang.basic.visual.database,de.comp.databases,fj.comp.databases,iijnet.databases,it.comp.database,it.comp.database.acc