ERROR:cannot open sql server

[mann0]

well i have created an application in VB6 sqlserver and reports are in crystal reports 8
i used windows 98 in my pc and now when i am trying to run my project in windows 2000 or Xp it works fine but when i click to generate a report i get an error message that sql server cannot be open. in win98 i dont get this error what should i do i need to run this in 2000 or XP
plz help

[larma]

check mdac version you are using on win98 and make sure you install the same version on win2k/xp.

[RobDog888]

How are you connecting to your SQL server? ADO, ODBC, etc.

[mann0]

well i have installed the same versions and am connecting crystal reports by adding crystal report control in vb

[techgnome]

How did you establish the connection when creating the report? Did you use NT Authentication, or a SQL Server login?

Tg

[mann0]

well i think i am using windows authentification using a blank paawords and sa as username in windows 98 dont know much about it
am new to alll this

[techgnome]

IF you are using sa no password (that's dangerous) then it's SQL Authentication, not Windows.

Tg

[RobDog888]

I think we are getting confused here, "windows authentification using a blank paawords and sa as username in windows 98"

Windows Authentication is when SQL takes your Windows NT Username and Password and "trusts" you to log in to SQL. SQL Authentication is when
you enter a separate username and password, even if the password is blank.

[ARPRINCE]

One thought is if you are using ODBC (for whatever reason) to connect to your SQL server, you may be missing the DSN on the other machines.

[mann0]

hi all
well if that sql authentification than what is the problem i cant get that
plz help me
i want to run that application on nwindows 2000 and it is of no use without thr reports
plzzzzzzzzzz help

[RobDog888]

But you havent told us how your report connects to SQL server?