|
 We have an old DOS program that is still in use daily. I am trying to use the existing dBase database (not sure what version) and write a more user friendly interface in vb6. I have used and ADO control and am connecting through ODBC. I can populate the datagrid control without a problem, but when I try try:
Adodc2.RecordSource = "SELECT * FROM Supplier WHERE JOB_NO = '" & JobNumber & " '"
I get a data type mismatch for the JobNumber. The job number would typically be 1394.02 for example. I have tried declaring it as an Integer, String, long, short and double. I keep getting the same error:
[Microsoft][ODBC dBase driver] data type mismatch in criteria expression.
I have been trying to sort this out for the last six hours. Can anyone help?
Byron
|
|
|
|
|
try not enclosing numericals in quotation marks
Adodc2.RecordSource = "SELECT * FROM Supplier WHERE JOB_NO = " & JobNumber
|
|
|
|
|
Thanks, that sorted it out.
|
|
|
|
|
please show me on how to connect my SQL database using web services
given2fly
|
|
|
|
|
you have to be a little more clear...
do you want to be able to retrieve and update the database(s)?
what languages and environments are you going to use? (ASP.NET/C#?)
with ASP.NET and visual studio, i would start with making a simple web service application, then write the methods i would want to expose, along with any private methods required
if you intend to send and receive any complex data, then you should probably design your message format beforehand.
see Place XML Message Design Ahead of Schema Planning to Improve Web Service Interoperability
also a general guide to webservices:
How ASP.NET Web Services Work
|
|
|
|
|
je dois faire une classe en C++ réalisant une communication avec une base de donnée je souhaiterai connaitre le nom de la classe ki gère cette communication sinon quelles sont les méthodes k je devrai utiliser
Merci d'avance;P
MagicFans91
|
|
|
|
|
English please....... 
I was born intelligent
Education ruined me!.
|
|
|
|
|
are you asking about inheritance in c++?
|
|
|
|
|
salut
tu devrais changer de forum en choisir un en français par exemple 
pour faire ce que tu veux cherche vers ADO
vas voir sur ce site il y a des exemples et des tutoriaux
http://www.cppfrance.com/
je peux pas t'aider plus je suis pas très douée
bon courage
Maeva
|
|
|
|
|
Hi all,
All these days, I was working with MS Access and deploying the same to the server was easier for me... (jus a upload).
Now, I am working on a project with SQL Server 2000 and this is going to be deployed into an Intranet Setup. So, the scenario is to in stall the database with few tables' contents mainteined. Even though this is going to be taken care by the 'intstallation team', I am quite curious to know about the process
My requirement is...
*** How would I take the database tables and the contents to the client's place (obviously it should be in CR-ROM, but How is the copying process done?)
*** How is the database installed into the client's SQL Server?
*** What next???
Thanks in advance.
I was born intelligent
Education ruined me!.
|
|
|
|
|
|
Thanks.. will walk through these one by one...
I was born intelligent
Education ruined me!.
|
|
|
|
|
i think he was asking more about how the data would be installed, etc... not how to deploy MSDE in an install...
usually i take the lazy root and let SQL enterprise manager generate the scripts for me, then i export the data from my machine and re-import on the target machine...
|
|
|
|
|
I have datasets with multiple tables that I would like to save as a new Access database (or at least an Excel workbook) instead of XML.
The format does change a bit, so I really don't want to go through a bunch of hoops hardcoding every table and field.
Isn't there a way to simply save a dataset as an MDB?
(ie, for each table in the dataset, create a table in the MDB of the same name, with the same fields, and the same records.)
I know it's a little unusual to do, but shouldn't this be simple?
|
|
|
|
|
I am having problems building a Query and would really appreciate if anybody had any ideas. I need to build a query where I select only the new people that have come in during a quarter that have children ages 0 to 5. (ie The person does not get counted if they came in during another quarter that year) I have been making multiple queries and runnning this report using VB6 code and it is very slow. Below is a list of my tables and other info: (I've simplified the tables to make it easier to list.)
Language\DB: VB6, DAO 3.6, Access Database
Tables\Queries:
tbl_Customer
l_Mem_id (Key)
dt_DateCreated
str_First_nm
str_Last_nm
Qry_Child
l_ID_id (Key)
l_Mem_id
dt_DOB
str_Name
l_age (l_Age: Int((DateDiff("d",[dt_DOB],Now()+1)/365.25))
Qry_Visit
l_ID_id (Key)
l_Mem_id
dt_Date
str_Reason
l_Quarter (l_Quarter: DatePart("q",[dt_Date])
Any help would be appreciated! Thanks 
|
|
|
|
|
Not sure if the exact syntax will work in Access, but here goes:
SELECT * FROM tbl_Customer WHERE
l_Mem_id IN (SELECT l_Mem_id FROM Qry_Child WHERE l_age BETWEEN 0 AND 5) AND
l_Mem_id IN (SELECT l_Mem_id FROM Qry_Visit WHERE dt_Date BETWEEN @startdate AND @enddate)
What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.
|
|
|
|
|
Many thanks. I added a NOT IN statement to exclude them if they came in during another Quarter. One problem that I am having is the number of people is inconsistent if you run the query a couple of times. I even added people during earlier quarters that showed up during the specified dates and it would not show the person after I did a requery but the number of people would sometimes stay the same or change to 1 less and sometimes 2-3 times less people. I have inserted the revised SQL statement below Any suggestions?
SELECT * FROM tbl_Customer WHERE l_Mem_id In (SELECT l_Mem_id FROM Qry_Child WHERE l_age BETWEEN 0 AND 5) And l_Mem_id In (SELECT l_Mem_id FROM tbl_Visit WHERE dt_Date BETWEEN #4/1/2003# AND #6/30/2003#) And l_Mem_id Not In (SELECT l_Mem_id FROM tbl_Visit WHERE dt_Date BETWEEN #1/1/2003# AND #3/31/2003#)
|
|
|
|
|
I think I see a possible issue here.
If a member has a visit between 4/1/2003 and 6/30/2003 and the same member has a visit between 1/1/2003 and 3/31/2003, is that member included or excluded?
Also, after I wrote this last night, I realized that the same query might be feasible with an INNER JOIN...
SELECT * FROM tbl_Customer
INNER JOIN Qry_Child ON tblCustomer.l_Mem_id = Qry_Child.l_Mem_id
AND Qry_Child.l_age BETWEEN 0 AND 5
INNER JOIN tbl_Visit ON tblCustomer.l_Mem_id = tbl_Visit.l_Mem_id
AND (tbl_Visit.dt_Date BETWEEN #4/1/2003# AND #6/30/2003#)
AND NOT (tbl_Visit.dt_Date BETWEEN #1/1/2003# AND #3/31/2003#)
What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.
|
|
|
|
|
They are excluded. They are only counted once a year. I tried to run your query and it returned no results. I tried playing with it a little and inner joining the Qry_Child and running subqueries on the tbl_Visit (IN and NOT IN) but only recieved errors.
Also, could you possibly explain the difference of when to join tables and when to use a subquery. I am still having trouble understanding the logic. Thanks.
|
|
|
|
|
Yeah, I suppose joins are best applied when you want to include fields from table on both sides of the join statement, but they can be applied to form the basis for including or excluding rows. Since it was late last night, the idea of INNER JOINS might be flawed... I always seem to try several things until I get the one thing that works consistenly.
* thinking out loud *
SELECT table1.*, table2.* FROM table1 RIGHT JOIN table2 ON table1.key = table2.fkey WHERE ...
-- all rows from table2 and matching rows from table1
SELECT table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.key = table2.fkey WHERE ...
-- all rows from table1 and matching rows from table2
SELECT table1.*, table2.* FROM table1 INNER JOIN table2 ON table1.key = table2.fkey WHERE ...
-- only matching rows from table1 and table2
SELECT table1.*, table2.* FROM table1 FULL JOIN table2 ON table1.key = table2.fkey WHERE ...
-- all rows from table1 and table2
Ok, so that's the difference, using IN or EXISTS simply forms the basis for inclusion or exclusion of rows from the table specified in the FROM clause, whereas using a join does as described above.
So, it seems like your example should work consistently, unless the underlying data are changing so often that the results change accordingly. If you like, you can send me some or all of the data and I can try it out.
What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.
|
|
|
|
|
I ran the query a few more times today and it seemed to work fine without the small discrepancies. I can't send any of the data b/c some of the data falls under HIPAA. Again, thank you for all your help.
-Garrett
|
|
|
|
|
hello
I have created a windows application with visual c++ 6.0 which connects to a database.
The application executes SQL queries and I want to set some triggers or the insert, update and delete queries.
However, Where should i place my triggers?
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=s",sDriver,sFile);
TRY
{
CDatabase ComboDatabase;
// Open the database
ComboDatabase.Ope(NULL,false,false,sDsn);
// Build the SQL statement
SqlCommand = "INSERT INTO BandSetting "
"VALUES('" + str25 + "'" ",'" + str1 + "'" ",'" + str2 + "'"
",'" + str3 + "'" ",'" + str4 + "'" ",'"+ str5 + "'" ",'"+ str6 + "'" ",'" + str7 + "'" ",'" + str8 + "'" ",'"+ str9 + "'" ",'" + str10 + "'" ",'" + str11 + "'" ",'"+ str12 + "'" ",'" + str13 + "'" ",'" + str14 + "'" ",'" + str15 + "'" ",'" + str16 + "'" ",'" + str17 + "'" ",'"+ str18 + "'" ",'" + str19 + "'" ",'" + str20 + "'" ",'"+ str21 + "'" ",'" + str22 + "'" ",'" + str23 + "'" ", + str24 + "'" ")" ;
ComboDatabase.ExecuteSQL(SqlCommand);
// Close the database
ComboDatabase.Close();
}
where do i put the trigger???
hope you guys can help me out on this! thanks (^_^!!)
|
|
|
|
|
solostar*** wrote:
where do i put the trigger???
Trigger does not run from your application , you have to create it in your SQLServer(don't know if access suport triggers) , then it will call automaticlly.
Mazy
You're face to face,
With the man who sold the world - David Bowie
|
|
|
|
|
I don't know if I should put this under php or sql, but it is a little of both. I have secure info that I do not want published to a file on the server at any time even a few seconds. I just want to take it strait out of the data base and have the person click a link, to this php file below and when they go to it it prompts them to download. I want the sql info in the file. I think I have most of the code right, but it isn't quite working. As of now, it is downloading a blank file.
<br />
function show_file_information($filename)<br />
{<br />
@readfile($filename);<br />
}<br />
<br />
if(!class_exists(MySQL))<br />
{<br />
require '../home/MySQL.php';<br />
require '../home/conf_global.php';<br />
$mysql = new MySQL();<br />
$mysql->connect($INFO['sql_user'],$INFO['sql_pass'],$INFO['sql_database'],$INFO['sql_host']);<br />
}<br />
<br />
$news_result = $mysql->query("SELECT * FROM newsletters WHERE id='1'");<br />
$news = mysql_fetch_assoc($news_result);<br />
<br />
$filename = $news['add_id'];<br />
<br />
header("Pragma: public");<br />
header("Expires: 0");<br />
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); <br />
header("Content-Type: application/force-download");<br />
header("Content-Type: application/octet-stream");<br />
header("Content-Type: application/download");<br />
header("Content-Disposition: attachment; filename=".basename(emaillist).".txt");<br />
header("Content-Transfer-Encoding: binary");<br />
header("Content-Length: ".strlen($filename));<br />
<br />
<br />
?> <br />
LOSTTWARE.com
My site allows for people to develop private programming teams, with password protected forums for each team.
|
|
|
|
|
I'm trying to connect to an MSDE database that is running on my local machine and I've tried the following connection strings:
Provider=[SQL Server]; Server=(local); Trusted_Connection=no; Database=users; Uid=me; Pwd=123456; When I use that one I get an error that "Provider cannot be found. It may not be installed properly." I did install a SQL Server prodvider though the ODBC control panel, but I don't know if that was the right thing to do (this is my first time trying to program for a database). The other connection string I tried was:
Provider=MSDASQL; Server=(local); Trusted_Connection=no; Database=users; Uid=me; Pwd=123456; The error I get on that string is "[Microsoft][ODBC Driver Manager]Data source name not found an no default driver specified." Could someone point out what I'm doing wrong here. Thanks in advance for the help. I'm using the ADO classes written by Carlos Antollini (http://www.codeproject.com/database/caaadoclass1.asp[^]) to try to connect.
- monrobot13
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
