ERROR:cannot open sql server
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
:confused:
Re: ERROR:cannot open sql server
check mdac version you are using on win98 and make sure you install the same version on win2k/xp.
Re: ERROR:cannot open sql server
How are you connecting to your SQL server? ADO, ODBC, etc.
Re: ERROR:cannot open sql server
well i have installed the same versions and am connecting crystal reports by adding crystal report control in vb
Re: ERROR:cannot open sql server
How did you establish the connection when creating the report? Did you use NT Authentication, or a SQL Server login?
Tg
Re: ERROR:cannot open sql server
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
:confused:
Re: ERROR:cannot open sql server
IF you are using sa no password (that's dangerous) then it's SQL Authentication, not Windows.
Tg
Re: ERROR:cannot open sql server
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.
Re: ERROR:cannot open sql server
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.
Re: ERROR:cannot open sql server
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 :confused:
Re: ERROR:cannot open sql server
But you havent told us how your report connects to SQL server?