To Mark: VB 4.0 & Oracle 7.3 slow ODBC

From: Ravi <donkeykong69_at_hotmail.com>
Date: Wed, 15 Jul 1998 13:52:40 -0500
Message-ID: <35ACFA78.3D07@hotmail.com>

Hello Mark,

Thank you very much for your prompt reply to my last question. I apologize for not being able to respond sooner but i was out of the country these last couple of weeks. As you suggested, I am sending you the OpenDatabase statement that I use in my VB 4.0 program to connect to an Oracle database. Thank you in advance for taking a looking at my problem!!

---

Dim sConnect as string
Dim ws as workspace
Dim db as database
Dim rs as recordset

sConnect = "UID=xpstudent1;PWD=sterling;DSN=OrclDSN"

Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("xpstudent1", False, False, sConnect)
Set rs = db.OpenRecordset("xpstudent1.REQUESTS", dbOpenDynaset)
---------------------------------------------------------------

Sincerely,

Ravi

>
>Hi Ravi,
>
>VB 4.0 have many methods, to connect to ODBC. Send me the OpenDatabase
>statment, I can analyse it.
>U must use RDO to make it Faster
>
>Mark
>
>> Hi there,
>>
>> The ODBC test program (that comes with Oracle) seems to retrieve the
data
>> from my oracle database quickly. However, I use the same DSN to
connect
>> via VB 4.0 and the application retrieves data extremely slowly, even
when
>> only
>> a single table is being accessed. Your help is much appreciated in
>> advance.
>>
>> Thanks,
>>
>> Ravi
>> donkeykong69_at_hotmail.com
Received on Wed Jul 15 1998 - 13:52:40 CDT