 |
| ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
May 26th, 2005, 05:00 PM
|
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Error With SqlDataAdapter Wizard?
Everytime I try to use the SqlDataAdapter Wizard in VS2003 I get the following error, any ideas?
ADO Error: Line 1: Invalid character near 'COLLATE'
Thnks
|
|
May 27th, 2005, 10:59 PM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
At what point does the error occur? Are you using a stored procedure or a sql statemtnt?
|
|
May 31st, 2005, 08:39 AM
|
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
It occurs at the last step of the wizard. I am using a SQL query, and the insert statement is built fine. Then Insert, Delete, and Update and the three that error all the same way.
|
|
May 31st, 2005, 10:42 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
Can you post the SQL statement you are using?
|
|
May 31st, 2005, 11:42 AM
|
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
SELECT Location_Id, Vet_Pen_Num, Post_To_Pen FROM tbl_Vet_Pen_Xref
HaHa, Real high-tech huh?
Thanks
|
|
May 31st, 2005, 12:04 PM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
Hummm seems pretty straight forward. It is only a problem on the Insert, UPdate and Delete? Can you post your table structure..
BTW, does your table have a primary key?
|
|
May 31st, 2005, 01:43 PM
|
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Location_Id, int, 4
Vet_Pen_Num, varchar, 10
Post_To_Pen, varchar, 10
All three are keys BTW!
thx
|
|
May 31st, 2005, 11:25 PM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
I really don't know what that error means. Maybe you can try to use Google to find something. Also, I would try reinstalling VS. Let me know what happens. Sorry I couldn't be more help.
|
|
|
