Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 12-11-2004, 11:55 AM   #1 (permalink)
cmartin2
Registered User
 
Join Date: Dec 2004
Posts: 1
cmartin2 is on a distinguished road
sql server 2000 validation problems

I am having trouble connecting vb program to sql server 2000 developer's edition database. Here is line I used in program to attempt to connect to database:

connect.Open "provider=sqloledb;server=falcon;database=unbound" , "jdoe2", "falcon2"

the error I receive from vb6 was: "log in failed for jdoe2,Reason:Not associated with a trusted sql server connection."

I gave account jdoe2 permission to access the unbound database in sql server 2000 Security folder. What am I doing wrong? Thanks for help. cm
cmartin2 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ms Sql 2000 ? sde Windows 4 05-14-2003 04:32 PM
SQL Server Worm -- Is It Just Me.... technobard Lounge 6 01-30-2003 02:53 PM


All times are GMT -8. The time now is 11:08 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting