First, my opinion of AR is that it's a great product, but their support is dreadful. Typically, I have to wait 3-5 days for a return email.

Now to the problem:

I am using SQL Server for a VB6 project. I created an AR report using a ADO DataControl in the Detail section. I have set the properties as following:

ARrptSTD.DataControl1.Connection = PROJ_DB
ARrptSTD.DataControl1.ConnectionString = PROJ_DB.ConnectionString
ARrptSTD.DataControl1.Recordset = rsData

Before setting these properties, I opened rsData, a recordset. When the report is run, I get the following error:

Error 5000 : Error in processing report.
[ Extended Info:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

I am using the following as a ConnectionString:

Proj_db.ConnectionString = " Driver={SQL Server};" _
& "server=" & sServername & ";" _
& "Database=" & sDatabase & ";" _
& "uid=" & sUserID & ";" _
& "pwd=" & sPasswd

Can anyone help at all with this problem?

Thanks