September 10, 2002 at 10:30 pm
Hi,
I am executing an SP from Sql Server. This SP uses
sp_OACreate to connect to an VB DLL.
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.
September 11, 2002 at 3:23 am
How big is the file you're trying to open? Maybe SQL cant allocate enough memory? How about compiling an exe and running from a job? Or just instantiating the dll directly in a job? See if the behavior changes.
Andy
September 11, 2002 at 3:27 am
Hi,
If I make a VB EXE then It runs smoothly without any problem . This problem is there only from SQL.
September 11, 2002 at 3:31 am
This looks like the same message from http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6669&FORUM_ID=23&CAT_ID=2&Topic_Title=System+Resource+Exceeded&Forum_Title=General is this the same? And if not are you using a VB dll? If so can you post the code and the sp_OACreate line for how you tried to invoke it so I can test it here?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply