|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Using QODBC with Visual Studio .NET 2005 |
| Author |
Message |
|
|
| Posted : 2006-11-07 05:58:01 |
When I use the server explorer in VS .NET 2005 to "Show Table Data", it gives a permission error.
However, I can create a new query and when I execute the query it works.
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-11-07 11:20:34 |
When Using QODBC
Check that you are not running QODBC still in 2.1 ODBC Compatibility Mode. This must be unchecked in the QODBC Advanced Setup screen.
If you try to add a QODBC database as a datasource in the datasource box, you will get the message "An error occured while retrieving the information from the database: An item with the same key has already been added."
You can instead go the dataset designer and add a tableadapter and it will create the table and add it to the datasources. The only problem with doing it this way is that the UPDATE, INSERT, and DELETE methods aren't created. Appearently this is a bug in visual studio 2005. |
|
|
|
|
|
| Posted : 2006-11-08 12:12:51 |
Unchecked the 2.1 compatibility checkbox and tried again. It still gave me permission error. I have QB Premier 2007 Wholesale and Manuf.
Regards,
Ron |
|
|
|
|