Solved

Connect to a GUPTA database with VB 4 PRO

Posted on 1997-03-27
1
222 Views
Last Modified: 2008-02-26
How can i open a database with extension *.dbs (i think it is a "GUPTA" database, it is used by Artemis Project View) with Visual Basic 4.0 Professional.
Do i need any particular driver for connection ?
I need to do this on a PC in wich another application exist written in Visual Basic (i think 3.0 version) of wich however i don't have the sources, therefore the eventual drivers should already be there.
0
Comment
Question by:bizio
1 Comment
 

Accepted Solution

by:
robp032697 earned 100 total points
ID: 1424772
DBS isn't a directly supported database type in DAO. But you probably already knew that. What you want to do is make an ODBC connection to the database. This is pretty easy and has the advantage that every database software company and their mothers makes ODBC drivers to connect to their database app.

First, make sure you have the proper drivers installed for ODBC on your system. If you're trying to access the database via 16 bit VB, you need to check the ODBC Administrator in the control panel. If you're doing it 32 bit, you need to look at 32-bit ODBC Administrator in the control panel.

Open the appropriate ODBC Admin and look at the Data Source Names. Got one that looks correct? Go on. If not, try the other admin app. You are limited to accessing the database by whatever db drivers have been installed, so in all likelihood, you will need to make your program be the same "bitness" as the original program that was accessing the database.

If there is no appropriate DSN in either administrator, you could try adding one to point to your database. The catch is that you need to have the correct drivers installed. Click on the Drivers button in each ODBC Admin to see if ione is listed that might work. If so, go ahead and add an ODBC entry for your database. Each driver asks for different info, but it ususally includes: a Data Source Name, the pathname of the database file, a default login, and a default password.

Now, in VB, for a quick & dirty connection drop a data control on your form, and set the connect string to:
ODBC;DSN=TEST;
Where TEST is the data source name you saw in the ODBC administrator.
Assuming you have a username/password to the database, you should now be able to access it. You can do a similar thing with DAO by using the same connect string when you create a Database object.

If you don't have the ODBC drivers for the database in question on your system, you might need to install whatever appropriate database software (Gupta or otherwise) onto your system from the original disks. I don't know about Artemis Project View, but a call to their tech support should give you at least the brand of database they use for their system.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB6 Compile Compatibility Issue 4 102
Access query that references subform 5 47
vb6 connector to mongodb 2 83
MS Access 03, TransferText, decimal places 8 69
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question