Data Deploy 5.6 and SQL Server 2000

Hi,

I have installed Data deploy 5.6 and am trying to connect to SQL Server 2000. After entring details like database name, port n all, it throws an error stating "No tables returned" .

The database name, host and port (1433) seems to be right. Any idea as to how to go about solving this problem?

thanks
monica.

PS. This is very urgent !!!

Find more posts tagged with

Comments

Michael

Hey mon,

When does it throw this error message? Are you attempting to use DAS? Are you using iwdd.ipl and seeing it on the console. Perhaps you could provide a bit more detail / a copy of the output?

Cheers
Michael

Dwayne

A word of warning - I've no idea if this is related to your problem or not, but SQL server doesn't always use port 1433. That's the default port, but SQL server has this concept of multiple "virtual" servers, if you will, on the same physical server (I don't remember MS's name for it.) If you connect to the server as SERVERNAME\INSTANCENAME instead of just SERVERNAME, then the port won't be 1433.

--

Current project: TS 5.5.2/6.1 W2K

TimeSheetApproval.JPG

mon

Hi Michael n dwayne,

I aint using DAS. Am attaching the screen shots of the output...

And Dwayne, I doubt whether its got something to do with the port number cuz thru ODBC i try to connect using only the server name and it successfully connects.. the client configuration gives the port number for the instance that am using as 1433...

Prob i feel, connection is happening cuz otherwise it would throw some error related to connection which isnt the case.

Anyways, i'll check on the port number again and give it a shot...

Thanks,
monica.

mon

file is attached in this post.

mon

Well, i figured out the problem.. gotta configure MS JDBC Driver in datadeploy configuration files... (checked it out in one of the release notes)

Anyways, i tired using oracle n it works fine.

The configuration part of driver seems a lil confusing.. if nyone can help me out in that, it would be great..

Thanks
monica.