ADO Connection - Fails - Unspecified Error
- From: "Jack" <jack@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Dec 2005 19:53: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 anyone see this before??
Jack
.
- Prev by Date: Re: Stored procedure output problem in ASP
- Next by Date: Re: Windows 2003 sp1: Roll back to MDAC 2.8
- Previous by thread: Re: OleDbException for Opening a database
- Next by thread: Re: Windows 2003 sp1: Roll back to MDAC 2.8
- Index(es):
Relevant Pages
|
|
