[Guide]How To set Up ODBC with screenshot

[Abry]

SETTING UP ODBC

--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------
--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------

--------------------------------------------------------------------------

hope i help out those who are confused=)

[MentaL]

[austhistikated]

Guide is good...
But I just wanna ask why aren't you putting anything on the Server field??
It should have atleast (localhost)...
Or the SQL connection...
SQL connection should be like (Computer Name\SQLEXPRESS)...

Example:
"SKYE\SQLEXPRESS" (Without the quotes)
Or else you will not be connected to the SQL...
Lol...
If you test it...
"TEST FAILLED"
You cannot connect to the SQL server...

All in all guide is good except for the mistake there...
Good job...
Keep em up!

[denverporia19]

yeah aut is right u must include d sql server to connect to database properly.

[Abry]

hehe thx for the correction,, i will just rewrite the picture=)
sorry^^

[austhistikated]

Anyway nice guide tho...
I also made a guide for SQL & ODBC before...
But since its so old...
It's time to make a new one...
Job well done!!

[Abry]

thx bro more power to you=) and to me hehehe
now i have no plan to make a server but i plan to dev a server and learn more^^

[austhistikated]

Yap!
You can choose both...
Developing a server while you run it...
^^,

[Abry]

sir aus can you add me up=)
spiritupro@yahoo.com

[SeiferXIII]

Already shared.

[Abry]

yah but this is more easy and organize whahahaha=)

[carlo2909]

Why I can`t Still Connect?.

[baliw53]

@sir abry : for the finishing of the guide with screen shot.

1. put the database name...
2. put the sql sever name...
3. click next...



4. click the "with SQL server authentication using a login ID and password entered by a user"...
5. put the login id: and password:...
6.click next...



7.check the "chanhe the default databas to:"...
8. choose the " RanGame1"...
9. click next....



10. click finish...



11. after clicking finish another window will popup for the test connection.
click "test data source"...



- if you are success this will you get:



- just hit ok...

12. now for the final procedure just click the ok then your done...



in other database(RanLog, RanShop, RanUser)... same procedure...
hope this help...

[EuMiL]

Thanks a lot sir!

[OjieThugz]

nice tut

[paladinx]

Thanks for this Guide.... Help me a lot...

[kercedric]

why connection failed :
SQLState: '28000
SQL Server Error: 18452
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. the user is na associated wuth trusted SQL Server connection

[jstarhiro]

HELP SIR Microsoft SQL Server ODBC Driver Version 03.85.1117


Microsoft SQL Server ODBC Driver Version 03.85.1117

Data Source Name: RanGame1
Data Source Description:
Server: Jstar/SQLEXPRESS
Database: RanGame1
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No



"PROBLEM"


Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

TESTS FAILED!

[legion08]

after i follow this guide
it gives an error

Microsoft SQL Native Client Version 09.00.5000

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [123].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!

[karius]

it works perfectly! thanks! im using windows 7 sp1 :)

here's the hint to get the "Data Sources"

1. click "Start"
2. Search "Data Sources" on "Search program and files"
3. right click and "run as administrator"
4. then here you go :)

here's my TEST

Microsoft SQL Native Client Version 09.00.1399

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

[budhabilz]

can some one help me with this problems?tnx
Image Upload !
Image Upload !

[theaink]

sir, can i using mysql 2010 express studio n the workbench for running ran database?

[Vision]

MySQL? We can only use MSSQL 2005 - 2008, and this was tested by most devs. MySQL is used for web database storage.

[keeyanpogi]

connection failed :
SQLState: '28000
SQL Server Error: 18456
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. the user is na associated with trusted SQL Server connection

Can you help me about this sir please :(((((

No one is answering :(

[yagami1]

connection failed :
SQLState: '28000
SQL Server Error: 18456
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. the user is na associated with trusted SQL Server connection

Can you help me about this sir please :(((((

No one is answering :(

i think your account does not have a database creation rights on your sql server

causing that error exist

[Vision]

Hello,

Please post your concerns about the tutorial in our Help Section so we can be able to help you through the problem.

Thank you,
Vision