Interested to Buy Any Domain ? << Click Here >> for more details...
CONNECTIVITY OF SQL 2000 + VB USING ODBC.
steps i Follow-
1) Go to Control panel-->Admintrative Tools-->Double -click
Data sources(ODBC)-->click Add button-->I choose SQL server
(last option), Is it right or wrong option for connecting
to SQL 2000.Then a new screen appears Create a New
dataSource-->in name textbox,we can write anyname--Right or
wrong. suppose i enter sonia, & my server name is .,so I
enter . in server & click next button-->On the Next screen
i have checked the option With Sql server authentication--
>Login Id-sa, Password-->Blank-->Click next button-->Next--
>Finish-->Then I click on button Test Data source-->Mesage
Comes TESTS COMPLETED SUCCESSFULLY-->OK-->OK-->Ok.
These steps we have to do or not for Connectivity using
ODBC.
If yes,then what after these steps we have to do??Plz reply
me early ??Thx in advance.
- 6 Answers
- 9319 Views
- I also Faced
- E-Mail Answers
Answer Posted / sri
You also can create the DSN Programatically as follows
Creating DSN Programatically
Private Sub ConfigDSN()
On Error Resume Next
#If Win32 Then
Dim intRet As Long
#Else
Dim intRet As Integer
#End If
Dim strDriver As String
Dim strAttributes As String
Dim msmdbpath As String
' sdPathName = App.path & "\PROJECT.mdb"
strDriver = "Microsoft Access Driver (*.mdb)"
strAttributes = "SERVER=" & Chr$(0)
strAttributes = strAttributes & "DESCRIPTION=OJAL Data
Souce Name" & Chr$(0)
strAttributes = strAttributes & "DSN=INT" & Chr$(0)
strAttributes = strAttributes & "DATABASE=" &
sdPathName & Chr$(0)
strAttributes = strAttributes & "MaxBufferSize=512" &
Chr$(0)
strAttributes = strAttributes & "PageTimeOut=5" & Chr$(0)
strAttributes = strAttributes & "DBQ=" & sdPathName &
Chr$(0)
intRet = SQLConfigDataSource(vbAPINull,
ODBC_CONFIG_DSN, strDriver, strAttributes)
End Sub
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you attach pictures in column headers of List View Control?
Explain about Caturing Baseline.
I have several megabytes of memory. Why do I get an "out of memory" error?
Types of cursors in DAO?
How do I make a text box not beep but do something else when I hit the Enter key?
How do I use GetPrivateProfileString to read from INI files?
which property of menu cannot be set at run time.
What are the Differenct Types of Instancing Property in ActiveX Dll and Exe?
what are the Types of LockEdits in RDO?
How would you create properties in ActiveX Control?
How do I access C style strings?
Types of Resultsets.
Draw Sequence Modal of RDO? Explain.
How would you create your application in DHTML?
Explain the types of Views in Listview Control?
