Using the Data Control to control ODBC database ?
Quote:
>> Hi,
>> Is it possible to use the VB Data Control to access
>> the ODBC database ? If we can use VB Data Control
>> to access ODBC database, is that meant that it is
>> possible to develep a Front End without any VB ODBC
>> programming (ie, no need to use VB ODBC APIs) ?
>> If it is true, can I simply Open an ODBC database
>> and the RecordSet and assign it into the property
>> inside the Data Control.
>> Thanks,
>> Jerry.
>> --
>> -
>> --
>> ---
>> -------------------------------------------------------------------
>> Dept. of Computer Science, Off.Tel: (852)-2358-8836/2358-7028
>> HKUST, Clear Water Bay Road, Off.Fax: (852)-2358-1477
>> Hong Kong. Pager: (852)-7131-3111 Call 9977
>Yes
>Set the connect property and the recordsource and you're away, eg
>data1.connect = "DSN=WLC;UID=loginname;PWD=password;"
>data1.recordsource = "select * frmp emp order by ename"
>This is assuming that you have set up the ODBC driver called WLC and any
>other underlying protocols,etc (eg for Oracle you generally need SQL*NET
>and then TCP/IP, etc)
>Greg Vinall
>Systems Analyst
>NSW Dept Land and Water Conservation
Hi,
I am using the data control with ODBC conecting to Sybase SQL anywhere.
I use it to load a few grids with some Icons, but once the recordset is
closed, it doesn't drop the connection to Sybase.. This is a bummer as I
only have a 32 connection license.
Any Ideas ?
C.
--
--
Craig P. S{*filter*}
Rugby,
Warwickshire,
England
