ODBC connection and constrain question

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET, Triggers, Constraints & Referential Integrity

dora — Sun, 30 Apr 2000 02:25:52 +0800 — source: Informix-list mailing list archive (1991-1998)

Hi All, I've some questions about the Informix database. I've some problems in connecting the ODBC with VB. I've setup the ODBC for the informix first. Then, when I try to use some VB coding to connect the Informix database, the connection is failed. Why I've this question? How to solve this question? More, After I have built some tables in the informix, but I find that some foreign keys are needed. How to add the foreign key without dropping the original table? Can I use add constrain to do it? If it can, what is the syntax of adding a constrain of the foreign key ? Thanks for anyone help!!!

↪ replying to dora

Ed Brown — Sun, 30 Apr 2000 20:36:31 -0500 — source: Informix-list mailing list archive (1991-1998)

What ODBC driver are you using? "dora" <swsleung@cs.cityu.edu.hk> wrote in message news:390B2930.6FB5F4C@cs.cityu.edu.hk... > Hi All, > > I've some questions about the Informix database. > > I've some problems in connecting the ODBC with VB. I've setup the ODBC > for the informix first. Then, when I try to use some VB coding to > connect the Informix database, the connection is failed. Why I've this > question? How to solve this question? > > More, After I have built some tables in the informix, but I find that > some foreign keys are needed. How to add the foreign key without > dropping the original table? Can I use add constrain to do it? If it > can, what is the syntax of adding a constrain of the foreign key ? > > Thanks for anyone help!!! > > >

↪ replying to dora

Art S. Kagel — Mon, 01 May 2000 13:22:03 -0400 — source: Informix-list mailing list archive (1991-1998)

dora wrote: > > Hi All, > > I've some questions about the Informix database. > > I've some problems in connecting the ODBC with VB. I've setup the ODBC > for the informix first. Then, when I try to use some VB coding to > connect the Informix database, the connection is failed. Why I've this > question? How to solve this question? > > More, After I have built some tables in the informix, but I find that > some foreign keys are needed. How to add the foreign key without > dropping the original table? Can I use add constrain to do it? If it > can, what is the syntax of adding a constrain of the foreign key ? ALTER TABLE ....... RTFM this is in the Guide to SQL Syntax at: www.informix.com/answers/english/alpha.htm then scroll down to section G Art S. Kagel