Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is VARCHAR2?

434374Dec 10 2004 — edited Dec 13 2004
My question is this.....

1. What is the difference between VARCHAR2? form VARCHAR & CHAR?

2. Does VARCHAR2 is supported in ADO? What MDAC version?

3. Effect of changing CHAR to VARCHAR2 in tables in sp's.

thanks

Comments

Jim Smith
You additonal jar files and dlls for single sign-on See this thread
smitt
Answer
After reading the thread referenced by Jim Smith (thanks!), I wanted to copy the information to this thread...and update to state that these same steps work for SQLDeveloper 1.5.1 & SQL Server 2005. Don't miss step 5, if you want to enable NT Authentication.

{From referenced post}

Setting Up SQL Developer for MS SQL SERVER 2000

1) Install/Extract SQL Developer 1.2.1 in C:\Program Files\Oracle
Making the {$sqldevhome} = C:\Program Files\Oracle\sqldeveloper

2) Obtain the JDBC SQL SERVER Pluggin (jtds-1.2.2-dist.zip) from:
http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=25350

3) Unzip jtds-1.2.2-dist.zip
Creates: jtds-1.2.2.jar
\x86\SSO\ntlmauth.dll

4) Copy the jtds-1.2.2.jar into:
{$sqldevhome}\jlib Directory.

5) Copy the the ntlmauth.dll dll in the \x86\SSO subdir into:
{$sqldevhome}\jdk\jre\bin\ntlmauth.dll

6) In SQL Developer:
Go to Menu "Tools"
- Preferences...
Expand the "[+] Database
Choose "Third Party JDBC Drivers"
Click "Add Entry"
Then Browse for your copy of "{$sqldevhome}\jlib\jtds-1.2.2.jar"
Note: Use the jar filename, not its parent directory for entry.

7) Restart SQL Developer and try your SQL Server 2000 (or SQL Server 2005) Connection
Marked as Answer by 657146 · Sep 27 2020
user10594152
It works - thank you.... :)
8579
Thank you for adding this explanation!
Roy Prowell III
This worked for me also. In my case, it took me a moment to find the jlib directory.

C:\Program Files\sqldeveloper\jlib

Once I have that figured out, it worked exactly the way that it used in on a previous laptop.

Thanks for the instructions.
694659
Thank you very Much... It Works..
Roy Prowell III
I think that it is not possible, but it never hurts to ask. Can SQL Developer running on Linux be configured to use Windows Authentication against an MS SQL database?
745391
I have a case when I need to connect using Windows authentication using a network username/password , I am on a another network


sqldeveloper is unable to do it,
because when you check windows authentication it disables the username/password field and tries the credentials of your machine

AguaData studio is able to do it, it accomodates domain/username other that your machine login for authentication

any ideas how to do it in sqldeveloper

Edited by: user1327538 on Apr 7, 2010 9:02 AM
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 10 2005
Added on Dec 10 2004
#general-database-discussions
8 comments
1,057 views