[vasuca]

I can setup ODBC connection to Netsuite instance and retrieve the data using Microsoft Access using linked tables.

I would like to do the same in a SQL Server through Linked Servers. Can somebody help me with the configuration settings to do that?

Specifically can i use the “Microsoft OLE DB Provider for ODBC Drivers” and if so what should be the settings for the following:

Product name:

Data Source:

Provider string:

Location:

Catalog:

If not what should be the Data source I should use?
This is a cached copy. Click here to see the original post.

[vasuca]

RE: Setting up Netsuite as Linked Server in Sql Server 2000

I got the answer once I posted the response.

Thanks

[Martyn]

Hi vasuca,

Would you care to post the settings? I’m trying to do the same.

Martyn

[markun]

RE: Setting up Netsuite as Linked Server in Sql Server 2000

We would also like to know how to do this.

[Georges Martin]

RE: Setting up Netsuite as Linked Server in Sql Server 2000

Here are my settings:

– Linked Server: NETSUITE

– Provider: Microsoft OLE DB Provider for ODBC Drivers

– Product Name: NetSuite.com

– Data Source: NetSuite.com

– Provider String: DSN=NetSuite.com

I left Location and Catalog empty.

I can browse and query the db, but it’s slow. Very, very slow.

If anyone has experience with SQL Server Replication, I would like to have some feedback.

We have some reports running in Access/Excel, but as soon as the queries are a bit complex, they run forever and finally fails with ODBC errors.

Thus, replicating data locally and running reports against the mirror woudl be a solution.

It would also help backing up (y)our data…

Georges Martin

[Author]

Posts