D
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?
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?