From: bryan_napier@mindspring.com 
To: pgsql-interfaces@postgresql.org 
Subject: Visual Basic/Data Environment Designer/PgODBC 
Date: Tue, 09 Nov 1999 23:00:45 -0500 

--------------------------------------------------------------------------------

I have looked through the mailing list and was unable to find anything
that matched my exact problem/dilemna, or anything that offered any
solutions, so I apologize in advance if this has already been addressed
(I am new to the mailing list :-( )...

Anyhow, on with my problem..

I am using Visual Basic 6.0 Enterprise w/ SP3 on a Windows NT 4.0 SP4
machine...  I have up till now been accessing databases resident on an
MS SQL 7 server...

Using the MS SQL 7 server I am able to go into the Visual Basic IDE,
enter the Data Environment Designer, and construct a simple Command with
the SQL Query Builder that constructs the following SQL query:

SELECT test_field FROM tbl_test WHERE (test_field=?)

And that will grab the necessary information about the test_field and
create a parameter for that command object...  This works great with
MS SQL 7...  However, when I do the same thing with Postgres, I get an
error message telling me "Unable to determine parameter information"...
Now, it still creates a parameter object for the command, it just
doesn't automatically detect the variable type, size, etc....  I can
still set the parameter options manually, set a value to the parameter ,
and run my query without error, it would just make life easier if
Postgres provided the VB DED with the information that it needs to
automatically detect this information..

Is this a bug in PgODBC, or is this one of Microsoft's many non-industry
standard  protocol "enhancements" that allows it to do this?

Thanks in advance!

Bryan Napier