Re: Connection Problem

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"