473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

ODBC driver can't read user data in sql server authentication mode

1
Hi,
A have a problem to make ODBC connection from ORACLE database to MS SQL Server.

I’ve already achieved to connect with sqlcmd. So the servers see each others and can communicate.
The ODBC driver fails at the authentication, because it can’t read the user and password data from the odbc.ini file.
I read that this happens because the odbc driver does not accept the authentication data if it’s stored in plain text, but there were no explanation how can I store data in an other way.

Environment:
ODBC driver: Microsoft ODBC Driver 11 for SQL Server
OS: ORACLE linux 6.5
Target database: MS SQL Server 2008 R2

This works:
Expand|Select|Wrap|Line Numbers
  1. sqlcmd -S address -U username -P password
odbc.ini file:
Expand|Select|Wrap|Line Numbers
  1. [SQL_LINK]
  2. Driver = ODBC Driver 11 for SQL Server
  3. Server = tcp:address,port
  4. UID = username
  5. PWD = password

Log file:
[
Expand|Select|Wrap|Line Numbers
  1. ODBC][913][1417453346.612341][SQLConnect.c][3654]
  2.                 Entry:
  3.                         Connection = 0x18f40a0
  4.                         Server Name = [SQL_LINK][length = 8 (SQL_NTS)]
  5.                         User Name = [NULL]
  6.                         Authentication = [NULL]
  7.                 UNICODE Using encoding ASCII 'UTF8' and UNICODE 'UTF16LE'
  8.  
  9.                 DIAG [28000] [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user ''.
I test with isql command.
Dec 3 '14 #1
0 1503

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: simianphile | last post by:
OK, I had a problem that I've now fixed but I can't really understand what was causing it in the first place. I have an intranet site that uses basic authentication to allow users to view and...
1
by: rguti | last post by:
Anybody know when the new version of the ODBC Driver is gonna be out? I'm using 3.51.11-1, but I'm having problems transferring information from SQL Server. Thanks.
8
by: Dakkar | last post by:
I wrote a program with c# for connecting mysql and taking data from it but when someone without me try to execute the program they are taking this error ERROR Data source name not found and...
2
by: Hal Heinrich | last post by:
Given a server name, and before logging on to the server - how can I tell if it's using Windows Authentication Mode or SQL Server Authentication? I'm retreiving a list of servers as follows: Dim...
0
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...
5
by: Jens | last post by:
Hello, I have been looking for some C-code which listens on a user-defined port for incoming data traffic. When data is received, the data is written to a file. I found some C-code (server)...
5
by: insomniux | last post by:
Hi, I need to install an ODBC driver for a database, but our system- administrator does not allow me to install it on the VPN-server. Is there a way to install an ODBC driver for a separate user....
6
by: jagguy | last post by:
Hi, i cant read in data from excel 97 using vb.net 2003. I get an exception error . all i want to do is read in values from excel initially. I want to just test it using msgbox. Dim XL...
4
by: Jeff | last post by:
I need to export MySQL data to Access. As always, there seems to be more than one way to do this. I notice that PHP has: DB.php If I was doing this in perl, there would be an ODBC driver...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.