INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

cannot connect to sql view

cannot connect to sql view

(OP)
Hi

I am using ODBC to connect to a view in our SQL server. After I have selected the view I am getting the following error message

"CUST.ID is not a valid name. make sure that it does not include invalid characters or punctuation and that it is not to long"

If I click OK it then gives me some options to link with none of which have anything to do with the view I want to import. It then links something which is not the view I want and usually a total different name.

How do I get around the error message in the first place. Any ideas please

Thanks

RE: cannot connect to sql view

CUST.ID follows, like in access, a tablename.columnname syntax.

If that is the name of a column in your view, the wizard may not be able to deal with the field name. You could change it in the view to perhaps CUST_ID and it may work then... or at least move along to the next issue.

RE: cannot connect to sql view

Agree. Use underscore, or alias the column name in the view to something that follows syntax rules.

Beir bua agus beannacht!

RE: cannot connect to sql view

(OP)
Hi

The CUST.ID is the alias name but understand what you mean, renamed is here so it exported into CSV through SSIS easier with the naming convention expected. I will change it and see if things are ok afterwards. I get back with the result

Thanks for the reply's

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close