System Resource Exceeded

• venkatbvs

  SSC Enthusiast

  Points: 111

  More actions

  September 10, 2002 at 11:17 pm

  #80120

  Hi,

  I am executing an SP from Sql Server. This SP uses

  sp_OACreate to connect to an VB DLL.

  This is in a Cluster Environment.

  In the DLL I am creating the CSV.DSN file as given below

  Creating Of Text DSN "CSV.DSN" with the following Properties

  [ODBC] DRIVER=Microsoft Text Driver (*.txt; *.csv)

  UID=admin

  UserCommitSync=Yes

  Threads=3

  SafeTransactions=0

  PageTimeout=5

  MaxScanRows=25

  MaxBufferSize=2048

  FIL=text

  Extensions=txt

  DriverId=27

  DefaultDir=C: DBQ=C:

  2. After this I create the Schema for the Text files to be read

  with the Text Driver

  3. Then i Try to open a connection using the Text Driver

  I get the Error "SYSTEM RESOURCE EXCEEDED"

  [Microsoft][ODBC Text Driver] System resource exceeded.|Error

  Connecting to database. |[Microsoft][ODBC Text Driver] System resource

  exceeded.|-2147024882||.

  I am able to Invoke this DLL through VB and there is no error.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 11, 2002 at 3:24 am

  #436291

  Please dont cross post. See this thread:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6710&FORUM_ID=65&CAT_ID=1&Topic_Title=System+Resource+Exceeded&Forum_Title=Performance+Tuning

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn