Topic: DataCleaner Having Problem to Preview NVARCHAR value
DataCleaner Having Problem to Preview NVARCHAR value
Hi all,
I am trying to do the validation of a set of nvarchar data. When i selected the column and try to preview by clicking on the "Preview Data" all NULL value shown.
Can anyone help me on this?
I am trying to do the validation of a set of nvarchar data. When i selected the column and try to preview by clicking on the "Preview Data" all NULL value shown.
Can anyone help me on this?
Which database are you using?
Bump, just saw that the email notifications had been turned off by mistake! :-( So I'll repeat myself for the sake of notification!
Which database are you using?
Which database are you using?
hey, i am using SQL Server 2005
I just remembered that I needed to reply to this post.
SQL Server is one of the most odd databases to interact with from Java because there are multiple drivers and multiple ways to connect, depending on the auth methods etc.
Anyways, enough of the bad excuses - just wanted to say that I will try and look into this issue soon, but it's something that takes a bit of time for me because I don't have it installed already.
SQL Server is one of the most odd databases to interact with from Java because there are multiple drivers and multiple ways to connect, depending on the auth methods etc.
Anyways, enough of the bad excuses - just wanted to say that I will try and look into this issue soon, but it's something that takes a bit of time for me because I don't have it installed already.
Hi again,
Sorry for the late reply but I finally had a SQL Server 2005 to do some tests on.
I don't see any problem connecting to the server. I am also able to both profile and preview NVARCHAR columns.
I use the JTDS driver ("SQL server + Sybase" in datacleaner's menus).
My connection string is like this:
jdbc:jtds:sqlserver://myserverhostname
And I supply a username and password, no catalog.
Sorry for the late reply but I finally had a SQL Server 2005 to do some tests on.
I don't see any problem connecting to the server. I am also able to both profile and preview NVARCHAR columns.
I use the JTDS driver ("SQL server + Sybase" in datacleaner's menus).
My connection string is like this:
jdbc:jtds:sqlserver://myserverhostname
And I supply a username and password, no catalog.
O ok thanks. I will try it. Hopefully it works
Log in by clicking the login link at the top of the screen
Go back to forum.
