ODBC help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

ODBC help

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 20:31:52

Can somebody please help me install and setup ODBC Drivers for SQL server . Thanks

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-29 : 20:33:04

Yes, if you provide some more detail of the problem we would be happy to assist. Which ODBC drivers and for which OS?

Future guru in the making.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 20:37:40

Thanks.

I want to install ODBC drivers for SQl server 2005 server. I have a zip file.
I want to know all procedure and its production server. Your help will be appreciated

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 20:39:30

There is nothing special about getting these installed. Did you have a specific question?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 20:41:21

Tara the great is here again.
I want to
know after installing ODBC with the zip file. How do i configure for SQL server 2005 so it is done the right way.
Thanks tara and zoaraster

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 20:52:12

There is nothing to configure inside SQL Server 2005 after you install the driver. Where do you intend to use these new drivers?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 20:54:05

the drivers need to be installed and set up for 2005 prod server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 20:56:16

We don't have enough information to help you. Please provide more details.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 20:58:00

ok. I have a zip file for installation of ODBC drivers. ok my question is after installtion. What should i do.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 21:01:25

We have no idea as you haven't provided enough information yet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 21:03:15

Is there a way i can go in control panel and setup drivers for the clients.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 21:07:58

Yes. You can setup ODBC data sources in Control Panel..Admin Tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 21:09:26

SO how to set up .Tara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-29 : 21:12:56

It depends on what you need done. We don't have this information from you yet.

Please tell us exactly what ODBC driver this is and what exactly will be using these ODBC data sources.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 21:14:50

It is ODBC driver for Microsoft SQL server. For the client connections i guess.

avmreddy17
Posting Yak Master

180 Posts

Posted - 2007-11-29 : 21:16:36

Go to Control panel
Administrative tools
ODBC DataSources
from here you can create a USER DSN or the SYSTEM DSN depending on your reqs

Thx
Venu

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 21:17:53

so i have to apply USER DSN or System DSN. and after that

avmreddy17
Posting Yak Master

180 Posts

Posted - 2007-11-29 : 21:26:40

Click ADD
SELECT Drive for SQL Server ( or what ever Data Source you wanna coonect to )
FINISH

Then it will ask for your Servername , UserID and Passowrd - which database you want to connect to...

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-29 : 21:30:22

I have already done that. So how can i check whether i can connect to that database from ODBC connection. ANyway thanks.

avmreddy17
Posting Yak Master

180 Posts

Posted - 2007-11-29 : 21:32:30

Didn't it ask for the TEST Connection? When you completed the above steps

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-29 : 21:32:44

sodeep, are you asking how to install the drivers or configuring a data source? The basic drivers should already be in place, the specifics of configuring the data source will depend on, as Tara said, what is required by the application or user that will be connecting via ODBC.

Future guru in the making.

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources