Re: VB - SQL SERVER problem
"Potter, Mark" <[email protected]> Wed, 20 Nov 2002 11:53:33 -0500
| Newsgroups | gmane.comp.windows.devel.vbcom |
|---|---|
| Message-ID | <[email protected]> |
What type of security do you have on sql? Mixed mode or Windows Integrated. In this setup you may have to setup sql in mixed mode and then setup a sql login. You will then have to give the sql login permissions to the database you need to connect to. You will use the sql login to connect to your db in vb. -----Original Message----- From: P. S. Manikandan [mailto:[email protected]] Sent: Wednesday, November 20, 2002 11:49 AM To: [email protected] Subject: [VBCOM] VB - SQL SERVER problem Hi, I am facing one problem while trying to connect sql server thru VB Scenario is this...i have my database installed in one machine which is one one domain... and i have installed my application in one machine which is not in domain all together. while trying to connect its failing . and also i tried connecting to the database server from the query analyser its getting connected. only thru our application its not getting connected. wat might me the problem..can anyone help me Thx and Regards Manikandan You can read messages from the VBCOM archive, unsubscribe from VBCOM, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the VBCOM archive, unsubscribe from VBCOM, or subscribe to other DevelopMentor lists at http://discuss.develop.com.