Hello, I'm trying to set up a New Data Source to SQL Server through ODBC and
am getting the following error message after trying to supply correct SQL
Login ID and Password:
Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'xxxxxxxxx'
Re: How to have SQL_ERROR returned from RAISERROR within IF-BLOCK ... The problem has been fixed in SQL Server 2005. ... even modify the sequence of ODBC function calls and checking of the return ... I want to return SQL_ERROR to my application with a custom error message... I get it returned fine when I execute the following statement using ... (microsoft.public.data.odbc)
Re: sql server + ODBC: error suppressed ... I have a program that connects to SQL Server through ODBC, one of my clients... no error message is displayed either (which is strange and it works fine on ... are there any configuration parameters on sql server or ODBC... (microsoft.public.sqlserver.server)
Linked server to ODBC dsn..... ... Using my favorite ODBC sql query tool, i can select the System DSN, specify ... i go into SQL Server, and want to create a linked server to this same ODBC ... the error message really shouldn't matter. ... (microsoft.public.sqlserver.server)
UPDATE query gives Incorrect Syntax error ... I'm running SQL Server 2005 Express Edition. ... LastUpdated, allows nulls)... My VB application connects via ODBC no problems. ...error message.... (comp.databases.ms-sqlserver)
Re: Connecting to a sql server database ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ...sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ... (microsoft.public.dotnet.general)
