Slow Data Connections

mjgazzo

I just started working with a client that is trying to import a large amount of Navision data to a sql server database from a remote location. The source is the MS business solutions for Navision database - not SQL Server.

The data transfer is extremely slow. The communication line is a T1 and pings very fast. I suspect that the DSN/driver is not configured correctly. When I tried to evaluate details of the DSN, DTS connections etc, it took over 5 minutes to connect on every ocassion. A simple table of 300 records required 12 minutes to transfer. Some information from the DSN configuration is as follows:

CODBC driver version 3.01.02.8097
net type is tcp
options: commit cache, enable blob and read/write are all checked.
option field is text.

Any insights as to what is causing the slow performance would be greatly appreciated.

Thank you

Mardy

Nats

Mardy,

For a similar situation in my company. I found the solution was the Roles given to the user id used in the ODBC connection. Once I gave full SUPER access, it worked out fine.

Hope this works for you.

mjgazzo

Nats

Thanks for the insight. I checked and the user ID has super access.

I ran some tests and found that on average it takes 3 minutes to import 1000 records into a sql server 2000 database. That's terrible. We're looking at options.

Thanks