Loading Profile...
Twitter,
Facebook, or email.
I’m
frustrated
MS SQL Connection
When connecting to MS SQL, I see the databases but no tables listed. What am I doing wrong?
Official
Response
-
EMPLOYEE
2We have reproduced the problem with no tables when connected using ODBC driver. We'll try and solve it for the next release (I am afraid it won't be for the Early Access 4 though).
I was able to connect using JDBC driver with Windows Authentication, but I needed special dll library to do so. The dll is "sqljdbc_auth.dll" which is included in MS SQL JDBC driver archive (http://www.microsoft.com/downloads/de..., press Download, download Eula, then finally download the jdbc driver archive and look for dll inside), but we'll try and include it in the next release (probably in Early Access 4). This library should be in C:\Windows\system32 or any directory listed in PATH variable.
I used the "jdbc:sqlserver://localhost;integratedSecurity=true" format without any specification of instanceName (should be fine, unless you have to specify the instanceName).
This is just a hot fix of the problem. I think we'll be able to provide better solution soon.
-
Hello,
may I ask you, whether you use ODBC to connect to MS SQL or MS SQL JDBC driver shifted with DQ Analyzer?Comment -
-
Tried both, same results either way.
-
-
Here is the ODBC Value: jdbc:odbc:ITSQL2K5-TEST which connects to the SQL Server and I see the databases but no tables under each database.
-
-
I’m
frustration
This is the server instance: ITSQL2K5\TEST
This is the database name: TemplateDB
I am using Windows Authentication so it uses my network login and password.
Can you tell me what the MS SQL JDBC Driver 2.0 connection URL string should look like? -
-
This is my format which I use to connect using the JDBC driver to master database on my localhost MS SQL:
jdbc:sqlserver://localhost;databaseName=master, but even using the host name without specifying any database, I am able to connect and browse all the database I am allowed to on the server, so I usually use simply jdbc:sqlserver://localhost.
So your JDBC URL should look like jdbc:sqlserver://ITSQL2K5\TEST;databaseName=TemplateDB or just jdbc:sqlserver://ITSQL2K5\TEST
What am I more intersted in is your usage of Windows Authentication, I am trying to figure out any problem caused by wrong shifted permissions. What version of MS SQL server do you use? -
-
-
-
Sorry, I just confirmed and that server is SQL 2005...hence the 2K5 in the name of the server. My bad!
-
-
Martin,
Based on your response, we tried this string:
Jdbc:sqlserver://itsql2k5;instanceName=Test;integratedSecurity=true;
Now we get a new error message about the URL/Driver combination not being correct. -
-
EMPLOYEE
2We have reproduced the problem with no tables when connected using ODBC driver. We'll try and solve it for the next release (I am afraid it won't be for the Early Access 4 though).
I was able to connect using JDBC driver with Windows Authentication, but I needed special dll library to do so. The dll is "sqljdbc_auth.dll" which is included in MS SQL JDBC driver archive (http://www.microsoft.com/downloads/de..., press Download, download Eula, then finally download the jdbc driver archive and look for dll inside), but we'll try and include it in the next release (probably in Early Access 4). This library should be in C:\Windows\system32 or any directory listed in PATH variable.
I used the "jdbc:sqlserver://localhost;integratedSecurity=true" format without any specification of instanceName (should be fine, unless you have to specify the instanceName).
This is just a hot fix of the problem. I think we'll be able to provide better solution soon. -
-
I’m
thankful!!! AND Excited!
Martin,
First off . . . SUCCESS. Using the sqljdbc_auth.dll info you sent AND using this connection string:
Jdbc:sqlserver://itsql2k5;instanceName=Test;integratedSecurity=true;
Life is Good! Connecting and will begin profiling. -
