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
- 9265 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikram
You can used DSN Less Code here (which is more usefull
andimportant insteated of using DSN Coz when you run that
Application on Different PC, then you have to crete DSN
again..)
DSN Less Code for Connection MS ACCESS: or can connect any
db just need to change its provider:
dim con as new adodb.Connection
con.open "provider=microsoft.jet.oledb.4.0;" & "Data
Source= ur db path (there is no space btn Folder and File
Name)"
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is ActiveX Document?
what are the Types of LockEdits in RDO?
What type of databases you can access through ADO Data Access Object?
How do I tell when an application executed using the SHELL command is finished?
What are the uses of List View Control?
What are the scope of the class?
How do I create a window with a small title bar as in a floating toolbar?
What are 3 main differences between flexgrid control and dbgrid control?
What do you know about user forms.
Is it possible to Access BackEnd procedures? Explain.
I'm getting error message "Reserved Error [-nnnn] ("There is no message for this error")" from Jet Engine 2.0.Why?
___,___ arguments will be used to run a executable program in shell function
How do I make a text box not beep but do something else when I hit the Enter key?
How to customize workgroup message?
What is the use of parameters collection?
