We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Connect to a GUPTA database with VB 4 PRO

bizio
bizio asked
on
Medium Priority
264 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.
Comment
Watch Question

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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.