473,320 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

connect db2 7.1 os/2 warp 3 connect to Win2k

I'm having some trouble being able to connect to my db2 server (it lives on
an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net
2003. Any suggestions?

I have a local user account on the server "readonly", i have created a user
in the database of "readonly" and I can connect through the command line,
but from within visual studio .net 2003 I cannot make a connection. Better
stated: I can make a connection but I cannot create data adapters - I can't
get any data from that connection.

I can see it in my server explorer, I can browse the tables and fields, but
as soon as i try to drag some fields onto my form it asks for my username
and password, which I enter, and then I get the following error:
"ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
supplied is incorrect.
SQLSTATE=08004

ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed."

I'm going crazy - what am i doing wrong?
Nov 12 '05 #1
4 3903
"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10************@corp.supernews.com...
I'm having some trouble being able to connect to my db2 server (it lives on an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net
2003. Any suggestions?

AFAIK, this is not a supported combination; in any case, I would not expect
it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later;
DB2's ODBC support is frozen at V2.5,. That at a minumum should be
sufficient to cause your second "error" (server doesn't support ODBC API).

You will need to use an API that is supported by DB2 for OS/2 V7.1, such as
native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2 is
frozen, it may be time to consider transitioning away from OS/2 to a
platform with DB2 V8 support, including support for the client API you wish
to use (see http://www.ibm.com/software/os/warp/strategy/).

I have a local user account on the server "readonly", i have created a user in the database of "readonly" and I can connect through the command line,
but from within visual studio .net 2003 I cannot make a connection. Better stated: I can make a connection but I cannot create data adapters - I can't get any data from that connection.

I can see it in my server explorer, I can browse the tables and fields, but as soon as i try to drag some fields onto my form it asks for my username
and password, which I enter, and then I get the following error:
"ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
supplied is incorrect.
SQLSTATE=08004

ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed."

I'm going crazy - what am i doing wrong?

Nov 12 '05 #2
Isn't there some second opinion - some way to make it work??? Any types of
workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com...
"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10************@corp.supernews.com...
I'm having some trouble being able to connect to my db2 server (it lives on
an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net
2003. Any suggestions?

AFAIK, this is not a supported combination; in any case, I would not

expect it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later;
DB2's ODBC support is frozen at V2.5,. That at a minumum should be
sufficient to cause your second "error" (server doesn't support ODBC API).

You will need to use an API that is supported by DB2 for OS/2 V7.1, such as native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2 is frozen, it may be time to consider transitioning away from OS/2 to a
platform with DB2 V8 support, including support for the client API you wish to use (see http://www.ibm.com/software/os/warp/strategy/).

I have a local user account on the server "readonly", i have created a

user
in the database of "readonly" and I can connect through the command line, but from within visual studio .net 2003 I cannot make a connection.

Better
stated: I can make a connection but I cannot create data adapters - I

can't
get any data from that connection.

I can see it in my server explorer, I can browse the tables and fields,

but
as soon as i try to drag some fields onto my form it asks for my username and password, which I enter, and then I get the following error:
"ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
supplied is incorrect.
SQLSTATE=08004

ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr
failed."

I'm going crazy - what am i doing wrong?


Nov 12 '05 #3
Will the the IBM DD2 documentation serve as confirmation?

"The DB2 .NET Data Provider allows your .NET applications to access Version
8 DB2 Universal Database on Windows, UNIX, and Linux-based computers, and
Version 6 and Version 7 of DB2 Universal Database for OS/390 and z/OS via
DB2 Connect. "

You are using none of these servers

Full details are in the Application Development section of Concept, under
APIs - Windows - DB2 .NET.

The only "workaround" is to use a supported API. This means you cannot use
an API not supported by your DB2 for OS/2 V7 server.

"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10*************@corp.supernews.com...
Isn't there some second opinion - some way to make it work??? Any types of workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com...
"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10************@corp.supernews.com...
I'm having some trouble being able to connect to my db2 server (it lives
on
an os/2 warp 3 connect box) from my Windows2000 workstation using
vs.net 2003. Any suggestions?

AFAIK, this is not a supported combination; in any case, I would not

expect
it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later; DB2's ODBC support is frozen at V2.5,. That at a minumum should be
sufficient to cause your second "error" (server doesn't support ODBC API).
You will need to use an API that is supported by DB2 for OS/2 V7.1, such

as
native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2 is
frozen, it may be time to consider transitioning away from OS/2 to a
platform with DB2 V8 support, including support for the client API you

wish
to use (see http://www.ibm.com/software/os/warp/strategy/).

I have a local user account on the server "readonly", i have created a

user
in the database of "readonly" and I can connect through the command

line, but from within visual studio .net 2003 I cannot make a connection.

Better
stated: I can make a connection but I cannot create data adapters - I

can't
get any data from that connection.

I can see it in my server explorer, I can browse the tables and fields, but
as soon as i try to drag some fields onto my form it asks for my username and password, which I enter, and then I get the following error:
"ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
supplied is incorrect.
SQLSTATE=08004

ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's

SQLSetConnectAttr failed."

I'm going crazy - what am i doing wrong?



Nov 12 '05 #4
Fair enough. I sure appreciate your help.
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com...
Will the the IBM DD2 documentation serve as confirmation?

"The DB2 .NET Data Provider allows your .NET applications to access Version 8 DB2 Universal Database on Windows, UNIX, and Linux-based computers, and
Version 6 and Version 7 of DB2 Universal Database for OS/390 and z/OS via
DB2 Connect. "

You are using none of these servers

Full details are in the Application Development section of Concept, under
APIs - Windows - DB2 .NET.

The only "workaround" is to use a supported API. This means you cannot use
an API not supported by your DB2 for OS/2 V7 server.

"Development at American Savings" <de*@americansavingslife.com> wrote in
message news:10*************@corp.supernews.com...
Isn't there some second opinion - some way to make it work??? Any types

of
workarounds or anything?
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:c8**********@ngspool-d02.news.aol.com...
"Development at American Savings" <de*@americansavingslife.com> wrote in message news:10************@corp.supernews.com...
> I'm having some trouble being able to connect to my db2 server (it lives on
> an os/2 warp 3 connect box) from my Windows2000 workstation using vs.net > 2003. Any suggestions?
AFAIK, this is not a supported combination; in any case, I would not

expect
it to work. To start with, DB2 for OS/2 does not support ODBC V3 or later; DB2's ODBC support is frozen at V2.5,. That at a minumum should be
sufficient to cause your second "error" (server doesn't support ODBC API).
You will need to use an API that is supported by DB2 for OS/2 V7.1, such
as
native CLI. That means, ADO.NET is out. Alternatively, since DB2 for OS/2
is
frozen, it may be time to consider transitioning away from OS/2 to a
platform with DB2 V8 support, including support for the client API you

wish
to use (see http://www.ibm.com/software/os/warp/strategy/).

>
> I have a local user account on the server "readonly", i have created

a user
> in the database of "readonly" and I can connect through the command

line,
> but from within visual studio .net 2003 I cannot make a connection.
Better
> stated: I can make a connection but I cannot create data adapters - I can't
> get any data from that connection.
>
> I can see it in my server explorer, I can browse the tables and

fields, but
> as soon as i try to drag some fields onto my form it asks for my

username
> and password, which I enter, and then I get the following error:
> "ERROR [08004][IBM][CLI Driver]SQL1403N The username and/or password
> supplied is incorrect.
> SQLSTATE=08004
>
> ERROR [IM006][Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr > failed."
>
> I'm going crazy - what am i doing wrong?
>
>



Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Mohammed AlQuraishi | last post by:
Hi all, I'm trying to connect to an MS Access database using ADO.NET and C#, but I'm getting the dreaded "Microsoft Jet database engine cannot open the file 'x'. It is already opened exclusively...
0
by: Chetan | last post by:
I have setup an ODBC driver for my MySQL database and use a 3rd party program to connect to it. Everytime the software connects, the ODBC driver setup screen pops up. I have to click OK on it to...
1
by: ffoiii | last post by:
I am attempting to connect to a remote default instance of SQL Server 2k on Win2k using Enterprise Manager from my local host but receive a "SQL Server registration failed, timeout expired" error...
0
by: ohaya | last post by:
Hi, I've been researching this, and I'm not sure if what I'm trying to do is possible, but I thought that I'd ask: I have two webservers/websites. The first webserver/website is running...
1
by: Praveen | last post by:
Hi All, I have a server DB2 UDB V8 on sun box. and accessing the server using DB2 UDB client 7 from win2k system. Till now i used to login using db2inst1 user which a default user created by...
6
by: Jerry Orr | last post by:
We are trying to determine the easiest (and cheapest) way to get connections for about 50 Win2K workstations on our LAN to DB2 on a z/OS server. We could install DB2 Connect Personal Edition on...
2
by: bbxrider | last post by:
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine i have an mdb on win2k adv server machine and want internet read/write to it from both a non-windows, red hat, webserver...
1
by: http://www.visual-basic-data-mining.net/forum | last post by:
Hi, I am new here. I am facing a problem that I can't connect to MS Access with my Web application written in VB.Net. It gives me this kind of error: The Microsoft Jet database engine cannot...
11
by: Mikael Arhelger | last post by:
Hello, This has been posted a few times but still I could not find a way to connect to our database. We run DB2 Express on WIN2K server with XP clients. I can ping inside network and to the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.