Driver for SQL Server report

[delu0007]

I am trying to create reports to run off of SQL Server databases. It is to be used through both a Visual Basic application and an ASP project. The reports will be based of off as many as 5 tables, most linked together with one non-linked table's information in the Page Header area. Which datbase driver should I use? I have tried ODBC, pdssql, and OLEDB. All give errors of some kind. The errors range from "General SQL Server error, check SQL Server log" to just strange displays. Once I link tables together some dates show up as 1/1/4294962583 12:00:00 AM, others show up just fine, and some text fields show up blank.

I have instances of each of these reports already created based on Access tables. Is there anyway to convert these to SQL Server based?

Thank You.

 

[bburnell]

I currently use The SQL Server driver for OLE DB (p2ssql.dll & p2lsql.dll). I have also been succesful with ODBC, DAO, and ADO as well though. Your problem sounds like a DSN/login problem to me.
Brett E-mail me at smsforce@smsforce.com

Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe