Welcome, Guest
Please Login or Register.    Lost Password?

EXternal MS-SQL connected,but can't see real data
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!


Go to bottomPage: 1
TOPIC: EXternal MS-SQL connected,but can't see real data
#300
EXternal MS-SQL connected,but can't see real data 5 Months, 1 Week ago Karma: 0
I installed Table JX latest version on LINUX(FEDORA9,Lampp,Joomla1.5.15)

and I installed FreeTDS and unixODBC.

I can connect external MSSQL, and at table list box,
I can see and choose tables.

but I can't see real data rows.
I can see only column name.
even though there are the result of record Nr.

I tested IE and Firefox also.
it working well with internal mysql
but external DB data can't see real row data...

I will attach the screen capture.
Please help me A.S.A.P!!!

and one more question!
How can I resize search box. it's too big!!


wanderer
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/18 02:15 By wanderer.
The administrator has disabled public write access.
 
#301
Re: EXternal MS-SQL connected,but can't see real data 5 Months, 1 Week ago Karma: 0
Hello wanerer,

Please check if your table in database contains spaces in column names. This can be a problem, but it can be solved.

Search box is really strange... did you change its height? You can alter it in GreadView.php.

Regards,
Bostjan
Bostjan
Senior Boarder
Posts: 45
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#302
Re: EXternal MS-SQL connected,but can't see real data 5 Months, 1 Week ago Karma: 0
Thanks for your reply.
I checked my DB table column names.
But there are no space in column names.
Ummm...
Is there another thing to check???


And I didn't change search box height. I don't know to change height.
How in Gridview.php can I change it??
wanderer
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#303
Re: EXternal MS-SQL connected,but can't see real data 5 Months, 1 Week ago Karma: 0
Can you send me printscreen or ddl of your mssql table definition on customers@toolsjx.com - maybe I will see if there is any other problem... also please send me printscreen of your tablejx definition in admin module (erase eny server ip or passwords!!! - I dont need or want that )


check function searchForm in GridView.php try setting your own style for <input ... type="text" and type="submit"
I really don't know what is cousing this behaviour - perhaps it has something to do with styles defined by your template...

Regards,
Bostjan
Bostjan
Senior Boarder
Posts: 45
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#312
Re: EXternal MS-SQL connected,but can't see real data 5 Months, 1 Week ago Karma: 0
I sent a e-mail.


And I have one more ploblem.

I can see view(table)at lists of tables,if I connect with internal mysql.

but if I connect with external MSSQL, I can't see view(table)at lists of tables.

Please check it and reply!!
wanderer
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/21 21:36 By wanderer.
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting