<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
Maybe her SQL, is setup for integrated security tied into her Windows Logon
rather than standard security with a trusted connection.<br>
You have this security choice at install timeof SQL server. I don't think
you can have both. The connection string is different dependent on security
method. I always get confused about this, I only use integrated security.
maybe someone else can help out.<br>
<br>
Here are different ADO connection strings.<br>
<a class="moz-txt-link-freetext" href="http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer">http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer</a><br>
further info <br>
<a class="moz-txt-link-freetext" href="http://www.sqlserverfaq.com/">http://www.sqlserverfaq.com/</a><br>
<br>
MDAC 2.5 is up to SP3. You might want to install MDAC 2.7 and reset<br>
ADO reference from 2.5 to 2.7<br>
<br>
If on network then windows authentication is fine as long<br>
as the 9x workstation logs into the domain. If local<br>
then when SQL installs on 9x it will be in mixed mode<br>
anyway so no problem - you can determine the OS<br>
version and connect accordingly.<br>
<br>
Some sample test code to check and reset security methods<br>
<br>
Sub testsecuritymethod()<br>
Dim oServer<br>
Dim app<br>
<br>
Set oServer = CreateObject("SQLDMO.SQLServer")<br>
<br>
Set app = CreateObject("SQLDMO.Application")<br>
<br>
oServer.LoginSecure = True<br>
<br>
oServer.Connect "servername"<br>
''SQLDMOSecurity_Mixed = 2<br>
'reset security<br>
'app.SQLServers("servername").IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed<br>
'original security<br>
Debug.Print app.SQLServers("servername").IntegratedSecurity.SecurityMode<br>
'reset password<br>
'oServer.Logins("sa").SetPassword "", "MyString"<br>
<br>
'Debug.Print SQLDMOSecurity_Mixed; 2<br>
'Debug.Print SQLDMOSecurity_Integrated; 1<br>
'Debug.Print SQLDMOSecurity_Normal; 0<br>
<br>
End Sub<br>
<br>
Sub sqlreset()<br>
Dim oMSDEserver<br>
Set oMSDEserver = CreateObject("SQLDMO.SQLServer")<br>
oMSDEserver.LoginSecure = True<br>
oMSDEserver.Connect "servername"<br>
oMSDEserver.IntegratedSecurity.SecurityMode = 2<br>
oMSDEserver.Disconnect<br>
oMSDEserver.Stop<br>
'restart<br>
oMSDEserver.Start True<br>
end sub<br>
<br>
<br>
<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:jeffrey.demulling@usbank.com">jeffrey.demulling@usbank.com</a> wrote:<br>
<blockquote type="cite"
cite="midOF79CA9EC6.EA094969-ON86256CF7.007E6FE4-86256CF7.007EFE8C@nc.us.bank-dns.com">
<br>
<font size="2" face="sans-serif">First: Marty thanks for the link.</font>
<br>
<br>
<br>
<font size="2" face="sans-serif">She has version 2.5 SP1 (2.51.5303.5)
for the MDAC.</font> <br>
<font size="2" face="sans-serif">On my machine I have version 2.6 RTM (2.60.6526.3)</font>
<br>
<br>
<font size="2" face="sans-serif">Now I am not sure what connection string
you are referring to. The ADP connection interface looks like the following:</font>
<br>
<br>
<img src="cid:part1.09000706.09050704@shaw.ca">
<br>
<br>
<br>
<br>
<br>
<table width="100%">
<tbody>
<tr valign="top">
<td> <br>
</td>
<td><font size="1" face="sans-serif"><b>MartyConnelly <a class="moz-txt-link-rfc2396E" href="mailto:martyconnelly@shaw.ca"><martyconnelly@shaw.ca></a></b></font>
<br>
<font size="1" face="sans-serif">Sent by: <a class="moz-txt-link-abbreviated" href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</a></font>
<p><font size="1" face="sans-serif">03/28/2003 03:59 PM</font> <br>
<font size="1" face="sans-serif">Please respond to accessd</font>
<br>
</p>
</td>
<td><font size="1" face="Arial"> </font> <br>
<font size="1" face="sans-serif"> To: accessd@databaseadvisors.com</font>
<br>
<font size="1" face="sans-serif"> cc: </font> <br>
<font size="1" face="sans-serif"> Subject: Re: [AccessD]
DATA PROVIDER COULD NOT BE INITIALIZED</font></td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<font size="3" face="Times New Roman">MDAC Component Checker<br>
</font><font size="3" color="blue" face="Times New Roman"><u><br>
</u></font><a
href="http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en"><font
size="3" color="blue" face="Times New Roman"><u>http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en</u></font></a><font
size="3" face="Times New Roman"><br>
<br>
How about a peek at your connection string too?<br>
</font><font size="3" color="blue" face="Times New Roman"><u><br>
</u></font><a href="mailto:Mwp.Reid@Queens-Belfast.AC.UK"><font
size="3" color="blue" face="Times New Roman"><u>Mwp.Reid@Queens-Belfast.AC.UK</u></font></a><font
size="3" face="Times New Roman"> wrote:</font> <br>
<font size="3" face="Courier New">The adress escapes me at the moment but
theres a download on MS which tells <br>
you the versions of all the MDAC stuff you have loaded.<br>
<br>
Sorry I cant remember the address.<br>
<br>
Martin<br>
<br>
<br>
Quoting Mike and Doris Manning </font><a
href="mailto:mikedorism@ntelos.net"><font size="3" color="blue"
face="Courier New"><u><mikedorism@ntelos.net></u></font></a><font
size="3" face="Courier New">:<br>
<br>
</font> <br>
<font size="3" face="Courier New">Yes that is what I meant. To resolve
the problem you need to find out<br>
the<br>
answers to the following questions...<br>
<br>
1) Does she have MDAC 2.7 installed?<br>
2) Did you create a SQL data connection (either a System DSN or a User<br>
DSN)<br>
on her machine?<br>
<br>
Doris Manning<br>
Database Administrator<br>
Hargrove Inc.<br>
</font><a href="http://www.hargroveinc.com/"><font size="3"
color="blue" face="Courier New"><u>www.hargroveinc.com</u></font></a><font
size="3" face="Courier New"><br>
<br>
-----Original Message-----<br>
From: </font><a href="mailto:accessd-bounces@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>accessd-bounces@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
[</font><a href="mailto:accessd-bounces@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>mailto:accessd-bounces@databaseadvisors.com</u></font></a><font
size="3" face="Courier New">] On Behalf Of<br>
</font><a href="mailto:jeffrey.demulling@usbank.com"><font size="3"
color="blue" face="Courier New"><u>jeffrey.demulling@usbank.com</u></font></a><font
size="3" face="Courier New"><br>
Sent: Friday, March 28, 2003 03:23 PM<br>
To: </font><a href="mailto:accessd@databaseadvisors.com"><font size="3"
color="blue" face="Courier New"><u>accessd@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
Subject: RE: [AccessD] DATA PROVIDER COULD NOT BE INITIALIZED<br>
<br>
<br>
<br>
Do you mean MDAC 2.7? <br>
<br>
<br>
<br>
"Mike and Doris Manning" </font><a
href="mailto:mikedorism@ntelos.net"><font size="3" color="blue"
face="Courier New"><u><mikedorism@ntelos.net></u></font></a><font
size="3" face="Courier New"> <br>
Sent by: </font><a href="mailto:accessd-bounces@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>accessd-bounces@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"> <br>
<br>
<br>
03/28/2003 02:13 PM <br>
Please respond to accessd <br>
<br>
<br>
<br>
To: </font><a href="mailto:accessd@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>accessd@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"> <br>
cc: <br>
Subject: RE: [AccessD] DATA PROVIDER COULD NOT BE<br>
INITIALIZED<br>
<br>
<br>
<br>
Does she have the latest MDAC update installed? <br>
<br>
Doris Manning <br>
Database Administrator <br>
Hargrove Inc. <br>
</font><a href="http://www.hargroveinc.com/"><font size="3"
color="blue" face="Courier New"><u>www.hargroveinc.com</u></font></a><font
size="3" face="Courier New"> <br>
-----Original Message-----<br>
From: </font><a href="mailto:accessd-bounces@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>accessd-bounces@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
[</font><a href="mailto:accessd-bounces@databaseadvisors.com"><font
size="3" color="blue" face="Courier New"><u>mailto:accessd-bounces@databaseadvisors.com</u></font></a><font
size="3" face="Courier New">] On Behalf Of<br>
</font><a href="mailto:jeffrey.demulling@usbank.com"><font size="3"
color="blue" face="Courier New"><u>jeffrey.demulling@usbank.com</u></font></a><font
size="3" face="Courier New"><br>
Sent: Friday, March 28, 2003 02:05 PM<br>
To: </font><a href="mailto:accessd@databaseadvisors.com"><font size="3"
color="blue" face="Courier New"><u>accessd@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
Subject: [AccessD] DATA PROVIDER COULD NOT BE INITIALIZED<br>
</font> <br>
<font size="3" face="Courier New"><br>
I have an AXP ADP FE (saved in A2K format) that connects to a SQL<br>
server.<br>
Everything works fine on my machine, on a machine with A2K, but when I<br>
try<br>
using the file with a machine that was setup with the run-time version I<br>
get<br>
the error: "DATA PROVIDER COULD NOT BE INITIALIZED". <br>
<br>
The user is opening a form and when she clicks on a drop-down box that<br>
has a<br>
rowsource = dbo.SEL_Offices_AlphaSort (yes she does have the correct<br>
permissions on the SQL server side for the SP) and a rowsourcetype =<br>
Table/View/StoredProc. <br>
<br>
Any ideas or suggestions would be greatly appreciated. <br>
<br>
TIA_______________________________________________<br>
AccessD mailing list<br>
</font><a href="mailto:AccessD@databaseadvisors.com"><font size="3"
color="blue" face="Courier New"><u>AccessD@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
</font><a href="http://databaseadvisors.com/mailman/listinfo/accessd"><font
size="3" color="blue" face="Courier New"><u>http://databaseadvisors.com/mailman/listinfo/accessd</u></font></a><font
size="3" face="Courier New"><br>
Website: </font><a href="http://www.databaseadvisors.com/"><font
size="3" color="blue" face="Courier New"><u>http://www.databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
<br>
<br>
<br>
<br>
<br>
</font> <br>
<font size="3" face="Courier New">_______________________________________________<br>
AccessD mailing list<br>
</font><a href="mailto:AccessD@databaseadvisors.com"><font size="3"
color="blue" face="Courier New"><u>AccessD@databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
</font><a href="http://databaseadvisors.com/mailman/listinfo/accessd"><font
size="3" color="blue" face="Courier New"><u>http://databaseadvisors.com/mailman/listinfo/accessd</u></font></a><font
size="3" face="Courier New"><br>
Website: </font><a href="http://www.databaseadvisors.com/"><font
size="3" color="blue" face="Courier New"><u>http://www.databaseadvisors.com</u></font></a><font
size="3" face="Courier New"><br>
<br>
</font> <br>
<font size="2" face="Courier New">_______________________________________________<br>
AccessD mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</a><br>
<a class="moz-txt-link-freetext" href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</a><br>
Website: <a class="moz-txt-link-freetext" href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</a><br>
</font> <br>
<br>
<pre wrap="">
<hr width="90%" size="4">
_______________________________________________
AccessD mailing list
<a class="moz-txt-link-abbreviated" href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</a>
<a class="moz-txt-link-freetext" href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</a>
Website: <a class="moz-txt-link-freetext" href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</a>
</pre>
</blockquote>
<br>
</body>
</html>