SQL and ODBC?

[DumTech]

This may really belong on an ODBC forum, so accept my apologies if that's the case...

I'm in tech support, and our software just implemented ODBC this year. Of course, we (techs) weren't briefed on what's involved in this..."Setup should configure everything! No worries!" said development.

So now facing problems with our report generator, I'm trying to figure out how this stuff works as best I can.

My main question has to do with the necessity of an SQL Server driver in the ODBC drivers listing... We use the Visual Fox Pro driver for our software, but I noticed that at least one office having problems with reports lacks the SQL driver on the ODBC control panel (Win98 here). The customer's database works fine for reports here in the office, where we do have the SQL driver. Is that a problem or am I on the wrong track entirely?

Thanks for any information whatsoever...I'm really looking for a conceptual underpinning for what takes place with ODBC, but almost everything I find on the net seems aimed at programming...

Matt

 

[foxdev]

I'm going to ask a dumb question: does your software (VFP, assumedly) connect to an SQL Server database?

If yes, then of course you'll need SQL Server drivers.

If not, then I'm thinking that those who have the SQLS driver also have a different version of some related DLLs or MDAC, and this is indirectly affecting your client's connectivity. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[DumTech]

That's just the kind of dumb question I can't even answer...
See what I mean by not briefed on what's involved?

Your if not paragraph is the direction I've been leaning anyway. Am I right in thinking an MDAC update would install the SQL Server driver also? All the versions for DLLs I've checked in this problem office match versions in our office on machines that run reports just fine, but there's another one or two having trouble that DO have an SQL Server driver, thus my thinking that an MDAC update might be the best bet...

Thanks a lot Robert!
Matt

 

[foxdev]

There sure are a lot of variables involved. Visit

http://www.microsoft.com/data/

(MS Universal Data Access page) for more info/downloads for MDAC. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[DumTech]

Variables indeed. All together we have a handful of sites having report issues and none of them seem to be identical. Keeps the job interesting, right?

Thanks for the tip. I've actually been spending a bit of time there for the past day or two (as well as other Microsoft pages about ODBC and SQL).

If you come up with anything else you think might help, I'm sure it'd be worthwhile info.

Matt

 

[DumTech]

Robert,
I've been told our db is FoxPro compatible or FoxPro. The reports we're trying to run are generated by Crystal Reports, which I noticed you had written a FAQ on (w.r.t. FP)... Does this info give you any more insight?

(Tried a little update from MDAC 2.1.3711.11 to MDAC 2.1.2.4202.3 with the same results...)

Still a lot of variables, I know....

Thanks,
Matt

 

[kiranz]

I am running SQL Server on a PC running Windows 2000 Server and the Active Directory Services havent been activated since our Network Administrator is busy with some appointments. Recently we installed SQL Server 2000 on that PC. Now i have another PC (on the Network) which is runnin Windows 2000 Professional and have installed the SQL Server Client Tools on to that PC. The problem now is that I am not able to establish a connection between the Client and Server.

Please note that my Client is able to detect as to which Machine is running SQL Server but it is not able to establish the connection. The SQL Server is Listening on the Default Port(1433) and using TCP/IP as the Protocol. The client too is configured for TCP/IP and requesting on that same port(1433) on the SQL Server Machine.

The error I get is "SQL Server does not exist or access denied".

Please help me find a solution.

Thank you
Kiran