Come impostare stringa di connessione di un dataenvironment

Article View: free.it.visual-basic

Article #2512

Back to free.it.visual-basic Previous Next

#2512

From: Luca
Date: Wed, 09 Apr 2003 12:08

33 lines
2198 bytes

Come cambio da codice il percorso di collegamento al database tramite un
dataenvironment?
Non basta questo:

DataEnvironment1.connection1.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\c:\prova\prova.MDB;Mode=ReadWrite;Persist Security Info=False"

Se scrivo solo cosi all'apertura mi dice che la non pu� farlo perche
l'oggetto � aperto, allora inserisco:

DataEnvironment1.connection1.close
DataEnvironment1.connection1.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\c:\prova\prova.MDB;Mode=ReadWrite;Persist Security Info=False"
DataEnvironment1.connection1.open

Il problema ora � che ora mi da un errore alla riga successiva:

DataEnvironment1.rscommand1.MoveFirst

Mi dice che l'oggetto � chiuso

Scrivo allora:

dataenvironment1.rscommand1.open
DataEnvironment1.rscommand1.MoveFirst

Ora l'errore � "Operazione non consentita per un oggetto che fa riferimento
ad una connessione non valida".

Perch� se imposto la proprieta connectionsource dalle proprieta della
connessione va e da codice no? Dove sbaglio?

Technical Details

Message-ID: <H2Uka.79123$Jg1.1864805@news1.tin.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,41822a9eb86a723f,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2003-04-09 05:28:01 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer2.atl.newshosting.com!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail
From: "Luca" <noce78@libero.it>
Newsgroups: free.it.visual-basic
Subject: Come impostare stringa di connessione di un dataenvironment
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <H2Uka.79123$Jg1.1864805@news1.tin.it>
Date: Wed, 09 Apr 2003 12:08:07 GMT
NNTP-Posting-Host: 80.104.63.153
X-Complaints-To: newsmaster@tin.it
X-Trace: news1.tin.it 1049890087 80.104.63.153 (Wed, 09 Apr 2003 14:08:07 MET DST)
NNTP-Posting-Date: Wed, 09 Apr 2003 14:08:07 MET DST
Organization: TIN