SQL plug-in problem

Hi.

I downloaded the SQL plug-in.

We use JTDS in our application and thus I added the jar we use to the
SQL plug-in settings.

The connection URL we use in our application on my machine is:
jdbc:jtds:sqlserver://AGOVRIN-LDEV:1433;DatabaseName=webroot;instance=SQLEXPRESS;SelectMethod=Cursor

The connection URL as it appears in the SQL plug-in settings is:
jdbc:jtds:sqlserver://AGOVRIN-LDEV:1433

The connection is successful, but I can't see the tables in the database
or run queries, and it seems that the plug-in doesn't take into
account the instance of database name.

My server is SQL 2005 Express, JTDS v1.2 (latest).

Lastly, if you try and use a semicolon in (for example) the port for
JTDS the plug-in produces an exception while still in the settings dialog.

Please help.

Thanks,
Amnon

1 comment
Comment actions Permalink

Help, anyone? please? :)

Amnon I. Govrin wrote:

Hi.

I downloaded the SQL plug-in.

We use JTDS in our application and thus I added the jar we use to the
SQL plug-in settings.

The connection URL we use in our application on my machine is:
jdbc:jtds:sqlserver://AGOVRIN-LDEV:1433;DatabaseName=webroot;instance=SQLEXPRESS;SelectMethod=Cursor


The connection URL as it appears in the SQL plug-in settings is:
jdbc:jtds:sqlserver://AGOVRIN-LDEV:1433

The connection is successful, but I can't see the tables in the database
or run queries, and it seems that the plug-in doesn't take into account
the instance of database name.

My server is SQL 2005 Express, JTDS v1.2 (latest).

Lastly, if you try and use a semicolon in (for example) the port for
JTDS the plug-in produces an exception while still in the settings dialog.

Please help.

Thanks,
Amnon

0

Please sign in to leave a comment.