Click here to Skip to main content
15,896,201 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRemoting Pin
Member 76810120-Apr-04 7:28
Member 76810120-Apr-04 7:28 
GeneralRe: Remoting Pin
Klaus Weisser20-Apr-04 9:31
Klaus Weisser20-Apr-04 9:31 
GeneralRe: Remoting Pin
Member 76810120-Apr-04 10:38
Member 76810120-Apr-04 10:38 
GeneralRe: Remoting Pin
Klaus Weisser20-Apr-04 10:44
Klaus Weisser20-Apr-04 10:44 
GeneralDataRow Error? Not accessible because protected Pin
djsuperz20-Apr-04 7:21
sussdjsuperz20-Apr-04 7:21 
GeneralHelp with small program Pin
dcspock20-Apr-04 6:41
dcspock20-Apr-04 6:41 
GeneralRe: Help with small program Pin
Dave Kreskowiak20-Apr-04 11:32
mveDave Kreskowiak20-Apr-04 11:32 
GeneralVB 6 ODBC connection to SQL 2000 Pin
JumpinJimmy20-Apr-04 6:18
JumpinJimmy20-Apr-04 6:18 
I have a visual basic 6 application that needs some updating for a project moving from SQL 7 to SQL 2000. The application is an executable that users create shortcuts to on their desktops. The exe file resides on the same server as the sql 2000 database it needs to access. Previously users created an ODBC connection on their own Windows 2000 Professional workstations, and the application that resides on the server used a simple connection string of ...

oconn.open "DSN=MOL;UID=sa;" ( yeah I know this is bad, I inherited it this way )

... but now the server has been upgraded from NT4 to Server 2003, and the database has gone
from SQL7 to SQL2000. I have been experimenting blindly with new connection strings, and
am currently trying ...

oconn.open "Integrated Security=SSPI;Initial Catalog=MOL;Data Source=server_name_here;"

The error I get when I run this vb exe on my own workstation with an ODBC connection setup
to use SQL authentication (using a user/pass that is setup in SQL) is ...

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Being a newbie to VB and SQL, and given the fact that I inherited this app to try and fix it, I am wondering if this approach is totally wrong? There are roughly 10 users who need to create a shortcut to this VB exe file that resides on the same server as the database, and the appliction is used to make updates to the database. Thanks for any suggestions.
GeneralRe: VB 6 ODBC connection to SQL 2000 Pin
jimpar20-Apr-04 7:02
jimpar20-Apr-04 7:02 
GeneralRe: VB 6 ODBC connection to SQL 2000 Pin
JumpinJimmy20-Apr-04 10:01
JumpinJimmy20-Apr-04 10:01 
GeneralRe: VB 6 ODBC connection to SQL 2000 Pin
RichardGrimmer21-Apr-04 2:38
RichardGrimmer21-Apr-04 2:38 
QuestionDatabase connection error??? Pin
hounetdev20-Apr-04 5:07
hounetdev20-Apr-04 5:07 
QuestionHow do I autoupdate my application? Pin
ruseno20-Apr-04 4:08
ruseno20-Apr-04 4:08 
AnswerRe: How do I autoupdate my application? Pin
Michael Russell20-Apr-04 4:52
Michael Russell20-Apr-04 4:52 
GeneralStay inside MDI Client Area Pin
Michael Russell19-Apr-04 11:57
Michael Russell19-Apr-04 11:57 
GeneralRe: Stay inside MDI Client Area Pin
Dave Kreskowiak20-Apr-04 4:09
mveDave Kreskowiak20-Apr-04 4:09 
GeneralRe: Stay inside MDI Client Area Pin
Michael Russell20-Apr-04 4:47
Michael Russell20-Apr-04 4:47 
GeneralRe: Stay inside MDI Client Area Pin
Dave Kreskowiak20-Apr-04 5:31
mveDave Kreskowiak20-Apr-04 5:31 
QuestionHow do I Pin
KORCARI19-Apr-04 10:08
KORCARI19-Apr-04 10:08 
AnswerRe: How do I Pin
Daniel Turini19-Apr-04 10:28
Daniel Turini19-Apr-04 10:28 
QuestionHow do I Pin
KORCARI19-Apr-04 10:06
KORCARI19-Apr-04 10:06 
AnswerRe: How do I Pin
Dave Kreskowiak20-Apr-04 3:49
mveDave Kreskowiak20-Apr-04 3:49 
QuestionHow do I Pin
Anonymous19-Apr-04 10:00
Anonymous19-Apr-04 10:00 
GeneralPackage and Deployment Wizard VB6 Pin
krekre19-Apr-04 6:46
krekre19-Apr-04 6:46 
GeneralRe: Package and Deployment Wizard VB6 Pin
Roger Wright19-Apr-04 7:17
professionalRoger Wright19-Apr-04 7:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.