Noob - How to use csv file

[racassel]

I will probably end up buying the book, however I would like to play a little with a csv file. The instructions are very sketchy at best. Error is when I try to create report query Select * from test

 

Error is the active connection is not of type JDBC. How do I make it JDBC?

 

Thanks so much. Once I get past this I can have some fun. :)

[racassel]

Is a JDBC / ODBC connection necessary to get this working with a CSV File? One would assume you can setup a csv database and just start working. Please advise. PS. I will still probably buy the book, but some help out here would be greatly appreciated!

 

 

I was able to get it working, but only by creating an ODBC connection. I created the data source type JDBC Connection.

 

JBDC Driver: sun.jdbc.odbc.JdbcOdbcDriver

JDBC URL:jdbc:odbc:mydata

 

Server Address:192.168.1.101

database: mydata

 

Username: anything

Password: anything