Connection - ODBC

[D Willett]

Hi

I have a form with 3text controls.

Text1
Text2
Text3

I want to populate these texts with data from an ODBC source.
The data is a small table holding no more than 30 records of:

SiteCD ( Current Branch )
UserID ( Current User )
JobID ( Current Job I am Working On )

Without using any components adodc etc, can I populate these Text Controls?
( This is a start to a new login form for my project )

[HansV]

You can set a reference to one of the Microsoft ActiveX Data Objects m.n libraries, and open an ADODB connection and an ADODB recordset. You can then set the value of the text boxes to the value of fields in the recordset. Don't forget to close the recordset and connection when you don't need them anymore.

See ADO Connection String Samples or The Connection String Reference for examples of the connection string you need to open an ADODB connection to various kinds of data sources.

[D Willett]

Cheers Hans

Some useful information there.

Regards