Schema.ini With Adhoc ODBC Text File Connections 
Author Message
 Schema.ini With Adhoc ODBC Text File Connections

I've been able to use adhoc connections to ODBC Text file data sources
without a problem.  I've also been able to use the "linked server" bit
with ODBC defined text files.

However, I've got a collection of text files that's constantly updated
with new files (same format) every week.  Is there a way to create an
adhoc ODBC connection (OPENROWSET) that also includes the "schema.ini"
definition?  Otherwise, I'll have to write an application to rewrite
or append to the "schema.ini" file each week an updated text file is
added - it would be cleaner to do it all in SQL.

Thomas M. Blanchard, P.E.
Lockheed Martin Aeronautical Systems
Dept. 49-31, Zone 0426
86 S. Cobb Dr.
Marietta, GA 30063-0426




Sat, 23 Feb 2002 03:00:00 GMT
 Schema.ini With Adhoc ODBC Text File Connections

yeah, it would be nice if that was possible, I'm struggling with the same
problem.

Filip



Quote:
> I've been able to use adhoc connections to ODBC Text file data sources
> without a problem.  I've also been able to use the "linked server" bit
> with ODBC defined text files.

> However, I've got a collection of text files that's constantly updated
> with new files (same format) every week.  Is there a way to create an
> adhoc ODBC connection (OPENROWSET) that also includes the "schema.ini"
> definition?  Otherwise, I'll have to write an application to rewrite
> or append to the "schema.ini" file each week an updated text file is
> added - it would be cleaner to do it all in SQL.

> Thomas M. Blanchard, P.E.
> Lockheed Martin Aeronautical Systems
> Dept. 49-31, Zone 0426
> 86 S. Cobb Dr.
> Marietta, GA 30063-0426





Sat, 23 Feb 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Help! with Schema.ini file and ODBC text

2. ODBC Text Driver -- Schema.INI Problem !

3. Text File Databases/Schema.ini Limitation

4. Importing Text Files with Schema.ini and Execute SQL Missing first Record

5. ADO, Text Files and that damned Schema.ini

6. ODBC text schema.ini

7. Can't get Text ISAM to use SCHEMA.INI

8. Schema.ini File

9. Help -- Schema.Ini file format

10. SCHEMA.INI Must I use this file name???

11. How to ignore a column in Schema.ini file

12. schema.ini and multiple files


 
Powered by phpBB® Forum Software