Member_2_220651
asked on
ODBC Driver not found
i have a vb program using user documents. In the program, ODBC is used to connect a sql server to get data.
The program is compiled in IIS and the dsn is created in IIS too.
I have 3 clients with different OS, Japanese Window 98, Simplied Chinese Window 98 and English Window 98.
Once I access the html generated by the vb, English and Simplied Chinese can downloaded the page successfully. However, for the Japanese one, it always prompt me that the data source of ODBC driver not found.
Why?
The program is compiled in IIS and the dsn is created in IIS too.
I have 3 clients with different OS, Japanese Window 98, Simplied Chinese Window 98 and English Window 98.
Once I access the html generated by the vb, English and Simplied Chinese can downloaded the page successfully. However, for the Japanese one, it always prompt me that the data source of ODBC driver not found.
Why?
ASKER
Is that you mean I should download the MDAC 2.6 for each client PC that accesses the vb program from IIS? And you mean the client PC uses its own odbc driver when accessing vb program?
I don't understand why is not IIS get data from sql server uses its ODBC then download the page to client.....
I don't understand why is not IIS get data from sql server uses its ODBC then download the page to client.....
For an ActiveX Document application, you do need the DSN and MDAC on each client. It is not like ASP, an ActiveX document runs on the local computer, not on the server.
ASKER
I installed mdac on japanese PC. It can show me the page in which a chart display. Once I click on a chart, it failed. it can't download another page (it should show me another chart). A message prompt me to save the xxx.vbd file. This does not happen in English pc AND simplied chinese PC....
I guess the browser-settings are different that it won't allow Active Documents :-/...I have no additional idea what the problem could be.
regards,
CJ
regards,
CJ
ASKER
i'm not agree because the first page (chart) is also ActiveX document.
Here I show me some codings.
In the vb program,
Private Sub ChartA_Click
Hyperlink.NavigateTo "./ChartB.htm"
End Sub
In the ChartB.htm,
<HTML>
<OBJECT ID="ChartB"
CLASSID="CLSID:6F94FB05-06 19-11D5-A8 DD-00306E0 0A7AC"
CODEBASE="Project.CAB#vers ion=1,0,0, 1">
</OBJECT>
<SCRIPT LANGUAGE="VBScript">
Sub Window_OnLoad
Document.Open
Document.Write "<FRAMESET>"
Document.Write "<FRAME SRC=""ChartB.VBD"">"
Document.Write "</FRAMESET>"
Document.Close
End Sub
</SCRIPT>
</HTML>
Here I show me some codings.
In the vb program,
Private Sub ChartA_Click
Hyperlink.NavigateTo "./ChartB.htm"
End Sub
In the ChartB.htm,
<HTML>
<OBJECT ID="ChartB"
CLASSID="CLSID:6F94FB05-06
CODEBASE="Project.CAB#vers
</OBJECT>
<SCRIPT LANGUAGE="VBScript">
Sub Window_OnLoad
Document.Open
Document.Write "<FRAMESET>"
Document.Write "<FRAME SRC=""ChartB.VBD"">"
Document.Write "</FRAMESET>"
Document.Close
End Sub
</SCRIPT>
</HTML>
Are they all using the same database? Maybe the Japanese version is corrupt?
ASKER
yes, they are using the same database.
Actually, i just install MDAC in client PC without creating any DSN.
Actually, i just install MDAC in client PC without creating any DSN.
Isn't it:
UserDocument.HyperLink.Nav igateTo "othervbdfile.vbd"
So, installing MDAC did solve the actual problem?
regards,
CJ
UserDocument.HyperLink.Nav
So, installing MDAC did solve the actual problem?
regards,
CJ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi yyjulie,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept CJ_S's comment(s) as an answer.
yyjulie, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept CJ_S's comment(s) as an answer.
yyjulie, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Comment from expert accepted as answer
Computer101
E-E Moderator
Computer101
E-E Moderator
If it is not in that list, you need to install it. I assume that downloading the MDAC 2.6 from the Microsoft site will solve the whole problem.
regards,
CJ