[Guide]How To set Up ODBC with screenshot

[Abry]

SETTING UP ODBC​

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

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

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

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

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

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

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

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

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

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

hope i help out those who are confused=)

 

[austhistikated]

Re: [Guide]How To set Up ODBC with screenshots

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]

Re: [Guide]How To set Up ODBC with screenshots

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!

 

[HyperVermillion]

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

You must be registered to see links

You must be registered to see links