creating a report from sql server no dsn

[ferlin55]

I created an access front-end to a sql server database and I'm stuck trying to generate a report via a event procedure. I purposely am not using linked tables and instead connect to the DB using a ADO
connection string. I cant figure out how to base a report on a query where the tables are not linked. I want to be able to use a ADO connection string to query the db and base a report on it. How do I do this?

Any ideas would be extreamly appreciated!!!


Thanks


Seth

 

[ferlin55]

This should be easy. I should be able to assign the text boxes on the report values based on the query. I cant figure out how to assign the control source or value of the textbox manually?

 

[ItIsHardToProgram]

ONce connection is made you need the right SQL string, no?

 

[ferlin55]

I'm able to connect and query the db just fine. The problem is getting the textboxes on the report to have values based on the query. Seems like it is impossible to assign the text boxes values manually or to base the report on a query using a dsn-less ado connection.

 

[cmmrfrds]

It would be possible on a Form since you could return a recordset to the Form recordset object. I don't think this is supported for a Report.

Why can't you connect/link through odbc?

 

[ferlin55]

I'm trying to avoid having to set up a DSN for each person using the front end. It was working great until I tried to create reports. Is there a was to create a access query that uses ADO and isnt dependent on linked tables?

 

[cmmrfrds]

You don't have to setup up a DSN on each persons PC to use odbc.

Here are a couple of threads that explain a little.
thread183-1226714
thread705-1214980

 

[ItIsHardToProgram]

Oh for a report it is probably indeed tricky, I misread.

 

[ferlin55]

I'm using the DSN-less method in my forms but how to do it in a report?

To connect of the forms I use -
Driver{SQLServer};Server=sqlserver;Database=projects;Uid=;Pwd=

Is there a way to set this up to work on a report?

If there is, I could have the query connect and have the report on based upon that.