What u prefer me to use wich edition as i heard microsoft windows sql 2000 enterprised edition work's only with windows nt so what sql should i use (better be free :>)
Printable View
What u prefer me to use wich edition as i heard microsoft windows sql 2000 enterprised edition work's only with windows nt so what sql should i use (better be free :>)
free , mssql express 2005.
Thx for info, download it its rly easy to use it. eh but now i got one problem can create dns server (srry for offtopic) dns server cant connect to sql server eh maybe u know what wrong and u can help me .thx in advance
any errors? u create file dsn or user dsn? Where your data sourses located? We are not telepats.
I create all server lin2world lin2db etc,etc the i go to administrative tools ->odbc->file dns ->add sql server i write the dns server name choise server (local) with nt authentication press next and i got error
"Microsoft SQl server login
Connection failed:
SQL state error:'01000'
[Microsoft][ODBC SQl server driver][shared memory]Connectionopened(connect())
Connection failed:
Sql state:'08007'
Sql server error:17
[Microsoft][ODBC SQl server driver][shared memory]SQL server does not exis or acces diened"
[Microsoft][ODBC SQl server driver][shared memory]SQL server does not exis or acces diened
but server rly exist and its up, i opened all pots tcp/ip and all other
It's SQL related, most likely to authentication (or an improper setup).
mm... Where your data sourses are located?
My data sourses are located in default direction c:\program files\Common files\ODBC\Data sources
btw with sql 2000 enterprise was everything oke im confused dont know what to do
ah made windows reinstall istalled IIS and windows microsoft express 2005.and got same error damn im confused
try to replace ur data sources to Program Files (x86)\Common Files\ODBC\Data Sources\
After windows reintall (i place files to c:\program files\Common files\ODBC\Data sources) i got this error Microsoft SQl server login
Connection failed:
SQL state error:'01000'
SQL server error:10061
[Microsoft][ODBC SQl server driver][TCP/IP sockets]Connectionopened(connect())
Connection failed:
Sql state:'08001'
Sql server error:17
[Microsoft][ODBC SQl server driver][TCP/IP sockets]SQL server does not exist or access diened"
Got any other idea,eh i wanna ask do mssql 2005 express edition works with x86 if not ...
Make sure your SQL server has remote access enabled (over TCP/IP) and make sure you supplied valid credentials (to an account that is allowed to remotely connect, usually defaulted).