Sql Database Connection Extremely Slow

Legacy Poster

• 2014年07月17日 12:55

Hi

 

I have several existing labels and also some newly created ones.  The problem that I am having is that when I try to create queries, or connect to the database to view queries the system "times out" and returns an "OLE DB error - IDispatch error #3121".

 

I am running BarTender Enterprise Automation 10.1 SR3, with Windows 7 Professional (x64) with SP1 installed, the database is an existing SQL Database. Does anyone know of any issues between these applications, and any fixes available? (I have tries running Bartender in various compatibility modes in BarTender properties.

 

Any help would be greatly appreciated.

 

Thanks

LWalsh

1

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2014年07月17日 14:28

  Perhaps you should try using the client side cursor as a server side cursor can be slow in particular situations.  You'll find this under the "Options" tab of the "Database Setup" dialog.

  0
• 

  Noffie

  ★ BarTender Hero ★

  • 2017年05月31日 19:29

  See https://support.seagullscientific.com/hc/en-us/community/posts/216550907-Sql-Database-Connection-Extremely-Slow-Bartender-2016?page=1#community_comment_115004021488

  0

請登入寫評論。