By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Invalid Object name: Acccess 2000 Premium

Dököll
Expert 100+
P: 2,364
Greetings, Good buddies!

This one is kind of simple but I am not able to figure out. I am gettting this error:

Invalid Object name... I have no idea why I am not connecting to the Server, tests went fine.

Here is a query, skillfully written:-)

Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT * FROM Email;
  3.  
  4.  
Here is my ODBC connection:

Expand|Select|Wrap|Line Numbers
  1.  
  2. ODBC;Description=MySQLData;DRIVER=SQL Server;SERVER=.\SQLEXPRESS;Trusted_Connection=Yes
  3.  
  4.  
I should perhaps tell you the system asked to save password info to ODBC string, I said heck no, so I got the above.

Also I am not sure if because the DataSource not listed in the string is the problem. Not certain why the Description would show and not the...

Wait a second, I can just plug it in...

Hang on
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


Dököll
Expert 100+
P: 2,364
No, same deal... I tried:

ODBC;DataSource=MeSQLData;DRIVER=SQL Server;SERVER=.\SQLEXPRESS;Trusted_Connection=Yes

That did not work. What are your thoughts.

The ODBC connection said it was successful upon set up, and tested.

Thanks!

Dököll
Jan 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.