Search results for query: *

...an ole object. I get "type mismatch" error with the following code.. Dim oRst, sQuery Set oRst = CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.[Current] = true" oRst.Open sQuery, oConn Dim WordApp Set WordApp = CreateObject("Word.Application")...

Thanks for your response. Yes the recordset value does not represent a string. It is an acutal document stored as an ole object in the database and the error "type mismatch" is correct. What I don't understand is how to use the word.application object to open a stored word document in MS Access.

...with vbscript. I get t type mismatch error with the following code.. Dim oRst, sQuery Set oRst = CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.[Current] = true" oRst.Open sQuery, oConn Dim WordApp Set WordApp = CreateObject("Word.Application")...

I am trying to open a connection through an ASP page via an ODBC connection to a secure Access DB and keep getting the same message. [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or...

SELECT SYSDATE FROM DUAL WORKED! Yes Hunt has access to the objects. As I said I can open a linked connection to the DB and tables in Access 2000.

...oOracle.Open "FileDSN=Luf.dsn;UID=hunt;PWD=changeme" Set oRst2 = WScript.CreateObject("ADODB.Recordset") sQuery = "SELECT * FROM MGR_ACCT WHERE acct_id LIKE '2EX8A%'" oRst2.Open sQuery, oOracle I know the table names and fields are spelled properly since I can...

...works when I try to read the fields value. i.e Dim oRst, sQuery Set oRst = Server.CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.Current = -1" oRst.Open sQuery, oConn,adOpenStatic,adLockReadOnly I have tried every combination possible. True...

I am interested in using the MSCOmm control via a web page to control a remote camera thru the host computer serial port. Does anyone have any experience writing similar code? How would I Set my control with the createObject property? I am not well versed in ActiveX excluding ADO and have never...

I wish to turn off the automatic highlighting of text in a multi tabbed form text box. When i switch between tabs it automatically selects all of the text in the text window. Any idea how to do this?

I am writing some vb code to log into Exchange and extract information from the calendar. I need a way to get around the Macro Security Warning. I would like to sign the code with a certification and have exchange accept signed scripts. Is this possible? I must note that they will probably not...

I am writing some vbScript code to log into Exchange and extract information from the calendar. I need a way to get around the Macro Security Warning. I would like to sign the code with a certification and have exchange accept signed scripts. Is this possible? I must note that they will probably...

Can anyone tell me the implications or Pros/Cons on keeping a DB connection open via the Global.asa? This is on an Intranet.

I am interested in finding out if a reference to the security file can be included in an ADO connection string. I have not seen any examples nor found on MSDN any reference to it. sConn = "Provider=Microsoft.Jet.OLEDB.4.0;USER ID=guru;Password=TheGuru;Data Source=\\rdpublic\rad\Rad.mdb"

I am trying to access an Access 2000 DB with ADO that is restricted by a Security file. No matter what I do I can't Open the DB. If I create a DSN it works, but then when the Queries in that DB (which I am referencing in my SQL string) access table/queries in another DB I hit the same wall...

Thanks but that still would not work. I guess i'll have to find a different way to get at the data.

Pinging worked fine but your #2 connection path resulted in "error 3706 provider cannot be found". The ODBC connection works fine. My original connection to the DB was a File DSN that worked great. sConn = "FileDSN=ls.dsn;" & _ "Server=LsUnits.world;" & _...

...= "Provider=MSDASQL.1;DRIVER={Oracle73 Ver 2.5};UID=noOne;PWD=changeme;DBQ=LSUNITS.WORLD;ASY=OFF;" Set cn = New ADODB.Connection cn.CursorLocation = adUseServer cn.ConnectionString = sConn cn.Open Set rs = New ADODB.Recordset sSQL = "SELECT * FROM LSMGR_ACCT" rs.Open sSQL, cn

I have some hardcoded ADO connection strings in an ASP page on my web server that connects to an Access DB. I aslo have Access 2000 installed on the server. I joined the networked Workgroup file directly from the Web server. The problem is, I keep getting an error.... Cannot start your...

I am querying an Access DB that has some of the text/memo fields data in Paragraph form. Question is, why do I loose my formatting when returning data to my web page? i.e inserted into db as.... Sentence One Sentence two Returned from db as... Sentence One Sentence Two

I have a modem installed on win com 4 and wish to set it up on linux ttys3/com4 but there is no ttys3 device link file. How do I create one or get my system to do it?