ODBC And Windows 2000

[Nuffsaid]

Riddle me this Batman….

I have an ODBC connection to a SQL db I created in win 98 which works perfectly on the 98 machine.

I recreated the “EXACT SAME” ODBC connection on a Win 2000 Server box, and although I can connect to the db, not all tables are visible. It seems to be logging on to the db with some other credentials and not the ones I supplied in the ODBC setup (SQL Server authentication).

Anyone have a clue as to what’s going on ?????

Thx

Nuffsaid.

 

[chelseatech]

Win2k likes to conenct to a SQL server using NT authentication.

1) Start CR
2) Select Logon to DB manually before you use areport.

Does that give you the right table list? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Nuffsaid]

Chelsatech,

I think we're on to something here. When I open CR and select Log On, then select my ODBC data source, I'm not prompted for a user id or password. It just opens up and displays the tables. (Not the right ones mind you.) So I think your post about NT authentication is probably correct.

Now the question becomes, "How do I fix it"?

I find this a little wierd. I recreated another ODBC connection that points to a different SQL DB and that one works as expected.

Seems to be just this one database that's causing problems.

I tried creating a "Test" data source, but got the same results. If Data Base Rights were an isssue, I wouldn't be able to connect from the Win 98 box.

Still confused????

Nuffsaid.

 

[Nuffsaid]

Ok figured this one out.

Seems the set up was not "EXACTLY" the same.
The client config was set up for Named Pipes and not TCP/IP.
Made this change and all seems to be well.....

Nuffsaid.