Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > Hard coded authentication possible?


Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2005, 12:15 PM
rcorrea's Avatar
rcorrea rcorrea is offline
Centurion
 
Join Date: Aug 2003
Posts: 188
Default Hard coded authentication possible?


I have a prog that connects to an Access database over the network, on a win2k server.

What I would like to do is code a username and password into the connection string so the program will authenticate as administrator.

The reason behind this is because the win2k server isn't part of our netware network, so the users are totally different. We mainly use the win2k server for IIS for our intranet.

I don't want to have to create every single netware user on the win2k server, its a beeyotch to make them match up.

Code:
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=\\ras\c$\access db\CompInfo.mdb;Username=Administrator;Password=blah" MyConn.Open


The above gives me an error, what am I doing wrong?
__________________
Love thy neighbor, or he'll shoot you.
Reply With Quote
  #2  
Old 09-01-2005, 01:47 PM
anthony_n's Avatar
anthony_n anthony_n is offline
Senior Contributor
 
Join Date: May 2005
Location: Manchester,England
Posts: 1,293
Default

change username to uid

for more info look here
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->