Page 1 of 1
Problem with SQL Server
Posted: Mon Sep 11, 2006 12:26 pm
by mmanes
Hi everyone,
How I'can made a connection with SQL Server?
Please help me!
Thank you
Posted: Mon Sep 11, 2006 12:37 pm
by thumsup9
Using an ODBC enterprise stage. Do you have a DSN. Create a DSN first and then use it on your ODBC stage.
Re: Problem with SQL Server
Posted: Mon Sep 11, 2006 12:59 pm
by prabu
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
Posted: Mon Sep 11, 2006 1:16 pm
by meena
ODBC enterprise stage or SQL server enterprise stage or Dynamic relational stage
Posted: Tue Sep 12, 2006 5:12 am
by mmanes
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