On 20/02/06, Yiping Yang <[EMAIL PROTECTED]> wrote: > Thanks, Jelmer. It seems it's the problem of the database URL.
It's a bit odd that a URL problem is reported as "java.sql.SQLException: No suitable driver" but perhaps that is a bug in JMeter. I'll try and take a look and see if that can be fixed, as it's very confusing ... > I found out the db port and wrote the string like: > "jdbc:microsoft:sqlserver://22.22.22.22\abc:1436; DatabaseName=test; > SelectMethod=cursor" > I also tried this:" jdbc:microsoft:sqlserver://22.22.22.22:1436\abc; > DatabaseName=test; SelectMethod=cursor" > '\abc' is the db instance name, I'm not sure if it's correct or not to write > like this. If \abc really is the instance name, rather than just abc, try: jdbc:microsoft:sqlserver://22.22.22.22:1436/\abc; But I suspect you may need jdbc:microsoft:sqlserver://22.22.22.22:1436/abc; > > In JDBC request Sampler, I wrote a sql statement. > " SELECT ListNodeID > FROM listNode" > > But I got the following error: > > "HTTP response message: java.sql.SQLException: [Microsoft][SQLServer 2000 > Driver for JDBC][SQLServer]Invalid object name 'listNode'. > but it can't find out the table " Are you sure that the table listNode exists in the database? > Is the problem about Database URL? How can I specified the db instance > 'abc'? or something I need to specify in JDBC request Sampler? See above --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
