Active Connection

Thread View: comp.databases.ms-access

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Wilkins Kwok Sat, 14 Jun 1997 00:00

#478

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads