you can try this for the perticular user in sql 'Set con = New Conn

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.

Question Posted / vikas gupta`

6 Answers
9336 Views
I also Faced
E-Mail Answers

Answer Posted / vikas gupta`

you can try this for the perticular user in sql

'Set con = New Connection
'con.ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=account;Data Source=."
'con.Open
'Set rec = New Recordset
'rec.Open "select * from acc_details", con, adOpenDynamic,
adLockOptimistic

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by provider?

1929

__ no of controls in form.

1515

How would you activate animation control?

2386

How would you create your application in DHTML?

1967

State about the different types of visual basic data?

1097

How can you Add API functions to your Application?

2173

Is it possible to call oracle database through ADO control or Object?

1829

Scope of API's can be of types, what are they?

2278

I have several megabytes of memory. Why do I get an "out of memory" error?

1573

What is ActiveX Dll and ActiveX Exe?

2213

How can you filter out specific type of file using file system controls?

1907

What is executenonquery in vb net?

964

How many ways you can access file using VB?

1039

What is instantiating?

1878

Explain about creating VB applications in excel?

1127