View previous topic :: View next topic |
Author |
Message |
arcray Valued Contributor
Joined: 13 Jul 2001 Posts: 242 Location: Aude, France
|
Posted: Mon Jan 13, 2003 2:40 pm Post subject: A VDSDB Query |
|
|
I use the VDSDB.DLL to access an Access database and have managed to suss out all the connection strings required.
But I'd now like to read and write data to Excel files and Text files using the ODBC drivers available in most Windows installations.
However I am finding great difficulty in tracking down what syntax the connection strings should have i.e.
Code: |
REM The LIST listdsns has already been created earlier in the code
%a = c:\dev\data
LIST ASSIGN,listdsns,@DB(drivers)
%1 = Microsoft Access Driver (*.mdb)
%2 = Microsoft Excel Driver (*.xls)
%3 = Microsoft Text Driver (*.txt; *.csv)
IF @EQUAL(@COUNT(listdsns),0)
WARN You have no odbc drivers installed! System will stop.
STOP
ELSE
IF @MATCH(listdsns,%1)
DB SETUP,%1,DSN=Flight,UID=admin,PWD=,DataDirectory=,DBQ=%a\flight.mdb
WARN A new Access Database is being created for the Data Tables. Please WAIT!
DIALOG CURSOR,WAIT
WAIT 30
ELSE
WARN You do not have a %1 installed
STOP
END
IF @MATCH(listdsns,%2)
DB SETUP,%2,DSN=Bordereau,UID=,PWD=,DBQ=%a\flight.xls
WARN A new Excel Spreadsheet is being created for the Bordereau. Please WAIT!
DIALOG CURSOR,WAIT
WAIT 20
ELSE
WARN You do not have a %2 installed!@CR()We'll attempt to install a text database for Bordereaux!
IF @MATCH(listdsns,%3)
DB SETUP,%3,DSN=BorderText,UID=,PWD=,DBQ=%a\
WARN A new Text file is being created for the Bordereau. Please WAIT!
DIALOG CURSOR,WAIT
WAIT 20
ELSE
WARN You do not have a %3 installed!
END
END
END |
Can anyone point in the direction of some documentation for what these connection strings should say?
Thanks in advance _________________ Andrew GRAY
If you don't know I am looking for work, I won't get the job.
andrewrcgray.com |
|
Back to top |
|
|
Vic D'Elfant Past Contributor
Joined: 26 Jun 2002 Posts: 673 Location: The Netherlands
|
|
Back to top |
|
|
arcray Valued Contributor
Joined: 13 Jul 2001 Posts: 242 Location: Aude, France
|
Posted: Tue Nov 25, 2003 12:25 pm Post subject: |
|
|
Hoochhh!
I have tried there! Microsoft want to encourage other methods of accessing data and thus have withdrawn any sort of sensible help on the MSDN pages...
Unless you know better? _________________ Andrew GRAY
If you don't know I am looking for work, I won't get the job.
andrewrcgray.com |
|
Back to top |
|
|
Vic D'Elfant Past Contributor
Joined: 26 Jun 2002 Posts: 673 Location: The Netherlands
|
Posted: Tue Nov 25, 2003 12:30 pm Post subject: |
|
|
No...
Vic _________________ phpBB Development Team |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can attach files in this forum You can download files in this forum
|
|