Search results for query: *

Your a genius. Thanks M

Not sure about the problem. I just recreated it with: makecert -r -n "CN=test 2004" -b 01/01/2000 -e 01/01/2099 -eku 1.3.6.1.5.5.7.3.3 -sv test.pvk test.cer cert2spc test.cer test.spc pvkimprt -pfx test.spc test.pvk I left the password blank and took the defaults for all the rest except I...

All I have are Visual Basic for applications microsoft excel 10.0 object library ole automation microsoft office 10.0 object library microsoft forms 2.0 object library microsoft ActiveX Data Objects. 2.0 library These are fine unless you distribute to people with older versions of Excel...

I assume you double-clicked on the .pfx file and installed it. From there open Outlook then Alt-F11 to open the VBA interface. Go to TOOLS>DIGITAL SIGNATURE select the certificate from the browse button and OK it and close the VBA interface. Close Outlook and reopen it. It may prompt you to...

PS once you get a .PFX file then you can just double click on it to except it. Then in VBA interface go TOOLS>DIGITAL SIGNATURE select the certificate and save the file. Close the file and reopen it. When prompted check "Always turst macros from this source then click Enable Macros...

From what I remember and my notes basically 3 steps. (fill in with your own info and file names - run from command line) 1. makecert -r -n "CN=Your Name" -b 01/01/2000 -e 01/01/2099 -eku 1.3.6.1.5.5.7.3.3 -sv selfcert.pvk selfcert.cer 2. cert2spc selfcert.cer selfcert.spc 3. pvkimprt -pfx...

Your goal is a certificate that you can install. It will be a .pfx file. Look at this page. http://www.source-code.biz/snippets/vbasic/3.htm M

Ron, Here is one of my own examples.... Dim cn As New ADODB.Connection Dim cnstr As String Dim CurrLib, ipadd As String ipadd = "192.168.1.1;" CurrLib = "lib1" cnstr = cnstr & "DRIVER=Client Access ODBC Driver (32-bit);" cnstr = cnstr &...

Cha Ching..... Ron checkout http://support.microsoft.com/default.aspx?scid=kb;en-us;124218 Sample 8: Using Long SQL Query Strings NOTE: There is a maximum limit of 255 characters in a SQL query string. You may also receive GPFs if the length exceeds 127 characters. Use the method below to...

Ron, Sounds like no matches to your query. Did you get an error or just no records? Did you go to the 400 and do a STRSQL and paste your query there. That will tell you. Any query that returns an answer there should work from ODBC. M

skarosi, Check out http://www.w3schools.com/ado/ for some good examples. M

Post more code and check out http://www.w3schools.com/ado/ M

Check out http://www.w3schools.com/ado/ M

comconrk, any luck? M

Oops That was STRSQL.... M

Very interesting, there could be a max SQL parameter on the 400 that I don't know about but it would not be the default setting. I just performed a query of 417 characters (incuding spaces) with no problems. I have done it on several AS400's for years. 2 things... could you post more of your...

comconrk, What is the error message and what method are you query the 400. I perform much longer querys and have never found a limit. There are limits on the timeslice that the 400 will allow to execute the query. M

xlbo you turned out to be correct. I had checked it but I guess I did not get it right. It turned out to be the regional settings. It was giving the date as '1/1/2004' rather then '01/01/2004' Thanks again to all that answered. Once again the simplest answer was the correct answer. Mj

Good advice everyone and thanks again. The ODBC driver shown above is the older version. I tried it after the newer one failed with the same error. I am using a DNS'less connection so the regional settings should be the same and I am using the same user name and password in the connection...

I am running an ODBC query from MS Excel agains AS400. Select B3GLAC, B2TRDT, B1VND#, B2DESC, B1VNAM, B3TITM+B3TFGT+B3TTAX-B3TDSC as Test, B1PON#, B1INV#, B3REF#, B3GLPX FROM YADPOS2.b3billl1 INNER JOIN YADPOS2.b2billl3 on B3REF# = B2REF# and B3SEQ#=B2SEQ# INNER JOIN YADPOS2.b1billl0 on B2REF#...