materix
|
Posted: 04/29/2005, 10:12 AM |
|
Hi.
Is it somehow possible to create a connection in CCS to a "database" consisting of a plain text-file?
|
|
|
peterr
Posts: 5971
|
Posted: 04/29/2005, 11:05 AM |
|
Yes, if you have the right driver. I'm not sure if there are any reliable ones for text files, but you can try: http://www.google.com/search?hl=en&lr=&q=ado+connection+string+text+file
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
materix
|
Posted: 04/29/2005, 1:48 PM |
|
Hi Peter. I found this http://support.yessoftware.com/files/CodeChargeFAQ.html?#_Toc517263830, which is exactly what I am looking for.
Except, that the extension of the file that I am trying to read is *.dat.
If I try to test with files with extensions *.txt and *.csv then everything works perfect. But if the extension is *.dat then codecharge does not display any available fields for the tables.
|
|
|
peterr
Posts: 5971
|
Posted: 04/29/2005, 1:56 PM |
|
CCS actually doesn't know where it is connecting and which database is using. The information is provided to CCS by the database driver and the connection string. I suspect that the driver supports only specific files and extensions. You may want to try contacting the ODBC driver vendor or their support (Microsoft?), or search MS knowledge base or the Internet.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
materix
|
Posted: 04/29/2005, 3:28 PM |
|
Just for your info, I have located the cause of this problem.
In the registry there is a attribute for disabled extensions:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions
Most likely DisabledExtensions is set to:
!txt,csv,tab,asc,tmp,htm,html
! meaning those are the enabled extensions. So when I added dat to the list then everything works fine.
|
|
|
|