• 0
Sign in to follow this  
mestre fyoda

Conexao Ao Bd Sql Server 2000

Question

não sei nem começar , alguém poderia me dar um help ?

qual componente escolho , e o codigo de conexao .

eu tentei faze via ODBC mas não consegui .

Dados da ODBC :

Nome : Conexao

Description : --------

Server : Rafael

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

para aqueles q qerem mexer no sql com vb ai vai , consegui fazer os esquemas .

Global cn As ADODB.Connection

Global rs As ADODB.Recordset

Private Sub Main()

Dim strArquivo As String

Dim strLocal As String

Dim Conexao As String

Set cn = New ADODB.Connection

Set rs = New ADODB.Recordset

Set cn = CreateObject("ADODB.Connection")

Conexao = "Driver={SQL Server};" & _

"Server=RAFAEL;" & _

"Database=Biblioteca;" & _

"Uid=sa;Pwd=janio1;"

cn.Open Conexao

End Sub

depois vai em project -> references -> e habilita o -> Micrisoft ActiveX Data objects 2.6 Library

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this