Oledb error

Hi all,
I've a problem with a custom VB6 application.
The program connects a Sql server via ADO, the code lines are:

Set aCon = New ADODB.Connection
Set aRs = New ADODB.Recordset
and the connectionstring is
"Provider=SQLOLEDB.1;User ID=USER;Password=PWD;Initial
Catalog=DBNAME;Data Source=SERVERNAME, SQL STATEMENT

This program works fine on MS Win 2k,Xp Home/Pro, but when I launch it
from Xp embedded (SP1 or SP2) I get the error "-2147467259 Unspecified
error".
I've tried to reinstall MDAC 2.8, re-register every ADO/OLEDB dlls, but
nothing change!

Could anyone help me???

Thanks.

.

Relevant Pages

  • Oledb error
    ... I've a problem with a custom VB6 application. ... The program connects a Sql server via ADO, ... Set aCon = New ADODB.Connection ...
    (microsoft.public.windowsxp.embedded)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)