OLE DB Connectstring to DB2
I cannot find this any where.
Right now I am using odbc but need to switch to OLE DB.
[155 byte] By [Alex] at [2007-11-9 18:51:55] 
What is the connectstring for connecting my VB object to db2.
I cannot find this any where.
Right now I am using odbc but need to switch to OLE DB.
«« How do I call a DB2 stored proc on Mainframe from an AIX client
»» Help - reading CLOB data from VB/ADO
»» Help - reading CLOB data from VB/ADO
# 1 Re: OLE DB Connectstring to DB2
Hi Alex,MyConnectString = "PROVIDER=IBMDADB2; DSN=myDSN; UID=myUser;
PWD=myPassword"
The connection builder, available from the dataenvironment designer, or
on an ADODC control on a screen, would also build a string for you from
prompts.
--Greg
Alex wrote:
> What is the connectstring for connecting my VB object to db2.
> I cannot find this any where.
> Right now I am using odbc but need to switch to OLE DB.
Greg Nash at 2007-11-12 0:00:56 >
# 2 Re: OLE DB Connectstring to DB2
check out this website for a free connection string builder.http://www.complete-pc-solutions.com/FreeStuffHome.htm
M
Greg Nash <gnash@namoicotton.com.au> wrote:
>Hi Alex,
>
>MyConnectString = "PROVIDER=IBMDADB2; DSN=myDSN; UID=myUser;
>PWD=myPassword"
>
>The connection builder, available from the dataenvironment designer, or
>on an ADODC control on a screen, would also build a string for you from
>prompts.
>
>--Greg
>Alex wrote:
>
>> What is the connectstring for connecting my VB object to db2.
>> I cannot find this any where.
>> Right now I am using odbc but need to switch to OLE DB.
>
MPoone at 2007-11-12 0:02:02 >
