ActiveX control for the web
-
Iam trying to create a simple activeX control for the web using Vb. It connects to a backend access database. I have the following code segment that is giving me an error ConString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=STV250.mdb" & _ "DefaultDir=D:\Inetpub\wwwroot\MastersProject\Inventory;" objConn.Open ConString The error being: [ADO Error # -2147467259 Description [Microsoft][ODBC Microsoft Access 97 Driver] '(unknown)' isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Source Microsoft OLE DB Provider for ODBC Drivers] However if I use, ConString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=D:\Inetpub\wwwroot\MastersProject\Inventory\STV250.mdb" objConn.Open ConString it works fine. That is after I create the .CAB file and embed it in an asp page. But it works only on the computer that houses the webserver and the .OCX/.CAB files. If I try accessing it from another machine, I get the ADO Error # -2147467259 again. I have used the same code for numerous ASP pages and had no problems. But it just refuses to work for the ActiveX control. Could someone please help?