Click here to Skip to main content
15,300,160 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

Can anyone tell me how I can connect to an external database which is situated in my university using a VB 2008 form?

and...

How can I get VB 2008 to check if an object is in the database and if it is then show all the fields of that object?

Thanks in advance
Posted
Updated 10-Aug-10 12:33pm
v2
Comments
Dalek Dave 10-Aug-10 18:33pm
   
Minor Edit for Readability

Depends on the database you are using. MySql? SQL Server 2000? 2005? 2008?

You need to check the system tables for information on what objects the database contains. You connect to an external database using a connection string, which typically contains the server name, the instance name (if the default instance is not used), the default database, the username, and the password. If there is a firewall or something blocking direct access to your database, you can create a web service to expose database data to the outside world. Google will help you with a lot of that (I underlined a few phrases you may want to start with).
   
Comments
hamza_786 10-Aug-10 20:44pm
   
i have checked the name and it says it is 'MySQL 4.0.20'
AspDotNetDev 11-Aug-10 3:03am
   
Probably best to start Googling and let us know what you find out! :-)
Can you specify which db?

There are several options.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900