My first recommendation is to switch to ADO. It is much faster.
Bruce Lewis
- Original Message -
From: Thomas Bein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 16, 2003 12:55 PM
Subject: VB6 ODBC Memory problems
Hello,
I have been developing an application in VB60
Where I work:
1) We created a table for holidays (projected data for the next few years).
2) Created a function for the day of the week.
3) If M-F and not Holiday, then perform routine.
We had to go this route because there are way too many bank and market
holidays to keep straight with just
Yes, you need to specify the IP address that you plan on using for this
process instead of the computer name.
If you use Windows, chances are your using MYODBC or some other similar
driver.
Case #1: You setup a DSN in the ODBC area of the OS
Case #2 You setup a DSN-less connection to your db.
Why not try Tek-Tips? Maybe they will sponsor something for free. They may
have everything you need.
Just a thought.
[EMAIL PROTECTED] [EMAIL PROTECTED]
Bruce
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Peter Lovatt [EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect
Having the fastest memory that is available in your system is not as
important as having enough memory in your system. Without sufficient
memory, you can choke your whole system and bring your server to a crawl (or
even crash).
Bruce
- Original Message -
From: Nicolas MONNET (Tech)
You may want to check the advanced features of your Linksys router. There
may be an IP imposed limit for the MYSQL server to the outside world.
It is part of a configuration that you can alter. Check the IP filtering
area.
Bruce Lewis
- Original Message -
From: Egor Egorov [EMAIL
It is very possible. Your network may need an update as to what the new IP
address is. Most networks take anywhere from 20-30 minutes to get the
updates (depends upon your network administrators configuration). Another
may be with your code. If you are using ODBC, you may need to change the
One other simple task that you can try is to just perform a ping. If you
can ping the server with the new IP address, then your network is not the
problem.
Bruce
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Chris Walcott [EMAIL PROTECTED]; Mysql-L (E-mail)
[EMAIL
You need an InnerJoin to perform the operation similar to:
UPDATE table1 SET table1.field1 = table2.field1, table1.field2 =
table2.field2,...
INNER JOIN Table1 ON Table2.ID = Table1.ID
Bruce Lewis
- Original Message -
From: STIBS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
You need to include the field names along with the table name.
UPDATE table1 INNER JOIN Table1 ON Table2.FieldID = Table1.FieldID
Set Table1.Field1=Table2.Field1, Table1.Field2=Table2.Field2, ...
Bruce Lewis
- Original Message -
From: Greg Knaddison [EMAIL PROTECTED]
To: [EMAIL
Check your ini file to make sure the path reflects the proper location of
the database.
Bruce
- Original Message -
From: Steve Bradwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:14 AM
Subject: startup on win2000 as service not working.
Hi everyone,
I
I don't know how you have your system configured, but mine has the root only
functional on the localhost.
Bruce
- Original Message -
From: toby - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 9:22 AM
Subject: Re: access denied
I have not done this, but I know you can do it in a round-about way.
You can download the MSDE from Microsoft and convert it to one of numerous
db formats, and from there MYSQL will import it.
Filemaker Pro 5.0 with their ODBC driver is needed though. FMP is not 100%
ODBC compliant, but you
Your missing your closing } at the end of the else statement.
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]; php-general
[EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:09 PM
Subject: stupid error, please kick me (and send me a solution)
Hey
Actually, W2K has a scheduler built in that works pretty well for basic
scheduling needs. If you are using NT 4.0, try and upgrade to SP6a. That
SP has the scheduler of W2K built in as well.
Bruce
- Original Message -
From: Opus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
15 matches
Mail list logo