When connecting to my MS SQL Server database via the JDBC ODBC bridge, SQL Explorer logs me on as "guest" instead of my user name.
Is it just a bug (or a feature) that the JDBC ODBC bridge can't/won't pass my username/password credentials through?
I don't have any luck with the native driver either, it gives me "encounterd a problem: com.microsoft.jdbc.sqlserver.SQLServerDriver". The bridge will at least connect, though with the incorrect user name it's rather useless.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When connecting to my MS SQL Server database via the JDBC ODBC bridge, SQL Explorer logs me on as "guest" instead of my user name.
Is it just a bug (or a feature) that the JDBC ODBC bridge can't/won't pass my username/password credentials through?
I don't have any luck with the native driver either, it gives me "encounterd a problem: com.microsoft.jdbc.sqlserver.SQLServerDriver". The bridge will at least connect, though with the incorrect user name it's rather useless.
Is there a reason why you're using the JDBC-ODBC bridge to log on to SQL server rather than use the native JDBC driver from Microsoft?
PS - please feel free to file a bug report for this, including the versions of JDK, MSSQL, and the MSSQL ODBC driver you're using.
John