im trying to set my odbc setting in my control panel

[dairene13]

but when i try to login this will appear can you hel me wat will i do to solve thid problem :sad::sad:

 

[a1boogie]

post pics step by step while using odbc and in background put the navicat or what ever ur using up so i can see what ur doing wrong

 

[rob_angel23]

yup u need to configured ur odbc settings....
here follow this steps:
start >>control panel>>data source(odbc)click>>system DSN>>add then scroll down choose SQL NATIVECLIENT click finish>>>
put the ff. info:

name: rangame1
description: u can leave it blank
server: ur sqlserver name

click next
choose between thetwo

>>>w/ integrated windows authetication (if u used default installtion of ur sql servermanagemenet studio

or

>>>w/ sql server authentication using a login id and password
(this implies on mixed mode)
login id: sa
password: ur password if u change the default(1234)

click next

change the default database to:

rangame1

click next

click finsih

the click TEST DATA SOURCE(it will display result if ur connection is successful or not) if successful click ok, then do it again on ranshop, ranlog and ranuser.. and if not double check ur settings....


tanx me if i help...

 

[GothicaM]

I have the same problem too.
this is what i did step by step.










btw i connected to sql using windows authentication.

 

[[GM]:Glenox]

try to SQL Native CLient....

 

[GothicaM]

I used that.

 

[[GM]:Glenox]

but when i try to login this will appear can you hel me wat will i do to solve thid problem :sad::sad:

use the driver SQL native Client for sql 2005
use the driver SQL Server for SQL 2000

 

[Feck]

 

[kramray]

try this : TYPE XYFFIZZ\SQLEXPRESSon server