From: David Weiss <david@i-active.com>
To: pgsql-interfaces@postgreSQL.org
Subject: ODBC Error with VB5.0
Date: Wed, 30 Dec 1998 17:14:59 -0800
Message-ID: <000701be345a$fc6dae20$dba443d1@graveyard.i-active.com> (raw)
Hello, I am getting an "ODBC Error 3146 Driver does not support this function" when using the following code in vb5.0
It doesnt seem to like the Set RecSet = db.OpenRecordset(sqlString, dbOpenDynaset)
Public Sub Main()
Set ws = CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC)
Workspaces.Append ws
Set db = ws.OpenDatabase("PostgreSQL", dbDriverNoPrompt, False, _
"ODBC;DATABASE=savvyshopper;UID=;PWD=;DSN=PostgreSQL")
frmMainMenu.Show
End Sub
Public Sub SavvyInit(db As Database)
sqlString = "select * " & _
"from adds " & _
"where storeid='106' and pricedesc='2.49';"
Set RecSet = db.OpenRecordset(sqlString, dbOpenDynaset)
frmAdDesign.txtDescription = RecSet!storeid.Value
End Sub
Any suggestions? :)
Thanks,
David Weiss david@i-active.com
+====]=================================================>
Legal Warning: Anyone sending me unsolicited/commercial/junk/spam e-mail
WILL be charged a US $500 proof reading fee. DO NOT send unsolicited
advertisements and do NOT add my e-mail address to your list(s)!
"By US Code Title 47 Sec.227(a)(2)(B) a computer/modem/printer meets the
definition of a telephone fax machine. By Sec.227(b)(1)(C), it is
unlawful to send any unsolicited advertisements to such equipment.
By Sec.227(b)(3)(C), a violation of the aforementioned Section is
punishable by action to recover actual monetary loss, or $500,
whichever is greater, for each violation."
+====]=================================================>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: david@i-active.com
Subject: Re: ODBC Error with VB5.0
In-Reply-To: <000701be345a$fc6dae20$dba443d1@graveyard.i-active.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox