Skip site navigation (1) Skip section navigation (2)

Re: Connection Problem

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Joseph Watson <jtwatson(at)datakota(dot)com>
Cc: "pgsql-ODBC (E-mail)" <pgsql-ODBC(at)postgresql(dot)org>
Subject: Re: Connection Problem
Date: 2002-01-28 00:36:02
Message-ID: 3C549CF2.FA59680F@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Joseph Watson wrote:
> 
> Here is my VB code:
> 
> Private Sub Command5_Click()
> 
>     Dim FSEInfo As Workspace
>     Dim conn As Connection

If I remove the above line(Connection), the following
seems to work though I don't understand the reason.

regards,
Hiroshi Inoue

>     Dim connstring As String
> 
>     connstring = "ODBC;DSN=FSE Info;"
> 
>     Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser, txtPassword,
> dbUseODBC)
> 
>     Set conn = FSEInfo.OpenConnection("FSE_Info_cnn",
> dbDriverCompleteRequired, False, connstring)
> 
>     conn.Close
> 
>     FSEInfo.Close
> 
> End Sub
> 
> The error occurs on the "Set Conn" line, and reads:
> 
>     Run-time error '13':
> 
>     "type mismatch"

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2002-01-28 08:28:36
Subject: Re: Connection Problem
Previous:From: Hiroshi InoueDate: 2002-01-27 23:46:19
Subject: Re: SQLExecute get result to client?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group