forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


A VDSDB Query

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Product Support
View previous topic :: View next topic  
Author Message
arcray
Valued Contributor
Valued Contributor


Joined: 13 Jul 2001
Posts: 242
Location: Aude, France

PostPosted: Mon Jan 13, 2003 2:40 pm    Post subject: A VDSDB Query Reply with quote

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
View user's profile Send private message Send e-mail
Vic D'Elfant
Past Contributor
Past Contributor


Joined: 26 Jun 2002
Posts: 673
Location: The Netherlands

PostPosted: Tue Nov 25, 2003 12:16 pm    Post subject: Reply with quote

http://msdn.microsoft.com/? Rolling Eyes

Regards,
Vic

_________________
phpBB Development Team
Back to top
View user's profile Send private message Visit poster's website
arcray
Valued Contributor
Valued Contributor


Joined: 13 Jul 2001
Posts: 242
Location: Aude, France

PostPosted: Tue Nov 25, 2003 12:25 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Vic D'Elfant
Past Contributor
Past Contributor


Joined: 26 Jun 2002
Posts: 673
Location: The Netherlands

PostPosted: Tue Nov 25, 2003 12:30 pm    Post subject: Reply with quote

No... Sad

Vic

_________________
phpBB Development Team
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Product Support All times are GMT
Page 1 of 1

 
Jump to:  
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

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group