microsoft.public.scripting.vbscript - Microsoft Office Project
Set Conn = Server.CreateObject( "ADODB.Connection" ) Conn.Open( "DSN = mydsn; UID = myuserid; PWD = mypassword;" ) sql = "select * from customers" Set RS = Conn.Execute( sql ) Preferably with a SqlDataAdapter not an OleDbDataAdapter
Hi all, I am using VB6, MS-Access2000 for my application. The application is running fine from IDE. But when it is build and run using the binaries, it is throwing the error "Method '~' of object '~' failed". When put messages, I found that in the following code, the last line causing the error. Dim mcnDBData As ADODB.Connection Set mcnDBData = New ADODB.Connection Dim strConnectionString as string strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F: \Data\Test.mdb;Persist Security Info=False;Jet OLEDB: Database Password=LFSGenesis;" Call mcnDBData.Open(strConnectionString) Can anybody let me know what can cause such an error? Regards, Swapna.
A simple VBScript with the line: Set oFld = CreateObject("ADODB.Field") causes an error that the object cannot be created. I've seen various examples of this so I'm sure it must work. Can anyone tell me why this wouldn't work? Thanks. Dan
Sorry if this is the wrong group...I THINK I got to the right place...(oh...and I'm a newbie programmer...so please be gentle) Anyway I have a program that works fine when I run it from within VS2005 (no errors and does exactly what it should) BUT if I build it and then try to run the .exe on the same computer it fails with: "Unhandled exception...." "Cannot create ActiveX component" It seems to fail on this line: objAdminSystem = CreateObject("NovellGroupWareAdmin") I added the reference to this object (Name: Groupwise Admin API Library) (Filename: Interop.AdminTypeLibrary.dll) I did some searching online and found someone had fixed it by running "regsvr32 gwcmb1.dll" I tried that (it suceeded) but the program still fails outside of the VS2005 environment. Thanks for any help you might be able to provide!