| Author: venkateswaran 03 May 2008 | Member Level: Silver | Rating:  Points: 2 |
How you want connect vb with access.There are two options 1.Using ADOC control and 2.Using mannual coding.
|
| Author: Olufemi 06 May 2008 | Member Level: Diamond | Rating: Points: 2 |
I am ready to help you but what try to give answer to what you are asked by Venkateswaran above and I will know where to start. To connect VB to access is very easy, is not a big deal.
But you need to carry us along with your desire and you will get good and well articulated help.
Olufemi
|
| Author: srinivas 16 May 2008 | Member Level: Gold | Rating: Points: 2 |
steps to connect to the Database in VB
Establish connection to SQL server.
Dim Conn As New ADODB.Connection
Conn.Open ("DRIVER=SQL Server;SERVER=10.0.10.1;uid=myUsername;DATABASE=Test;PWD=mypwd;")
in some computer it works but in some other computer it did not works. what i did was, go to control panel -> Administrative Tools -> ODBC -> create new datasourse to this server.
Thanks ,
Srini
|
| Author: b.thirumaya prabhu 04 Jun 2008 | Member Level: Gold | Rating: Points: 2 |
nice informations given already.
|