Problem with SQL Server

mmanes · Post by **mmanes** » Mon Sep 11, 2006 12:26 pm

Hi everyone,

How I'can made a connection with SQL Server?

Please help me!

Thank you

thumsup9 · Post by **thumsup9** » Mon Sep 11, 2006 12:37 pm

Using an ODBC enterprise stage. Do you have a DSN. Create a DSN first and then use it on your ODBC stage.

prabu · Post by **prabu** » Mon Sep 11, 2006 12:59 pm

mmanes wrote:Hi everyone,

How I'can made a connection with SQL Server?

Please help me!

Thank you

try SQL server enterprise stage if you have 7.5x

meena · Post by **meena** » Mon Sep 11, 2006 1:16 pm

ODBC enterprise stage or SQL server enterprise stage or Dynamic relational stage

mmanes · Post by **mmanes** » Tue Sep 12, 2006 5:12 am

Is it correct?

[DNS Name]
Driver=/.../Ascential/DataStage/branded_odbc/lib/libodbc.sl
Description=DataDirect 4.2 SQL Server Wire Protocol
Database=DB Name
LogonID=user
Password=password
Address=xxx.xxx.xxx.xxx,1433
QuotedId=No
AnsiNPW=No

DSXchange

Problem with SQL Server

Problem with SQL Server

Re: Problem with SQL Server