[windows2000] SV: Re: VB6: Getting a "Microsoft OLE DB Provider for SQL Server" error message, and cannot figure out why
- From: "Svein Arild Haugum" <svein@xxxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Fri, 30 Jul 2004 08:25:17 +0200
As Ray said, check the name resolution.
Then you can try a ping/tracert. To see if the routing between the sites are
good.
If you can successfully ping the sql server from the laptop. I would install
the Enterprise Manager, Query Analyser or OSQL on the laptop, and test sql
connectivity, using bort trusted (AD) and sql accounts.
Or you can use a OLE DB provider, like ODBC, and create a connection, and use
the test button.
Could it also bee that the user is missing av ODBC connection used by the
application? Could it be the user has fucked up an MDAC upgade? Try
reinstalling MDAC to a version you know works with your application/server.
Mvh
Svein Arild
-----Opprinnelig melding-----
Fra: Ray at home [mailto:listray@xxxxxxxxxx]
Sendt: 30. juli 2004 02:38
Til: windows2000@xxxxxxxxxxxxx
Emne: [windows2000] Re: VB6: Getting a "Microsoft OLE DB Provider for SQL
Server" error message, and cannot figure out why
Can you resolve the SQL Server by name, if that's how the app is connecting?
Is the SQL connection string available for you to view? Does it use a
trusted connection to the SQL server passing that person's NT account
credentials? Or does the application specify a SQL login? Either way, does
the user connecting to SQL have rights to the database still, and is the
account, if it's an NT account, not locked out or disabled?
Ray at home
> -----Original Message-----
> From: windows2000-bounce@xxxxxxxxxxxxx
> [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Rod Falanga
> Sent: Thursday, July 29, 2004 4:27 PM
> To: windows2000@xxxxxxxxxxxxx; VBDATA-L@xxxxxxxxxxxxxxxxxxxx;
> AbqVBug@xxxxxxxxxxxxxxx
> Subject: [windows2000] VB6: Getting a "Microsoft OLE DB
> Provider for SQL Server" error message, and cannot figure out why
>
> We wrote a couple of VB6 applications which have been in use
> for several years now. We have several external customers
> who dial into our network and use those applications. In
> order to use our apps, they have to have an account on our
> Active Directory 2000 network and log into their machine
> using a username and password which matches our network's
> username and password.
>
> Anyway, some of these users have stopped being able to use
> our application. They are getting the following error
> message, "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server
> does not exist or access denied. (Microsoft OLE DB Provider
> for SQL Server)(-2147467259)"
>
> This is making me pull my hair out. I have called Microsoft
> and got it working for some of these. We could that the SQL
> Server server wasn't pointing to our network's WINS server.
> We've fixed that, and that seems to have helped, but not everyone.
>
> I've just been working on one user's laptop, trying to make
> it work, and I keep getting this error message. I even went
> into that user's dial-up network connections and (a)
> specified our DNS server but no WINS server, (b) specified
> the WINS server but no DNS server, (c) specified both the DNS
> server and the WINS server. But none of these settings helped!
>
> So, what's wrong?!
>
> I do not know if this makes a difference or not, but this
> particular user has AOL on his laptop.
>
> (He has Windows XP Home Edition installed and I've installed
> service pack 1 for XP onto it.)
>
>
> ________________________________________
> Rod Falanga
> http://amci.unm.edu
>
>
> ********************************************************
> This Weeks Sponsor StressedPuppy.com Games
> Feeling stressed out? Check out our games to
> relieve your stress.
> http://www.StressedPuppy.com
> ********************************************************
> To Unsubscribe, set digest or vacation
> mode or view archives use the below link.
>
> http://thethin.net/win2000list.cfm
>
>
********************************************************
This Weeks Sponsor StressedPuppy.com Games
Feeling stressed out? Check out our games to
relieve your stress.
http://www.StressedPuppy.com
********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
********************************************************
This Weeks Sponsor StressedPuppy.com Games
Feeling stressed out? Check out our games to
relieve your stress.
http://www.StressedPuppy.com
********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
