UNSAON PAG CONNECT VB6 TO MSSQL????

[cruel_guy101]

---

HELLO MGA PEEPZ.. PATABANG KO.. TAGAE KO NINYO UG SAMPLE CODE BEH NGA VISUAL BASIC 6 I CONNECT UG MSSQL....

Note:

MSSQL HA dili MYSQL...

i have hear MYSQL VB CONNECTION NAMAN GUD.. I NEED MSSQL .... THANX A LOT

[godCode]

have you tried Google, the internet's well kept secret

[cruel_guy101]

yep, pero kasagaran i hatag sa google is mysql man gud...

[godCode]

pareho raman ang style nila pag connect, ang database name lang ang imo usbon.

[jerx d great]

mao!!

[knight26]

HELLO MGA PEEPZ.. PATABANG KO.. TAGAE KO NINYO UG SAMPLE CODE BEH NGA VISUAL BASIC 6 I CONNECT UG MSSQL....

Note:

MSSQL HA dili MYSQL...

i have hear MYSQL VB CONNECTION NAMAN GUD.. I NEED MSSQL .... THANX A LOT

@cruel_guy101

The connection that i'm using is ADO(ActiveX Data Object)
1) You have to download Microsoft Data Access Object @Microsoft's website. After downloading, install it to your machine.
2) Open VB6
3) Declare this to your module:
Dim Conn as New ADODB.Connection
4) Create a Procedure that will connect you to your MSSQL Server, like this:
Public Sub Conn
Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=[test];Data Source=[name of your MSSQL Server]"
Conn.Open
End Sub
5) Call this procedure to your form under the Load Event

[spookey]

bro, i think naa na daan active-x component ang vb6. just go to the tool bar.

Project -> References -> Microsoft ActiveX Data Objects 2.0 or higher version (I think kung naa ka MS Office 2003 installed naa ka automatic Microsoft ActiveX Data Objects 2.5 pero di ko sure)

Once na check to siya pwede na ka makadeclare sa imo application og Dim Conn as New ADODB.Connection

goodluck

[knight26]

bro, i think naa na daan active-x component ang vb6. just go to the tool bar.

Project -> References -> Microsoft ActiveX Data Objects 2.0 or higher version (I think kung naa ka MS Office 2003 installed naa ka automatic Microsoft ActiveX Data Objects 2.5 pero di ko sure)

Once na check to siya pwede na ka makadeclare sa imo application og Dim Conn as New ADODB.Connection

goodluck

Just in case ra to bro coz naa may instance nga ma corrupt ang MDAC.

[cruel_guy101]

ok bro. thanx kaayo.. ill try it here.... thanx for you inputs!

[cruel_guy101]

mga bro.. napa moy laing connectionstring diha? pls. i need some more...