Re: Data block wizard with OCA

I used the .SQL script that comes with OCA for SQL Server to create the tables ALL_TABLES, ALL_VIEWS etc... The problem seems to come from elsewhere. Has anyone reading this aver used the datablock wizard with a connection to a SQL Server 6.5 database?

>Did you specify the all_tables all_views user_tables and user_views on
>your server. This is what developer needs to make the wizard work.
>
>Try to make this views on your server - you can create a new view
>or a new table containing the necessary data.
>
>Jonathan Gauthier heeft geschreven in bericht ...
>>I'm trying to create a data block with the data block wizard in form
>builder
>>with an odbc datasource to a mssql(sql server) database but I keep getting
>>the error message ORA-01012: not logged on when I input the name of the
>>table and click on refresh to get the columns names. If I try to click on
>>browse instead I get nothing at all.
>>
>>I know my connection works because I can go in the mssql database with
>>oracle sqlplus and do a select * from all_tables;
>>
>>Here is my configuration
>>
>>Forms 5.0.5.4.0
>>MSSQL 6.5
>>ODBC Sql Server driver from Microsoft
>>- I could not try with the odbc driver from intersolv because I'm using a
>>trial version of forms and the driver is not included
>>
>>Please email me directly, I don't always read newsgroups
>>
>>
>>
>
>
Received on Mon Jan 18 1999 - 15:30:12 CET