🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: free.it.visual-basic
Article #1482

DB ACCESS CON PASSWORD E VB

#1482
From: Max
Date: Tue, 11 May 2004 14:41
26 lines
1892 bytes
Ciao a tutti,
cerco di stabilire una connessione ad un DB Access protetto da password di
seguito il codice che uso :

Option Explicit
Private cnnDatiSoc As New ADODB.Connection
Private strSQLDatiSoc As String
Private strConDatiSoc As String
Private rstDatiSoc As New ADODB.Recordset
Private Sub Form_Load()
    Resize Me
    strConDatiSoc = App.Path & "\db1.mdb"
    cnnDatiSoc.Provider = "Microsoft.Jet.OLEDB.3.51"
    cnnDatiSoc.Open strConDatiSoc, "Admin", "password"
    strSQLDatiSoc = "SELECT * FROM datisocieta "
    Set rstDatiSoc = cnnDatiSoc.Execute(strSQLDatiSoc)
    Set txtragsoc.DataSource = rstDatiSoc
    txtragsoc.DataField = "ragsoc"
    cnnDatiSoc.Close
    rstDatiSoc.Close
End Sub

Questo codice genera un errore quando deve passare la password del DB..... ?
Se elimino la password al DB va tutto bene, ma per motivi di sicurezza ho
bisogno che il DB sia protetto da password.
Come posso risolvere il problema ?
Technical Details
Message-ID: <c7qolu$i3d$1@newsread.albacom.net>
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news.caltanet.it!newsfeed.albacom.net!newsread.albacom.net!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII-7-bit
X-Google-Thread: f94ee,7b3222b8aff5bf34,start
X-Google-Attributes: gidf94ee,public
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news.caltanet.it!newsfeed.albacom.net!newsread.albacom.net!not-for-mail
From: "Max" <icetrap73@yahoo.it>
Newsgroups: free.it.visual-basic
Subject: DB ACCESS CON PASSWORD E VB
Date: Tue, 11 May 2004 16:41:51 +0200
Organization: Albacom S.p.A.
Lines: 28
Message-ID: <c7qolu$i3d$1@newsread.albacom.net>
NNTP-Posting-Host: 213.255.118.143
X-Trace: newsread.albacom.net 1084286462 18541 213.255.118.143 (11 May 2004 14:41:02 GMT)
X-Complaints-To: abuse@albacom.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165