Why can't I see any tables when I connect to SQLServer?

Easysoft dbExpress-ODBC Gateway

Why can't I see any tables when I connect to SQLServer?

Article :	00693
Last Reviewed :	19th July 2005
Revision :	1

This is because the dbExpress interface seems to insist on setting the schema name to the user name in the connection.ini file. So for instance in the following entry (where the user name is a NT user account):

[sql_server]
BlobSize=-1
Database=sql1
DriverName=ODBC
Password=pwd
User_Name=Nick Gorham

when the tables call is made, the dbExpress interface will set the schema of the SQLTables call to "Nick Gorham".

This may be what you want, but in most cases it won't be. The solution is to use the alternative connection method by encoding the user name in the connect string and leaving the user name field empty, so that the tables call is made with no specified schema:

[sql_server]
BlobSize=-1
Database=DSN=sql1;UID=Nick Gorham;PWD=pwd
DriverName=ODBC
Password=
User_Name=

Applies To

Products
- Easysoft dbExpress-ODBC Gateway
Databases
- Microsoft SQL Server

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft dbExpress-ODBC Gateway

Why can't I see any tables when I connect to SQLServer?

Applies To

Knowledge Base Feedback