Trying to connect to DB2? New to this!
Posted: Mon 06 Oct 2014 15:26
Hi,
I am new to connecting and using databases. I am trying to test the dotConnect add-in for VS2013. I have systems that run DB2 and I need to write VB code interfaces to connect and look at data. I can connect using IBM Data Studio and run SQL queries. I downloaded and installed dotConnect to my Visual Studio 2013. During the install the dotConnect recognized VS2013. When I open the VS and create a new Form I can go to "Server Explorer" and make a data connection to my tools. Several folders appear under the connection, Tables, Views, Procedures, Functions. These folders don't appear to do anything or have anything in them. Double clicking them does not drill down into them. I can however select "New Query" over my database and an SQL window pops up that will let me search my database. This search works so I know I can connect to my database.
However, when I try to write code in the .vb window to make the connection the very first statements from your connection webpage are imports from Devart.Data, these statements gets marked as containing errors as if the system does not know they exist or as if the paths to these files are unknown. I tried to include the path in the Imports statement to the files but I received other syntax errors related to path I entered.
My question is, does this sound like the dot.connect add-in properly installed?
Thanks,
Radfox
I am new to connecting and using databases. I am trying to test the dotConnect add-in for VS2013. I have systems that run DB2 and I need to write VB code interfaces to connect and look at data. I can connect using IBM Data Studio and run SQL queries. I downloaded and installed dotConnect to my Visual Studio 2013. During the install the dotConnect recognized VS2013. When I open the VS and create a new Form I can go to "Server Explorer" and make a data connection to my tools. Several folders appear under the connection, Tables, Views, Procedures, Functions. These folders don't appear to do anything or have anything in them. Double clicking them does not drill down into them. I can however select "New Query" over my database and an SQL window pops up that will let me search my database. This search works so I know I can connect to my database.
However, when I try to write code in the .vb window to make the connection the very first statements from your connection webpage are imports from Devart.Data, these statements gets marked as containing errors as if the system does not know they exist or as if the paths to these files are unknown. I tried to include the path in the Imports statement to the files but I received other syntax errors related to path I entered.
My question is, does this sound like the dot.connect add-in properly installed?
Thanks,
Radfox