i am unable to trieve the date in ms-access

hi friends,

I am trying to create alert system in which i can able to retrieve the date while configure the OleDbDataAdapter1 itself the

problem occurs this is the code i tired

select * from table name (username=?) and (date=)

after entering this error occurs

You haven't mentioned about SQL Server version you are using, refer to this http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ link in this case where it explains how you can achieve from SQL Server side.

IN SQL Server 2000 you can use DTS to get (import) the data from any other data provider and you can schedule the DTS package too.

|||

hi

i am not using MS SQL server but i am using ms access

i am unable to trieve the date in ms-access

hi friends,

I am trying to create alert system in which i can able to retrieve the date while configure the OleDbDataAdapter1 itself the

problem occurs this is the code i tired

select * from table name (username=?) and (date=)

after entering this error occurs

You haven't mentioned about SQL Server version you are using, refer to this http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ link in this case where it explains how you can achieve from SQL Server side.

IN SQL Server 2000 you can use DTS to get (import) the data from any other data provider and you can schedule the DTS package too.

|||

hi

i am not using MS SQL server but i am using ms access

i am unable to trieve the date in ms-access

hi friends,

I am trying to create alert system in which i can able to retrieve the date while configure the OleDbDataAdapter1 itself the

problem occurs this is the code i tired

select * from table name (username=?) and (date=)

after entering this error occurs

You haven't mentioned about SQL Server version you are using, refer to this http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ link in this case where it explains how you can achieve from SQL Server side.

IN SQL Server 2000 you can use DTS to get (import) the data from any other data provider and you can schedule the DTS package too.

|||

hi

i am not using MS SQL server but i am using ms access

I am trying to install and config MySQL ... if there is a FAQ I will read ...

Hello,

My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.

1) When I run the Config Wizard, I get the following message:

"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Suggestions please.

Kind regards, Vasya"Vasya" <vigalchin@.gmail.comwrote in message
news:1193890280.276080.101840@.d55g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

Hello,

There probably is a FAQ, but this newsgroup is dedicated to Microsoft SQL
Server, so any help here will be limited.

(though I'll recommend looking at SQL Server Express 2005).

Quote:

Originally Posted by

>
My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.
>
1) When I run the Config Wizard, I get the following message:
>
"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

Yes, there is an event log. I don't have Vista so not sure if they've moved
it but on XP you can go to My Computer, right click, click on MANAGE and
drill down from there.

Quote:

Originally Posted by

>
>
2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Search and replace / with \ ?

Quote:

Originally Posted by

>
Suggestions please.
>
Kind regards, Vasya
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html