Dynamic Links From SQL 7

[Joel E. Guay]

I looking for a way to dynamically link tables in SQL 7 from other databases. i.e. Progress or DB2/OS/400 or MS Access. I know using ODBC you can create a link in MS Access to tables in SQL 7. However, can you create links in SQL 7 to tables in MS Access or other databases.

Thanks,


Joel

[Ray Miao]

Create linked server in sql.


------------
Joel E. Guay at 6/20/00 11:57:33 AM

I looking for a way to dynamically link tables in SQL 7 from other databases. i.e. Progress or DB2/OS/400 or MS Access. I know using ODBC you can create a link in MS Access to tables in SQL 7. However, can you create links in SQL 7 to tables in MS Access or other databases.

Thanks,


Joel

[Joel E. Guay]

I created a linked server in sql to a System DSN ODBC to MS Access. I do not know what the schema or catalog parameters are suppose to be. From the EM I can see the tables in my Access database, so I believe the connection is working. However, when I run a simple select query
SELECT *
FROM ACCESSLINKED...LEVERS
against the the linked server I get the following:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.

Any recommendations as to what these paramaters should be.

Thanks,


Joel


------------
Ray Miao at 6/20/00 12:14:04 PM

Create linked server in sql.


------------
Joel E. Guay at 6/20/00 11:57:33 AM

I looking for a way to dynamically link tables in SQL 7 from other databases. i.e. Progress or DB2/OS/400 or MS Access. I know using ODBC you can create a link in MS Access to tables in SQL 7. However, can you create links in SQL 7 to tables in MS Access or other databases.

Thanks,


Joel