EOF Returned For oConn.OpenSchema( adSchemaForeignKeys ) On SQL Server 2K

[Dan]

Environment: Windows XP Pro, IIS 5, SQL Server 2000
oConnectionString = 'driver={SQL
Server};server=(local);uid=sa;pwd=;database=mydatabase;'
Relationships are setup on all the tables.


EOF is returned for the recordset when using:
oRecordSet = oConnection.OpenSchema( adSchemaForeignKeys )

This works when using an Access2000 database, but not for SQL Server 2000.
What's wrong?

 

[Dan Sikorsky]

Just fixed it. The conn string must be
'provider=SQLOLEDB.1;server=(local);uid=sa;pwd=;database=mydatabase;'

 

[Aaron Bertrand - MVP]

You might also consider using ADOX (several examples at www.aspfaq.com) or
the INFORMATION_SCHEMA views.