Database conectivity BEGIN FOR HELP PLEASE

[supra3]

Hi this is my first time here. If any one can help me this would be superb. I am struggling with connection to a database that will be located on a server.

I have connected to the database named DB1 on my C:\drive of my laptop. I have connected with the dataenvironment named DE1. Obviously theres the connection, Connection1. On DE1 I have commands wich have the insert statment, append and delete statments.

I need to create a logon screen this is easy vb6 has already has this made.
I am strugling with the connection string... I think thats what it is called. You see what I want to be able to do is have the database which is in ACCESS, located on a server. Then the vb6 application on the pc's. The pc's then each logon to the database which is on the server.
I have read books, searched the web. and I am almost defeated. please can anyone show me how this is done and please bare in mind I am only a novice.

thanks for the time

 

[zemp]

It all depends on how you want to connect and what objects you are going to connect with.

Bound controls vs unbound controls
ADO vs DAO
ODBC vs direct
etc., etc.

Take a look at faq222-3735 and faq222-4628.

Here are some free online tutorials that mat help as well.

http://www.vbexplorer.com/VBExplorer/databasetutorials.asp

http://www.freeskills.com/

zemp

 

[supra3]

thanks I will look at the tutorials later, I am a bit tired now.

I am only using the dataenvironment to connect, and displaying the data in a msflexigrid or textboxes nothing to major. So I think these are unbound controls

thankyou zemp

 

[zemp]

Do yourself a favour, if you are just learning take the time to learn ADO, don't worry about the dataenvironment.

ADO (Microsoft ActiveX Data Objects) can be used with all types of databases and gives you much more power and flexibility over your data and the database.

zemp

 

[zemp]

I ran accross this, if you are interested,

http://pages.cpsc.ucalgary.ca/~saul/vb_examples/tutorial4/index.html

I still recommend learning ADO.

zemp