Has anyone had this problem when creating an Access table in MRE? Using version 533. I've seen a post that mentions an adaptor, but not sure what it is referring to. Anyway, the Access DB resides on our reporting server and an ODBC connection has been created. I can create synonyms and read tables that already exist in this Access DB, but it isn't allowing me to create and place a new table into the Access DB. Getting the connection problem seen below. Wondering if it has to do with working from MRE ??

For instance, I'm doing this:
TABLE FILE WHATEVER
PRINT *
WHERE RECORDLIMIT EQ 10
ON TABLE HOLD FORMAT SQLMAC
END

and getting this:

0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10
0 HOLDING SQLMAC FILE...
(FOC1394) CONNECT FAILURE
(FOC1400) SQLCODE IS -1023 (HEX: FFFFFC01)
: [S1009] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a v
: alid path. Make sure that the path name is spelled correctly and that y
: ou are connected to the server on which the file resides. [IM006] [Micro
: soft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
L (FOC1406) SQL OPEN CURSOR ERROR

adapter means you have to buy the software to make the specific type of file.
being able to read excel or access via an odbc connection is a thank you to BillGates...but to be able to write one, you need the adapter from your source language, focus. and that's the I-Way group at IBI .. they build the translators..so you have to buy one and add it to your focus installation.

I've never worked with MS Access, but you may need to set up the SQL environment before holding the file as format SQLMAC. Something like:

-*-- Set up the SQL Environment ----------------------------
SET SQLENGINE = SQLMSS
SQL SET SERVER MSCRMUAT
-RUN

Change SQLMSS to whatever MS Access is called in WebFOCUS and change MSCRMUAT to the DB Connection name you gave when you set up the adapter.

Thank you both ... Francis and susannah. I tried the SET SQLENGINE ..... and SET SERVER in the WF MRE procedure, but to no avail. Looks like it's the adapter that's the problem since I can create a Teradata table and I have no problem creating an Access table in Dev Studio.

As it is, to keep my life simple, I will just do a FORMAT COMT or TABT and import this.

thanks again for your replies .... always appreciated !!

alan

hmmm
if you can successfully create an MSAccess table from DevStu, then you must have the adapter... somehow or other... dont give up yet.. someone wiser will come along...
maybe its a function of the serial number you enter when you install devstu, a whole different animal from the serial# you enter with the client...

susannah,

When I use Dev Studio, I'm using my localhost reporting server which allows me to create a table in an Access db.

The problem I'm having is on our remote reporting server running a procedure through MRE ... then I cannot create the table in an Access db sitting on the remote reporting server.

Thanks Francis for your information, I tried your idea in a report and it functioned correctly!!!

Bye!!!

quote:

Originally posted by juancpove:

There are 10 types of people in this world, those who understand binary and those who don't!

funny...