The Web Interface
hi guys,
I'm trying with the Trial version of SS Enterprise Edition .
And found this very useful function in ss called "The Web Interface"
http://community.screen-scraper.com/web_interface
however, when i testing it i always got a error message when ss trying to insert data as
"error while trying to connect - java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
-the server model had started, the small logo on the right coner
-i have odbc.jdbc driver manager installed
-i have source name invoked
any idea what's going on?
Thanks
Max
Well, I want to make sure I
Well, I want to make sure I understand the setup.
It sounds to me like the web interface is working, but when you run your scrape, you see that error message, right?
I think the problem is that your scrape is trying to use the JDBC driver, but screen-scraper can't find it.
If that is the problem, this is the solution:
You need a file called "sqljdbc.jar" . (If you search on google, you can probably find very quickly.) You must place that file into your "[ScreenScraperInstallFolder]/lib/ext" folder. Screen-scraper will then know how to use SQL methods that come from the JDBC driver.
Let me know if that helps at all!
Tim
Thx Tim, I switched to
Thx Tim,
I switched to jdbc:mysql and it works now.
Max
Awesome-- I'm glad to hear
Awesome-- I'm glad to hear it! I had to battle with the same problem a while ago :)