Hi!

I was trying to open a SQL Server database from VB5.0.

1. Created a DSN

2. Using Opendatabase method, opened the database

3. Using Openrecordset method, i was trying to open a table in the SQL Server database

This gives an error saying,"Not a valid Stored procedure". then, i tried opening a stored procedure. But, i couldn't open a stored procedure also.

Anyone can help me to open a table(SQL Server) from VB5.0

Thanks in advance

Regards
smrenga