Visual Studio 2008 New Query in Server Explorer doesnt show all fields

[syslock]

Hi

We're using Ingres 2.6 in our company and to access the data from VS2008 i'm using the driver from ingres2006-9.2.0-134-gpl-win-x86-DotNet.zip. It works well till the part where i list all fields from a table in a new query. I only see mostly 1 field.

Is the driver i'm using the wrong one or i missed some settings?

[thoda04]

Hi Syslock,

Are you saying that the VS2008 Query Designer is listing just one column in the checkbox list?

Dave

[syslock]

yes, just one column

[thoda04]

I have not been able to duplicate the behavior. What is the file version of the Ingres.Client.dll file on your system?

Can you post a copy of your CREATE TABLE syntax so that I can try to duplicate with your table definition?

Thanks,
Dave

[syslock]

file version is 2.0.920.11 and the create table syntax is:

CREATE TABLE mandant (
firma VARCHAR(2) NOT NULL,
werk VARCHAR(5) NOT NULL,
personal_nummer VARCHAR(10),
partner_id VARCHAR(6) NOT NULL,
beschrieb VARCHAR(50),
edat TIMESTAMP,
mdat TIMESTAMP,
benutzer VARCHAR(10)
);

[thoda04]

Still works for me. Test used Server Explorer -> right-click on the Data Connection -> New Query. Attached is the screen shot.

Dave

[thoda04]

Don't know if it will make any difference, but do you have VS2008 Service Pack 1 installed?

Dave

[thoda04]

I'm assuming that you are using a 9.2 database server, or are you using the 2.6 database server? I'm also assuming that your DAS server is also from 9.2.

Dave

[syslock]

We're using ingres 2.6