I created DSN using C/ODBC. (I created DSN with the name Attain). This is working fine with VB If I use as follows Dim NaviDb as New ADODB.Connection NaviDb.Open “DSN=Attain” In ASP, I wrote as follows Dim NaviDb Set NaviDB = Server.CreateObject(“ADODB.Connection”) NaviDb.Open “DSN=Attain” I get the following Error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any Idea on how should I use the DSN ?
it is working at my end. I tried on PWS on win 98. i used NaviDb.Open “Attain” remove DSN= and then try
Thanks Ajay. I tried it already. It is of no use. I am using Win2000 along with IIS 5.0
How about this, using on W2K server, IIS 5.0 SET conn = Server.createObject(“ADODB.Connection”) conn.open “DSN=Attain;”, “”, “”, -1 'Syncron
Thanks Preben. I tried that option also. I am getting an error box with title as slave.EXE - Application Error with following message The instruction at “0x1002a2cb” referenced memory at 0x0602c020". The memory could not be “read”. Click on OK to terminate the program Click on CANCEL to debug the program with OK and CANCEL Buttons. Going MAD… I don’t know what to do… There cannot be any permission problems as I have the admin rights for my system. I have Navision installed in my machine. I have IIS 5.0. My OS is Windows 2000 Professional. Any ideas ?
I got them working not through C/ODBC but through C/Front OCX. Thanks to all those who helped me with their ideas. Thanks Preben and Ajay.
Dear Mani, First I developed the site on my personal notebook on 98 with PWS and then i used win 2000 IIS 5.0 , i also faced a lot of problems i did a lot of rnd, installation/uninstallation. Just make sure you have only 1 version of Navision on that machine and you are using system DSN
Hi Ajay, I have only one installation of Navision in my machine. I have Win2K Professional as OS and IIS 5.0. Somehow, it is not recoganizing the Driver From ASP. I am able to do the things through C/Front OCX embedded in VB, instead of C/ODBC directly. I am not able to figure it out exactly. But, for the moment, I am able to do the things. (The actual fact of running on toes is that my management is expecting me to show a demo this weekend.). Anyhow, I will post if I can find out some meaningful reasons. Meanwhile, input from anyone who is aware of the fact is also welcome.
if u just want to give demo give it on 98 with PWS , it works fine i checked on 2-3 machine.
If I show something working, then, I need to be ready with the stuff. It is dangerous in my company, to show a demo without doing sufficient home work. You do not get time to do R&D. Here they think, it is ERP, then it is ready to use… They ask “What is Customization ? other than changing / keyin in new accounts and dates !!!”.
Well said Mani regarding “Customization”. Sometimes its hard to explain the technical issue involved in a business solution. [:(]
I was having the same problem and eventually had to write a dll that interfaced with Navision. Everything worked well with vb but ASP did not like it. The DLL did exactly what I was going to do in ASP but it did not give the errors. Right now I am having problem accesing Flow fields. Any help?