We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,530 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Connecting to DB2 databse

I am trying to connect to db2, but there is an error "system.data.oledb.oledbexception unspecified error"
and highlighted the line conn.Open() .
I want to know what are the prerequisites for the connection. Or simply my code is doing wrong???
Thank you for any help.

Dim Source As String
  Source = "Provider=IBMDADB2.DB2COPY1;Database=mydb;PROTOCOL=TCPIP;PORT=portnum;Hostname:host;"
  Source = Source & "uid=myid;Password=mypsw;"
  Dim conn As OleDbConnection                             
  conn = New OleDbConnection(Source)   
  conn.Open()
  .
  .
  .
  conn.Close()
2
Contributors
1
Reply
5 Hours
Discussion Span
5 Months Ago
Last Updated
2
Views
lkkkeith
Newbie Poster
4 posts since Nov 2007
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

Could be a security issue, see here:

http://forums.asp.net/t/1483203.aspx/1

pritaeas
Posting Prodigy
Moderator
9,316 posts since Jul 2006
Reputation Points: 1,178
Solved Threads: 1,467
Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0571 seconds using 2.68MB