i already try to use the following commands
exec sp_attach_db 'example','c:\example.mdb'
but i got the following error message
The header of this file 'c:\example.mdb' is not a valid database file header. The FILE SIZE property is incorrect.sp_attach_db is not what you need. You need to create a linked server. Seesp_addlinkedserver.
Terri|||thanks very much
i have use this command to add the access database as follow:
EXEC sp_addlinkedserver
@.server = 'example',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'OLE DB Provider for Jet',
@.datasrc = 'C:\example.mdb'
GO
but the output is: 1 row affected
1 row affected
however in the sp_serverlinkedserver man page say it should return:server added
and i can not see example database after i performe the above command.|||i also have question
1.how can i access the database after sp_addlinkedserver
2.can i create stored procedures to this database which is sp_addlinkedserve(ed) access database|||Sorry, you've exhausted the extent of my knowledge on the subject. :-) I've only done this with Excel and other SQL Servers myself.
Terri|||that's all right
i just want to ask when you sp_addlinkedserver with Excel or other SQL server, where can you find you database(the one you just inported)?or how can you use you database|||
Dear friends,
I need some help. Here is what I am trying to do.
I have inserted and Excel object as an ActiveX control on my aspx page. When this page is opened, I do see the Excel control. - but blank.
What I would like to know, is how to specify an Excel file ( e.g MyFile.xls) that should appear in the control when the page is opened. I have tried with the properties available on the control, but with no luck.
Your help will be very helpful.
Thanks.
Mwan
No comments:
Post a Comment