Loose ODBC conection

I am very new to all this

I have a access databse wich uses a ODBC conection to mysql server. I
can open the and run the database find but if i leave the dadabase
loaded but do not use it when i go back to it is has lost the
conection and i need to close the databse and reopen it

If there a way to make sure i alwasy have a coenction

Thanks(S.Dickson@.shos.co.uk) writes:

Quote:

Originally Posted by

I am very new to all this
>
I have a access databse wich uses a ODBC conection to mysql server. I
can open the and run the database find but if i leave the dadabase
loaded but do not use it when i go back to it is has lost the
conection and i need to close the databse and reopen it
>
If there a way to make sure i alwasy have a coenction

That seems like an Access problem to me. Maybe you should ask in an
Access newsgroup.

Do you use MySQL or is that just a typo? This news group is for
MS SQL Server, and not MySQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

LOOKING FOR SITE WITH NOTES ON HOW I CAN CHANGE THE KNOWLEDGE OF MSSQL I HAVE TO ORAC

Hi developers!
I'm looking for the link where I can easily read and understand the way I
can transfer the knowledge I have of MSSQL to ORACLE and simply create some
procedures, views,functions,triggers,tables etc using ORACLE Database.
Anyone who can help on this will be highly appreciated.
Regards,
ComfortI'd try Oracle's site or just google it.
--Mary
On Mon, 14 Feb 2005 15:38:09 +0300, "Comfort" <comfort.peter@.stcl.com>
wrote:

>Hi developers!
>I'm looking for the link where I can easily read and understand the way I
>can transfer the knowledge I have of MSSQL to ORACLE and simply create some
>procedures, views,functions,triggers,tables etc using ORACLE Database.
>Anyone who can help on this will be highly appreciated.
>Regards,
>Comfort
>