Re: ADO Connection - Fails - Unspecified Error

hi Jack!

I have had a quick look and I think what you will read here will be of
benefit: http://www.vbcity.com/forums/topic.asp?tid=3368

If you read through there are other links in the article that you also might
find useful.

HTH - Pace
"Jack" <jack@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uQe5Wg4$FHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
>I have a VB6 application that runs fine on all my machines but one. On
>this machine when I run the application (as an exe or in vb) I get an
>unspecified error for each of the ADODC controls that is referenced by a
>text box (the
> text box's datasource is the control and the datafield is a field in the
> table).
>
> This only occurs when there are items that reference the control and they
> reference a field.
>
> If I add a new text box and connect it to the ADODC (data Source) it is
> fine however if I drop down the list for the datafields I get the
> unspecified error.
>
> The ADODC uses a System DSN with a SQLServer driver. The DSN connects
> fine to the DB, I have used both Windows NT Auth as well as connect using
> sa. The ADODC's record source is a sql select (I tried both specifying the
> columns as well as select *).
>
> I can connect to the database using enterprise manager as well as the
> query tool and Excel. I am also able to connect and insert/delete data
> using SQL Query Analyzer, so I do not believe it is a permissions issue.
>
> If I manually create the connection and then step through the errors
> collection I get:
>
> Description: Unspecified error
> Source: Provider
> SQL State:
> Native Error: -2147467259
>
>
> I am not sure what to try next, has anyone see this before??
>
> Jack
>
>
>
>


.

Relevant Pages