Ruby Odbc

[XxMasonxX]

I got a set of files, Installed sql and management studio etc etc etc - all installed and connected fine.

Goto admin tools to set up the ODBC and some reason when I add a new connection it fails

anyhelp is appriciated

Mason (bck on the game)

 

[Ardbeg]

Any error messages ?
Is it the ODBC connection is failing or the game is failing to connect to SQL via ODBC ?

 

[XxMasonxX]

Connection Failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft}{ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not exist or access denied.



this is the error message i keep getting dude

 

[Ardbeg]

Do you have any drivers listed under the drivers tab ?



... and have you added the particular tables you want to connect to ?




It might be an issue of a missing driver due to differences between windows version and SQL version.

 

[XxMasonxX]

Right Drivers are all there but still get the errors when i try and connect ODBC to SQL lom2account etc

 

[Ardbeg]

Can you open up the tables in SQL Studio ?
Ignore that, I just re-read your initial post.

 

[daneo1989]

Make sure you are using the correct Local Address, and Username + Password

 

[XxMasonxX]

Make sure you are using the correct Local Address, and Username + Password

Ye i followed the guide down to a T, just stuck at connecting ODBC to SQL, I downloaded the Driver and installed but still hitting same results

chers for replys

 

[Ardbeg]

Under UserDSN, select a database and then select Configure.
Name = Database name ie LOM2Account, Description = blank, server name as XYZ-PC\SQLEXPRESS or similar.
Have the ODBC set to work with SQL authentication like the main database and tick the tickbox for connect to SQL. Enter the ID and pw in the fields then click next. (You could also deselect the tickbox then carry on to the end and test the datasource.)

Change the default database should be ticked and the relevant database selected. Click next then click finish.
Click Test Datasource.

 

[XxMasonxX]

ArdBeg your a genie, came home from work just follewed what you said and its worked, fkkin love ya

On the Guide it states to select the server name from the drop down menu, it does not state that that SQLEXPRESS should be manually entered.

so for example:

Server : STEPHEN-PC <<<<< this is wrong

should be

Server : STEPHEN-PC\SQLEXPRESS

and this is not stated on the guide :P

 

[Ardbeg]

Great stuff !

 

[XxMasonxX]

Great stuff !

Repped also any links to convert this korean client to english would be awesome

than again dude