I'm having trouble connecting via ODBC using the Microsoft text driver on a win2k box. 
 I read the KB article at 
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178717 and it seems to 
suggest that I should be able to select data from a text source.  Here is what I have 
so far:


$odbc = odbc_connect("cvalcoinput","","") OR die("There is an error connecting to the 
CSV file.");
$result = odbc_tables($odbc);

odbc_fetch_into($result, $fields)
$result = odbc_exec($odbc,"SELECT * from inputfile.txt");

odbc_fetch_into($result, $fields)

The connection and following tables commands work great, but when I actually select 
data via the odbc_exec command, I get the following error:

Warning: SQL error: [Microsoft][ODBC Text Driver] The Microsoft Jet database engine \
cannot open the file '(unknown)'. It is already opened exclusively by another user, \
or you need permission to view its data., SQL state S1000 in SQLExecDirect in \
***:\***\***\***\basecsv2.html on line 53

Any ideas?

-Ethan, Modulus, LLC

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to