vb prototype

  • Thread starter Thread starter Eric Clapton
  • Start date Start date
E

Eric Clapton

Can anyone please help me to build the VB code connect to a SQL 2000 server?
If you can give me a prototype, that will be very helpful? Thanks.
 
Add a reference to the MS ActiveX data object 7 and the MS Data Binding
Collection. Then paste this code behind a button:

Dim oConn As New ADODB.Connection

oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Network Library=DBMSSOCN;" & _
"Data Source=;" & _
"Initial Catalog=;"


Neil
 
And now the rest Herfried,

The least there is needed is
dim conn as SqlClient.SqlConnection = ("the connection string you get from
the link from Herfried).

:-))

Cor
 
Can anyone please help me to build the VB code connect to a SQL 2000 server?
If you can give me a prototype, that will be very helpful? Thanks.
Click to expand...

Please decide which version of VB you want to use (VB6 or previous vs.
VB.NET) and then refrain from crossposting to inappropriate groups. The
*.vb.* groups are for VB6 and earlier; the *.dotnet.* groups are for (what
else?) .NET.
 
Cor,

* "Cor said:
The least there is needed is
dim conn as SqlClient.SqlConnection = ("the connection string you get from
the link from Herfried).
Click to expand...

LOL... I am sure the OP has a brain too ;-).
 
Back
Top