Hi,

I'm trying to setup wfqbe in an existing TYPO3 installation.
I could manage to create an authentication record which allows me to target
the QBE wizard to the local TYPO3 base (on mysql), so I think I got it to be
correctly installed.

However I have a hard time connecting to the remote MSSQL server. The QBE
wizard tells me the connection fails.

I don't know much about wfqbe and nothing about mssql either (I'm an oracle
and mysql guy). What puzzles me is that I have a server name of the form
XXXXX\YYYYY, then something that looks like a DB name, and usual
login/password. I can use those data to browse the server with MS's
enterprise server tools, so I think they are good.

I don't see why wfqbe doesnt want to connect to MSSQL.

Is there a way of getting logs out of wfqbe ?

Thanks for any input !

--
Alex
[JDR] Visitez Extremia, un monde gratuit et en francais pour D&D et
autres jeux de role.
www.extremia.org


_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi Alex,
> Hi,
>
> I'm trying to setup wfqbe in an existing TYPO3 installation.
> I could manage to create an authentication record which allows me to target
> the QBE wizard to the local TYPO3 base (on mysql), so I think I got it to be
> correctly installed.
>
> However I have a hard time connecting to the remote MSSQL server. The QBE
> wizard tells me the connection fails.
>

What error type do you get? Is it a wfqbe output or a server connection
failure?

> I don't know much about wfqbe and nothing about mssql either (I'm an oracle
> and mysql guy). What puzzles me is that I have a server name of the form
> XXXXX\YYYYY, then something that looks like a DB name, and usual
> login/password. I can use those data to browse the server with MS's
> enterprise server tools, so I think they are good.
>

To connect to a MSSQL server you need to specify the host (in the form
XXX\YYYY), the DBMS type (MSSQL server), the username and the password.
I tested it this morning and it works fine.

> I don't see why wfqbe doesnt want to connect to MSSQL.
>
> Is there a way of getting logs out of wfqbe ?
At the moment this is not possible... I'll add it in a new version.

Can you send me the error you get so I can check it?


Regards,

--
Mauro Lorenzutti


e-mail: mauro.lorenzutti (AT) webformat (DOT) com

---------------------------------------------------------
WEBFORMAT srl | Corte Europa, 12 | I-33097 SPILIMBERGO PN
Tel +39-0427-926.389 -- Fax +39-0427-927.653
info (AT) webformat (DOT) com -- http://www.webformat.com
---------------------------------------------------------
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi Mauro !

"Mauro Lorenzutti" <mauro.lorenzutti (AT) webformat (DOT) com> wrote in message
news:mailman.303773.1181028062.21067.typo3-english (AT) lists (DOT) netfielders.de...
>
> What error type do you get? Is it a wfqbe output or a server connection
> failure?

when I click on the yellow/red question mark icon on the right of the query
box, I get this :
| Wizard for query creation
| -----------------------------------------------------

| Connection failed. Please check your credentials and the dbname.

However, I really think they are right.

> To connect to a MSSQL server you need to specify the host (in the form
> XXX\YYYY), the DBMS type (MSSQL server), the username and the password. I
> tested it this morning and it works fine.

OK, that syntax xxx\yyy looked strange, but it works on SQL Query Manager
and in another PHP code on another part of the site (not using TYPO3).

BTW, I have ADODB installed. Is there anything else required for MSSQL ? The
other PHP script I have uses an odbc connection.

> At the moment this is not possible... I'll add it in a new version.

great

> Can you send me the error you get so I can check it?

See above.

Thanks for your help !

--
Alex
[JDR] Visitez Extremia, un monde gratuit et en francais pour D&D et
autres jeux de role.
www.extremia.org


_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi Alex,
> OK, that syntax xxx\yyy looked strange, but it works on SQL Query Manager
> and in another PHP code on another part of the site (not using TYPO3).
>
> BTW, I have ADODB installed. Is there anything else required for MSSQL ? The
> other PHP script I have uses an odbc connection.
>

Ok, you can try to connect using odbc by I'm still working to make wfqbe
odbc compliant and I'm not sure it works now.

Otherwise, check your php.ini file. Probably you'll find a row like the
following one:

;extension=php_mssql.dll

Try to remove the ";" from the beginning, save the file and restart
apache. Try to connect again with wfqbe.
Please, let me know if this was the problem.

Regards,

--
Mauro Lorenzutti


e-mail: mauro.lorenzutti (AT) webformat (DOT) com

---------------------------------------------------------
WEBFORMAT srl | Corte Europa, 12 | I-33097 SPILIMBERGO PN
Tel +39-0427-926.389 -- Fax +39-0427-927.653
info (AT) webformat (DOT) com -- http://www.webformat.com
---------------------------------------------------------
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

"Mauro Lorenzutti" <mauro.lorenzutti (AT) webformat (DOT) com> wrote in message
news:mailman.304665.1181050280.21067.typo3-english (AT) lists (DOT) netfielders.de...

> ;extension=php_mssql.dll
>
> Try to remove the ";" from the beginning, save the file and restart
> apache. Try to connect again with wfqbe.
> Please, let me know if this was the problem.

I did that and restarted the whole computer, but the error is still the
same.

I'm a bit puzzled.

--
Alex
[JDR] Visitez Extremia, un monde gratuit et en francais pour D&D et
autres jeux de role.
www.extremia.org


_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Alex ha scritto:
> "Mauro Lorenzutti" <mauro.lorenzutti (AT) webformat (DOT) com> wrote in message
> news:mailman.304665.1181050280.21067.typo3-english (AT) lists (DOT) netfielders.de...
>
>
>> ;extension=php_mssql.dll
>>
>> Try to remove the ";" from the beginning, save the file and restart
>> apache. Try to connect again with wfqbe.
>> Please, let me know if this was the problem.
>>
>
> I did that and restarted the whole computer, but the error is still the
> same.
>
> I'm a bit puzzled.

Have you ever tried to connect to MSSQL with a small PHP code? Try to
write some PHP lines of code to connect to your dbms and check if the
connection is possible via PHP.

This may be useful:
http://it2.php.net/manual/en/ref.mssql.php

(take a look to the requirements paragraph).

Regards,

--
Mauro Lorenzutti


e-mail: mauro.lorenzutti (AT) webformat (DOT) com

---------------------------------------------------------
WEBFORMAT srl | Corte Europa, 12 | I-33097 SPILIMBERGO PN
Tel +39-0427-926.389 -- Fax +39-0427-927.653
info (AT) webformat (DOT) com -- http://www.webformat.com
---------------------------------------------------------

_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english