Progress database and VB

Progress database and VB

• Hedgeh0g

   Thank you Paul for your promt reply....

  Yes, I have Merant 3.60 32-bit Progress SQL92 v9.1C

  ODBC driver installed.

  But what can I do with it, how can I use it in my vb2005 express powered

  windows application to get data out of the database and to update existing data

  .....step by step instructions would be highly appreciated

       (I am totally new to these kind of things but willing to learn...)

  
  

• Juliana Low

  hi,

  There are different databases and you can connect to it through different provider to learn how to connect to your database you can follow this link

  http://msdn.microsoft.com/vbasic/reference/data/default.aspx pull=/library/en-us/dnsql90/html/mandataaccess.asp#mandataac_topic5

  to retrieve your data from your database is not a problem and nothing will change between one type of database and other except the Connection provider and the connection string as they told you, to learn the connection strings and the connection providers for many kind of databases you can check those links

  http://www.connectionstrings.com/

  http://www.carlprothman.net/Default.aspx tabid=81
  

  Regarding to your database name "progress" i never heard of it, but i hope if you check again may be its the name of the program that you run at your work but not the database type nor  the vendor name

  hope it was helpfull

  
  
  

• Vivekananda Parepalli

  Thanks for the links you provided, ........

  I'm not quite sure about the terminology I used concerning the word "progress",

  but our database application is made with Progress software,

  and makes use of "Progress" database....(.whatever that means...I really don't know.)

   

  Maybe you can visit the following site for more accurate information.

           http://www.openlinksw.com/support/conprog.htm

  (as a mentioned at the very beginning of my messages, I am totally new to databases

  etc., I'm taking the very first steps of programming database solutions, and I'm trying

  to find some answers to the very basic questions at first)

  
  

• Grant Jackson

  Pretty much everything you have learned about ADO.NET and accessing SQL Server will be transferrable to any other database.  The differences will be in the Data namespace you use and the connection string.  You should find out whether there is an OLEDB Provider for Progress or not.  If there is you would use OleDb instead of SqlClient and substitute the corresponding classes, e.g. OleDbConnection <=> SqlConnection, and almost everything else will be the same.
    You would have to use the appropriate ConnectionString for Progress though.  If there is no OLEDB Provider available then there will almost certainly be an ODBC Driver, so you can then use OdbcClient instead.
  
  

• jbender

  Yes, once you have your connection you should be able to execute queries using the ODBCDataAdapter and the ADO.NET data objects. Below is relatively simple example:

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdataodbcodbcdataadapterclasstopic.asp

  
  
  

• dbuchanan

   

  You're going to have to fill in the blanks a bit because I don't have your system info. The connection string should look something like the following:

  Dim ODBCConnection As New Microsoft.Data.Odbc.OdbcConnection

  ODBCConnection.ConnectionString = "DSN=PROGRESS;DB=PAYROLL;UID=JOHN;PWD=XYZZY;HOST=LOCALHOST;PORT=2055;"

  ODBCConnection.Open()
  '
  '
  '
  ODBCConnection.Close()

  
  
  

• dec716

  novice of the novices wrote:

  Yes, I have Merant 3.60 32-bit Progress SQL92 v9.1C ODBC driver installed. But what can I do with it, how can I use it in my vb2005 express powered

  If you have an ODBC driver then you can use the .NET ODBC provider. However, first you need to know what the connection string is for your Progress database. Below is an example which uses ODBC to connect to Oracle. Just replace the connection string below and verify that you can connect first:

  Dim ODBCConnection As New Microsoft.Data.Odbc.OdbcConnection

  ODBCConnection.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};" & _
  "SERVER=ServerName;" & _
  "UID=xxx;PWD=yyy;"

  ODBCConnection.Open()
  '
  '
  '
  ODBCConnection.Close()

   

  
  
  

• TDP

  Accessing a database typically requires a data access driver/provider of some sort. It can be ODBC, OLEDB or a native .NET provider or code library. I don't really know much about Progress, and Microsoft does not have a driver/provider for this vendor, but that is what you would need to start.

  It's possible that you may already have the software if you have existing applications that access Progress.

  
  
  

• antmx

  Now I have some basic knowledge of odbc stuff and VB, and where to start....

  Thank you guys for your helpful advice, links and code fragments.

  
  

• char_grill

  Do you have a database administrator Whoever configured your database should have the listener port information

  You could also try omitting this parameter. It's possible the DSN (Data Source Name) that is defined in your ODBC Data Sources (which is in the ODBC Data Source Administrator under the Control Panel Adminstrator Tools) already contains the Port information. Of course that assumes a DSN has already been created on your machine.

  
  
  

• giacomoread

   

  You're going to have to fill in the blanks a bit because I don't have your system info. The connection string should look something like the following:

  Dim ODBCConnection As New Microsoft.Data.Odbc.OdbcConnection

  ODBCConnection.ConnectionString = "DSN=PROGRESS;DB=PAYROLL;UID=JOHN;PWD=XYZZY;HOST=LOCALHOST;PORT=2055;"

  ODBCConnection.Open()
  '
  '
  '
  ODBCConnection.Close()

  Thanks for the above code fragment,...

  I'm trying to do something meaningful with it... if I can....

  propably I'll be back very soon with lots of questions...    

   

  I am here sooner than I expected...

  Before writing any code, I tried to configure the data source using

  Merant ODBC-driver setup.

  I filled all the required fields:

  datasource name, description, hostname, port number, database name, user ID and

  password.

  When trying to test the ODBC-connection, all I get is errormessage;

  "Error in Network Daemon",..... what does this mean.....

  What stands the Port and it's number 2055  for

  (I found in DataDirect's odbc-manual for Progress that port is for database listener process ,...

  I don't understand any of this listening thing...!)

   

   

  
  

• vitich

  Paul wrote...

  Do you have a database administrator Whoever configured your database should have the listener port information

  You could also try omitting this parameter. It's possible the DSN (Data Source Name) that is defined in your ODBC Data Sources (which is in the ODBC Data Source Administrator under the Control Panel Adminstrator Tools) already contains the Port information. Of course that assumes a DSN has already been created on your machine.

  I try to find out the database listener port information,.. I'll be back.

  
  

• Michael Gustafson

  It took a couple of days, but finally at last

  I got all the necessary pieces together (the port numbers etc..) and created

  ODBC datasource using the Merant odbc-driver for progress database.

  I succeeded in establishing the odbc connection, and no more errormessages

  concerning  the network daemon.

  So, now I should be able to develop a windows application in VB 2005 express-edition

  that can make use of the data stored in Progress databases, right     

   

  
  

• DavidDante

  Hello,

  I'm looking for Merant 3.60 32-bit Progress SQL92 v9.1C driver. Where can I download it for an evaluation

  Any help is greatly appreciated.

  Regards,

  Guillaume

  
  
• Progress database and VB