2. ASPRunnerPro General questions
  3. [SOLVED]  Import CSV failure
This topic is locked
[SOLVED]

 Import CSV failure

 		4/7/2008 10:09:56 PM
ASPRunnerPro General questions
M
 msrushton author

Trying to import a CSV file I get.
Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/bhk2/BlackHawks_import.asp, line 56
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
Page:

POST 3095 bytes to /bhk2/BlackHawks_import.asp
POST Data:

error '80020009'

Exception occurred.
/iisHelp/common/500-100.asp, line 223
Sergey Kornilov admin 4/8/2008

Make sure you setting WRITE pemissions for IUSR_... user on temporary import directory. I guess your CSV file wasn't uploaded to the web server.
M
 		msrushton author 4/8/2008

Hi,
I set the IUSR... to administrator and it made no difference
Sergey Kornilov admin 4/8/2008

I recommend you to upload your application to Demo Account and send the URL to support@xlinesoft.com along with a sample CSV file.
M
 		msrushton author 4/8/2008

Hi,
I have done that, so will se what the response is.
I get a different error on the demo site than on my P.C.
I think I don't have the right driver on my P.C. How can i check?
M
 		msrushton author 4/9/2008

If I cahnge line 56 of import.asp
to this
strConn = "Driver={Microsoft Text Driver (.txt; .csv)};Dbq="+sPath+";Extensions=asc,csv,tab,txt;"
CSV importing now works.
I don't know enough about ODBC to know what the difference is...
strConn = "DBQ=" & sPath & ";DefaultDir=" & sPath & ";Driver={Microsoft Access Text Driver (.txt, .csv)};DriverId=27;Extensions=txt,csv,tab,asc;FIL=text;MaxBufferSize=2048;MaxSc

anRows=25;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes

;"
D
 		diazpty 4/12/2008

Thanks I replaced the strConn statement and it worked for me also.
strConn = "Driver={Microsoft Text Driver (.txt; .csv)};Dbq="+sPath+";Extensions=asc,csv,tab,txt;"
next thing will be to fix the .xls import statement.