ActiveReports ADO question

[Jeff Carlin]

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

[moyalt]

Dear Jeff,

I'm sorry that I can't help you with your problem, but can you please tell me how can I start learning sql server ?

Thanks.

ps. do I need a server computer to use the sql 7 program ?

[Jeff Carlin]

Moyalt-

There is a book named "Using SQL Server 7.0" by Wynkoop and published by Que. It is a good learning tool, plus it has a 120 day evaluation version of SQL Server bundled with it. This means that you do not have to buy SQL Server for 120 days, giving you some time to learn it.

You can run SQL Server on a Windows 9X machine by installing the Desktop Version of the product.