Invalid Data Source

[Bebe]

I am using databound controls and am using the report designer in vb6. the program runs fine; however when trying to display the report on a PC that does not have Vb6 installed I get the error when trying to access the report only: Invalid Data Source.

The connection is pointing to the correct database and the rest of the program pointing to this same database runs fine .

Any ideas on what I am missing?

Thanks!!!

[SteveFlitIII]

Have you hard coded the data source name ? if not you need to create one on the PC.

[Bebe]

I am not sure how to hard code the data source name; how do i create one on the pc?

The database resides on a network that everyone has accesss to or example the path is "g:\appsvbd\apps\database.mdb"

[compuGEEK]

Try to verify that MDAC is installed....also, be sure to create a system DSN.

[Bebe]

well i found an answer, but not a good one. I hardcoded the data source, I added the mdb to the odbc in settings; nothing worked.

I then went back to my vb 6 disk and added the data access component; and it worked.

However i can find no reference to data access componentes 2.0 in vb6 so apparently I need to install this feature from the disc to every pc; not the whole vb6 program just the data access tools.

anyone know how to get around this let me know? im still a lamer!!!