Is it possible to execute queries such as the above with an adodb connection, across different databases? Sign in to vote. This becomes and issue when I am trying to manipulate some dates. It is better to query using the integer value of the dates and have a function to convert a Clarion Date to an Access date. Thanks JShankar, I had a feeling this was the case.

Uploader: Nikokree
Date Added: 18 December 2009
File Size: 61.88 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 75066
Price: Free* [*Free Regsitration Required]

Turns out I can import okay when I create a user dsn that specifies the topspeed file. Thanks, I will try to look into that when I return to work on Monday.

The reason softvelocity topspeed odbc concerns me is I am trying to move to automating this process without having to softvdlocity a file-specific DSN softvelocity topspeed odbc time. I guess I’m a little confused as to how to attempt that. Friday, November 28, 4: Promoting, selling, recruiting, coursework and thesis posting is forbidden. I have made some progress manually importing tables from the topspeed database into Access. Students Click Here Join Us!

I have tried different variations trying to get the date but softvlocity go.

However, if I create a user dsn using the odbc administrative tool and leave the the database field blank, it softvelocity topspeed odbc not work.

Thanks again immensely for the help. The Tek-Tips staff will check this out and take appropriate action.

ODBC For Clarion (Topspeed) Files

Hi, This should do the trick Help us improve MSDN. I get the error “invalid operand”. Close this window and log in. Thank you for helping keep Tek-Tips Forums free from inappropriate posts.

Any ideas on the reality of such an undertaking? You do deserve a Star.


I have looked at the Scalar Functions for Access. Here is another site with a bit more info ODBC. The content you requested has been removed. For awhile there I could not figure out why you had one double-quote in the toppspeed of your query. Thanks Guys, I’m passing this info to my boss in hopes that he doesn’t sink a lot of money into topspeed. I can select specific other fields but always fails on Date.

I would think softvelocity topspeed odbc I specify the file, it should work as well as the other dsn. Register now while it’s still free! Computers really drive me insane. Apologize if this is the wrong forum- please let me know.

It’s easy to join and it’s free. There are a lot better development softvelocity topspeed odbc and platforms available. The Topspeed ODBC has a problem with dates especially if sooftvelocity have set up the softvelocity topspeed odbc source to identify date fields.

SoftVelocity Topspeed ODBC Read-Only Driver

Got my answer – Found a site which lists all softvelocity topspeed odbc scalar functions. This becomes and issue when I am trying to manipulate some dates. Clarion stores the date as the no of days since Dec 28, e. By joining you are opting in to receive e-mail.