UNSAON PAG CONNECT VB6 TO MSSQL????

[radieux_scablem]

---

Try use ADO or ODBC connection string...

[radieux_scablem]

"Driver{SQLServer};Server=Your_Server_Name;Databas e=Your_Database_Name;Uid=Your_Username;Pwd=Your_Pa ssword;"

[soulripper]

if you want to hard code try this:

Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim StrConnect As String, StrQuery As String

StrConnect = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=your_database.mdb"


Set cn = New ADODB.Connection
cn.Open StrConnect

Set rst = New ADODB.Recordset
rst.Open StrQuery, cn, adOpenKeyset, adLockReadOnly

[radieux_scablem]

if you want to hard code try this:

Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim StrConnect As String, StrQuery As String

StrConnect = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=your_database.mdb"


Set cn = New ADODB.Connection
cn.Open StrConnect

Set rst = New ADODB.Recordset
rst.Open StrQuery, cn, adOpenKeyset, adLockReadOnly

The above is a correct ado connection all u have to do is to change the connection string since its designed for access just follow my example above!!!

[mclaine]

up!!!!!!!!!!!!!!!!!!!!

[ErapGuapo]

try ni siya bro...

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

[johnsital]

try ngari bro ay. naa ngari tanan :ConnectionStrings.com - Forgot that connection string? Get it here!

hope maka help ni nmo...

[P_Borgke]

goggle it bro ..if u want to achieve something try to be resourceful...programmers are resourceful..

[johnsital]

tama ka bro pero basin dli pa siya hanas unsaon pag search bro mao ni ask lang sa siya. Like how to use the correct keyword in searching in order to get the nearest answer to his query.. tagail lang sa og chance gud bro. maka learn ra lagi ni siya sa kadugayan.

[istoryansucks]

na ai ebooks for this