[lsokolove]

Trying to do this via the link server in MS SQL Server – Enterprise Manager. Has anyone successfully use the ODBC in MS SQL Server?
This is a cached copy. Click here to see the original post.

[bhollis]

RE: Using ODBC driver in Microsoft SQL Server 8.0?

I was able to set up a linked server in SQL Server 2005, but performance was a major issue.

I have also tried linking tables in Microsoft Access using the ODBC Driver and it would give me on “OpenRDA” error when I tried to access any records beyond 10,000. I tend to believe there is an issue with the ODBC driver or SSL as I see numerous user posts with this same issue as well.

[mattamoore]

RE: Using ODBC driver in Microsoft SQL Server 8.0?

Can someone give some brief instructions on how to set up the linked server in SQL 2000?

I have the ODBC connection but can’t seem to get the views in SQL.

[mshuman]

RE: Using ODBC driver in Microsoft SQL Server 8.0?

I setup a link server in SQL Server 2005, but it was very slow. A query I was able to do in seconds (returning only 22 rows) with MS Access took over 25 minutes in SQL Server with a link server before I killed it.

Any ideas why Access performs so much faster than a SQL Server connection?

[longlam]

RE: Using ODBC driver in Microsoft SQL Server 8.0?

Originally posted by mshuman

I setup a link server in SQL Server 2005, but it was very slow. A query I was able to do in seconds (returning only 22 rows) with MS Access took over 25 minutes in SQL Server with a link server before I killed it.

Any ideas why Access performs so much faster than a SQL Server connection?

Are you doing a link or are you downloading the database to your local computer? I found that it is almost impossible to do any sort of complex joins with a linked database connection but if you make a copy of it on your local computer, it works wonders.

[Author]

Posts