SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 12:14 PM
| ||||
| ||||
 MS SQL using TSQL via JAVA jdbc Hello. I am having trouble finding a descent API for executing TSQL via JDBC. I have tried the Microsoft driver AND the JDTS driver's but get the same syntax errors. I am hoping there is a good solution also for executing scripts using the same. Any help is MUCH appreciated.Thx.      |
|
03-01-2008, 12:14 PM
| |||
| |||
| Re: MS SQL using TSQL via JAVA jdbc (asufty888@gmail.com) writes: > Hello. I am having trouble finding a descent API for executing TSQL > via JDBC. I have tried the Microsoft driver AND the JDTS driver's but > get the same syntax errors. I am hoping there is a good solution also > for executing scripts using the same. Any help is MUCH > appreciated.Thx. I believe that Datadirect's driver is good. Of course, the price is radically different than for Microsoft's driver or jTDS. Then again, if you gets the same syntax errors, maybe the problem is with your SQL code. Have you checked that it runs OK in Query Analyzer? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
03-01-2008, 12:15 PM
| ||||
| ||||
| Re: MS SQL using TSQL via JAVA jdbc On Feb 5, 10:15 am, asufty...@gmail.com wrote: > Hello. I am having trouble finding a descent API for executing TSQL > via JDBC. I have tried the Microsoft driver AND the JDTS driver's but > get the same syntax errors. I am hoping there is a good solution also > for executing scripts using the same. Any help is MUCH > appreciated.Thx. *No* JDBC driver will 'execute' T-SQL. They simply send it to the DBMS*. I suspect you are confusing the syntax of OSQL (eg: with 'GO' to send SQL) with actual T-SQL. Show the JDBC code and SQL and error you get. Joe Weinstein at BEA Systems * There is a small, well-defined area of JDBC SQL extensions which has the driver look for specific generic tags in the SQL for some functions, and replace them with correct DBMS-specific SQL. |
Linear Mode
