ADO Connection - Fails - Unspecified Error
- From: "Jack" <jack@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Dec 2005 10:20:59 -0600
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 any see this before??
Jack
.
- Follow-Ups:
- Prev by Date: Re: my First database - DAO and Access database - VB6
- Next by Date: Any way to open MDW workgroup file
- Previous by thread: my First database - DAO and Access database - VB6
- Next by thread: Re: ADO Connection - Fails - Unspecified Error
- Index(es):
Relevant Pages
|
|
