|
The qdf_Query is the procedural object, qdf_q is an actual database query that exists within the access DB. I can see it in the query viewer.
The qdf_q query is fully populated as well, so there is no reason why it should not work.
When I tried to integrate the sub query by using SQL, it threw and INNER JOIN Syntax error. The current solution displays "Too Few Parameters, Expected 1". But when i experimented with using a table, it worked fine.
This is confusing me. A table works, but a query that produces a far simpler table, requires additional input? Why is this?
Cheers
Cata
|
|
|
|
|
Well, the only other thing I can think of is that you appear to be using a custom function in your select statement - GetCurrCategory. If this is evaluating to a name that is not recognized in your where clause, you could get the parameter error you mention.
|
|
|
|
|
But the select statement works perfectly. There is a populated query table.
What's more infuriating is that, it works with a standard table.
I know queries require parameteres, but the ones in the sub query are already filled in.
|
|
|
|
|
I've got a problem executing DTS package from ASP.Net.
I use this code:
Dim oPkg As DTS.Package
oPkg = CreateObject("DTS.Package")
oPkg.LoadFromSQLServer("WIN2000", "UID", "password",
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , ,
"Import_Sales_History")
oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing
I used this code before, and it always worked. Now it doesn't. The problem
is that I'm not receiving any error messages, so I cannot find out what's
wrong. When I step through the code I don't see anything unusual. But in
fact it doesn't do anything, no data has been imported. When I execute the
package manually - everything is OK.
|
|
|
|
|
|
Thank you for your reply,minhpc_bk.
i have tried your suggestion ,and now i can execute the pkg quite well. while transforming data from sql server to sql server,however,when i try to execute the transformation between sql server and foxpro ,it always fails.The error handle shows it can successfully execute both ActiveX Task and Dynamic Task, but fail with transformation task.i don't know why.
|
|
|
|
|
|
Thank you so much for your help, minhpc_bk.
it is the permission problem.i now can execute my pkg with sql authentication,however,it is said that with sql authentication is not recommended in most of articles.can you recommend me some information about the permission of sql and files? any will be appriciated! thank you!![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
|
Hi Steven,
That's my pleasure. Over the past one year and half I have learnt a lot from CP, and now it's time to return something to CP. Trying to answer questions in the CP forums, in my opinion, is a good way to do that.
Very nice to know you, Steven.
|
|
|
|
|
I am trying to add and edit records in a CDatabase, CRecordset enviro,
if i comment out the update error everything goes through without a hitch but there is no data updated, with it, it shows no update,
Someone please help, I've been banging my head on the wall with this.
CSetProps is derived from CRecordset
property of int m_textcolor, m_listcolor
datab.Open( NULL,FALSE,FALSE,sDsn,TRUE);
// Allocate the recordset
CSetProps recset( &datab );
// Build the SQL statement
SqlString = "SELECT * FROM Props";
recset.Open(CRecordset::forwardOnly,SqlString, CRecordset::none);
char buff[10];
CDBVariant tvar;
tvar.m_dwType=VT_I2;
recset.GetFieldValue("textcolor",tvar);
//convert the integer for messageing
itoa(tvar.m_iVal, buff, 10);
//This messages current value so we know we are on a record
AfxMessageBox(buff);
//prepare for record to be eddited
recset.Edit();
// msdn says to set the filds null
recset.SetFieldNull(&(recset.m_textcolor), FALSE);
// set new value
recset.m_textcolor = 8;
//tried with and without
recset.SetFieldDirty(NULL);
// always errors
if (!recset.Update())
AfxMessageBox("Error updating database");
recset.Close();
datab.Close();
shotgun
|
|
|
|
|
SQLDataReader should read from the stream. When the incoming stream has image type info [for example, images from a Sql server], the reader can only read a single image. I wonder what is happening.
Apparently, a mixed stream is hard to read:
--------------------------------
while drPic.read
Response.ContentType = "image/bmp"
Response.BinaryWrite(drPic.Item("pic"))
end while
--------------------------------
It has 20 pictures, but I get only one. If I add any other fields, they get skipped.
|
|
|
|
|
I've never used image types in SQL Server, but, are all the images in the same field? Or do you get all the images, each from one field, and try to output all of them with Reponse.BinaryWrite?
If you are trying to output all of them to the browser, then probably you should generate an HTML file that contains all the images. I don't the browser supports displaying multiple images by themselves at once (ie. several URLs for JPG files, one after another)
I've never worked with it, but just an idea.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Luis:
Let's say you are writing out the column that contains 8 rows of, say text (string type), the Execute Reader will get you 8 rows of data for that column assuming you arranged it that way. On the other hand if the 8 rows had data of type image, the Response.Binary write seems to write just the first row and nothing else. I am a bit surprised, but trying to find why this happens?. Also if you wanted both text and image to be read out, it looks like there is something that prevents writing text and image, you get image only. I have been trying several tricks, but so far not much of a success. If I succeed I will let you know.
mysorian
|
|
|
|
|
In your code, you're setting the response type to "image/bmp" and that's why if you output text into the response, you can't see it.
When the response type is "image/bmp", the browser treats everything it gets as a single BMP file. If you send some text (or more images) they're treated as part of the first BMP file. Because of the format of BMP files, you can add data at the end of the file and the image won't be corrupted. So, no matter what you output to the browser, you only see the first image you send.
If you want to see multiple files, you would have to build on the fly an HTML file full of IMG tags.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Thanks. I did try that, may be something else was not correct. Back to the board I think. 
mysorian
|
|
|
|
|
You're welcome. We're here to help! Good luck!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi,
I've a table on Informix database. This table have 40 fields (numeric and text only) and over 10000 records. The conecction is through ODBC. When I use the SELECT * FROM table sentence, the application delay few seconds and then the "DATA TRUNCATED" message appear.
How can I do to dolve this?
ADO present the same problem?
|
|
|
|
|
Yes I know Microsoft has provided provider for OleDB ... but still I must use ODBC to connect to a foxpro database file.
The file is called clients.DBF
The DSN created using Microsoft FoxPro VFP Driver (*.DBF). The DSN is called ClientDB.
I am using following to connect to the ODBC source...
----------------------------------------
Dim c As New Odbc.OdbcConnection("BackgroundFetch=Yes;DSN=ClientDB;UID=;SourceType=DBF;Collate=Machine;SourceDB=c:\Inetpub\wwwroot\App\foxpro_files;Exclusive=No")
----------------------------------------
When I use this code in Windows Based application, it works fine. Connection is opened and my application can read the data.
But when comes to Web Base application... it gives following error which is Way Beyond my intellect ...
------------------------------------------------------------
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
-----------------------------------------------------------
Can Anyone Help me ... Please ... I promise I won't mess with FoxPro again .
Fadee !!
-------------------
Therez No Place like ... 127.0.0.1
|
|
|
|
|
Hi...
If one wants to access ODBC DataSource in ASP .NET, it must be "System DSN".
Reason: ASP .NET WP is executed under separate limited right based user. If
you will create the "User DSN", it would be fine for the windows based
applications but not for ASP .NET as ASP .NET user (which is kind of passive)
will not be able to access it.
However, if you use "User DSN", it is accessible under Windows Application
for the particular user for whom DSN is defined.
fadee...
-------------------
Therez No Place like ... 127.0.0.1
|
|
|
|
|
Hi.
i'm working in an ADO App that uses Access and/or MSSQL Server 2000 and my problem is that when i Execute in the Connection the following:
DELETE x.* FROM [ODBC;DRIVER={SQL Server};UID=USER; PWD=PASSWORD;DATABASE=WORKING_DB;APP=Microsoft Data Access Components;SERVER=CONTROL02;Description=SQLServer].test_table01 x WHERE clave like '_017%'
i get an error "could not delete from specified tables".
notes:
needs to be with odbc.
I didn't made the database.
I tried using different user accounts.
Tried trusted connection
my permissions all to read write
with and without alias to x.*, and removed the *
my connection string:
Provider=Microsoft.Jet.OLEDB.4.0; Password=PPP;User ID=UUU;Data Source=XXX;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
even in Access it won't work.
what i'm doing wrong?
|
|
|
|
|
Hey im new to ASP.NET web applications and sql server and am just starting to get a grip of web applications but I have been trying in vain for the last few days to get this walkthrough (that’s available with Visual Studio .NET) to connect to my sql server database but every time I try to run the application I get this error that says that the user “ASP” could not be logged on and so access is denied. Im just wondering if anyone has any ideas what the problem is or how I would go about solving it
Thanks in advance
Tadhg88
|
|
|
|
|
You are using a trusted connection, the ASP.NET application runs within a user account. You must grant permission to that account in SQL Server.
1. Find out the name of the user that ASP.NET using in IIS:
To find the name of the user open IIS. Open the properties dialog for the virtual directory your application is in. Select the Directory Security Tab. Press the edit button for the Anonymous access group. And take note of the user name.
2. Allow that user to login to SQL Server.
Open SQL Server Enterprise Manager. Open the Security/Logins folder for your SQL Server instance. Right click the Logins folder and select "New Logins...". Click the elipsis button (...) and select the user from the list. Press Add. Press Okay. Select the Database Access tab. Ensure the login has access to the database(s) that you want to use. Press Okay.
The user now has "public" access to the databases you have selected on your SQL Server.
Does this help?
Do you want to know more?
|
|
|
|
|
Hi all.
My problem is pretty simple. I was just wondering if a application based on a Access mdb file database can be deployed in a System that doesnt have MS Access installed.
The OS is Windows XP. The question is: Are the odbc drivers and the jet drivers for Access databases installed with MS Access or do they come with the OS? I know the app will run if the drivers are present, doesn't matter if Access is installed or not.
I cant test any similar environment because all computers here have Office installed and even uninstalling I cant be sure if the drivers are left behind or they really did come with Windows.
P.d. If drivers dont come with OS, is there a way (legal please) to install them without having to install MS Access?
Thanks for any help.
|
|
|
|
|
hmmm... yes, I there is no need to install Access driver on client machine. If no office is installed, it will work.
I remember that I have tested this and it was working fine.
MS Access installation would be required if you are creating objects of certain ActiveX components exposed by Access. But I am very much sure you are not doing so. So, I think it will work fine.
Also, another guess, I think to access Access Database, MDAC (or watevva it is) is required on client machine, and Windows XP by default contains this.
Another supporting argument: What MS Access installation has got to do with database connectivity? On servers, Microsoft discourages the installation of MS Office products. And all MS based servers still support Access connectivity.
So bottom line: No need to worry about.
Good Luck
fadee!
-------------------
Therez No Place like ... 127.0.0.1
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
