|
Hi,
You can do it by following the below steps:
1. Create a System DSN, giving the connectivity to the SQL Server database, which u want to import.
2. Create a new Acesss Databe(.mdb)
3. Goto files,select Get External Data -> Import.
4. Now from the file types, select the ODBC databases and locate the dsn whihc u have created.
5. Choose the tables which u want to import and click Ok.
This will import all the selected SQl tables to your Acess databse.
Indus_v
|
|
|
|
|
I have not relationship!!!!
|
|
|
|
|
Hi,
Although i have successfully implemented the Microsoft Data Access Application Blocks with Oracle 8i but i am suspicious reagrding the DAAB compatibility with Oracle 10G.
If anybody has used the DAAB with the Oracle 10g or has the knowledge regarding the same, kindly share it and help me our.
~Indus_v
|
|
|
|
|
hello
I want to use multiple database .They may be on different server?
can you help me about the problems that i will have?can you suggest one article?
|
|
|
|
|
Hi,
You can go for the Database Access Application Blocks, if you want to use multiple databases simultaneously in a single applications.
You can got to the Microsoft site for this:
ttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp
Indus_v
|
|
|
|
|
|
First, in order to answer your question well we need to know what the database technology is and what it will be communicating with. The rest of the answer assumes SQL Server 2000 and .NET
If you are having the databases communicate with each other you can set up linked servers and then refer to them using the 4 part table notation like this:
[server].[database].[schema].[table]
[server].[database].[schema].[view]
[server].[database].[schema].[stored_procedure]
If you are communicating with .NET you can use the normal provider mechanism and open separate connections to each database you need. You can have multiple connections to multiple servers if your application requires it. Your ConnectionString will point to the relevant database and server.
If you need to connect to both databases through one SqlConnection you can link the servers and then connect to the server that has the link (this will be the local server, the server that has been linked to is the remote server). You can then use the 4 part names, see above, to work with the correct data on the correct server.
NOTE: If you are using data on the local server you don't need to use the full 4 part name, however, I've found that when dealing with linked servers that using the 4 part name always reduces ambiguity and makes tracking down bugs easier as I'm not left wondering what connection something was running on and which server is local and which is remote.
Does this help?
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
I beleave you shoud create a linked server between database.
select article_id from samcpd05.online.dbo.dimensao_produto
left join samcpd29.onlinehist.dbo.produtos on ....
samcpd29 = server
onlinehist = database
if you need more examples my e-mail is: sadmilson@terra.com.br
|
|
|
|
|
I am running Access 2002.
I want to do something similar to the following:
SELECT * FROM tb1
LEFT JOIN
( SELECT tb2.ID AS tb2_ID, tb2.Author AS tb2_Author, tb2.Address AS tb3_Address
FROM tb2, tb3
WHERE tb2.Address = tb3.ID ) AS sb1
ON sb1.tb2_ID = tb1.Author
How can I do that?
----
to die is gain
|
|
|
|
|
Yes you can really close to what you have already.
You are joining from the sub out. and that should be ok.
Its called a correlated sub query..
The problem is I dont see your point in this particular example. It could be that I am just missing it.
But really you could just rewrite your example
SELECT tb1.namedfields, AS tb2_ID, tb2.Author AS tb2_Author, tb2.Address AS tb3_Address FROM tb1 LEFT JOIN tb2.author ON FROM tb2.id = tb1.id left join tb3 on tb2.Address = tb3.ID
http://www.jasncab.com/huberblog :: Jason Huber
|
|
|
|
|
Hi. I have some questions for you:
How the field, which has type "counter", can be read/write (in DB Access)?
How the program can get the unique number for this key-field (in DB Access)?
How the field, which has type "MEMO", can be read/write (in DB Access)?
|
|
|
|
|
Hi
How i can read rows From database DB1 -> Table T1 and insert rows into DB2->Table T2 ?
Thanks
|
|
|
|
|
|
This exemple I'm using SQL Server and reading Informix Database... If you are using SQL Server try "OpenQuery".
SELECT cd_EmpresaOPTV, dtfechamento
FROM
OpenQuery(infempfk, 'select E.cd_EmpresaOPTV, F.dtfechamento from geempresa E, fecctbilunid F where E.id_empresa=F.idempgrp And F.idmodulo=19 and E.cd_EmpresaOPTV is not null ')
|
|
|
|
|
If you using only Sql Server:
insert into samcpd05.online.dbo.invent
select name,phone from samcpd29.onlinehist.dbo.invent_hist
In this example we have two databases in two servers samcpd05 and samcpd29...
|
|
|
|
|
Dear all,
I am using FireBird .Net Adapter and able to create FB database using below code (C#):
Hashtable parameters = new Hashtable();
parameters.Add("User", UserName);
parameters.Add("Password", Password);
parameters.Add("Database", @FilePath);
parameters.Add("ServerType", 1);
FbConnection.CreateDatabase(parameters);
After creating the database, I am able to open it using FBConnection for the first time. But after that, whenever I open the database, I am getting this error:
internal gds software consistency check (Internal error code (165))
Any idea? Thanks.
regards,
vic
|
|
|
|
|
select (1/2)
How to get the result 0.5? Thanks
<italic>Work hard, Work effectively.
|
|
|
|
|
|
Thank you Colin. One more thing, how to cast float with scale of two (two digits to the right of the decimal point).
<italic>Work hard, Work effectively.
|
|
|
|
|
I am using DataSet to insert a data row which contains a 6MByte binary file in "Data" column.
According to the MySQL manual for 4.0, I define the "Data" column as "longblob", which suppose to store up to 4GByte file. But it just doesn't work.
With the exact same code, if my data is less than 100KByte, it works fine.
Can anybody tell if I have to config anywhere else to make this work?
From MySQL 4.0, the maximum allowed length of LONGBLOB columns depends on the configured maximum packet size in the client/server protocol and available memory.
I just wonder what "client/server protocol" refers to? How can I figure out the maximum packet size?
|
|
|
|
|
Hi,
Mikey just sorted out my first problem, the next one is this.
In my stored procedure in sqlserver i used OUTPUT Parameters, im not sure i can do this in MYSQL as im not using stored procedure;
this is my code;
' the connection string
myconnection = New MySqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
' the query
strSQL = "SELECT ?SubDesc=SubDesc, ?SubName=SubCatName FROM SubCategory WHERE SubcatID = ?SubID;"
mycommand = New MySqlCommand(strSQL, myconnection)
' Input Parameter
Dim parameterSubID As MySqlParameter = New MySqlParameter("?SubID", SubCatID)
mycommand.Parameters.Add(parameterSubID)
' Output Parameter
Dim parameterSubCatDesc As MySqlParameter = New MySqlParameter("?SubDesc", MySqlDbType.String, 500)
parameterSubCatDesc.Direction = ParameterDirection.Output
mycommand.Parameters.Add(parameterSubCatDesc)
Dim parameterSubName As MySqlParameter = New MySqlParameter("?SubName", MySqlDbType.String, 50)
parameterSubName.Direction = ParameterDirection.Output
mycommand.Parameters.Add(parameterSubName)
' execute read
myconnection.Open()
mycommand.ExecuteNonQuery()
myconnection.Close()
Label1.Text = CStr(parameterSubCatDesc.Value)
Label2.Text = CStr(parameterSubName.Value)
I dont know if anyone can help me on this? Mike what about this one!
Cheers
Jetset
|
|
|
|
|
i forgot to say the problem,
the code runs but nothing is returned in the labels
|
|
|
|
|
Is there any way to create function that can return a recordset? i tried to do it but...
i forgot... the other thing is how to "catch" returned recordset? does CRecordset have any copy constructor or sth?
|
|
|
|
|
Can somebody tell me how to get this done on SQL reporting.
I need to print the column headings vertically like this H
E
A
D
I
N
G
instead of this - HEADING
thanx
|
|
|
|
|
I wrote a stored procedure to do a simple update to a table in one of my dbs:
ALTER PROCEDURE usp_cmrapprupd<br />
(@id nvarchar(50),@name int,@appr nvarchar(1))<br />
AS<br />
UPDATE approvers SET approver_identifier = @name, approved_by_approver = @appr<br />
<br />
WHERE identifier = @id
now, with the exception of @id being an nvarchar, this stored procedure is identicle to another one for another table. the only difference between the two tables is that one uses integers as the id, and the other uses nvarchars.
the update on the int table works just dandy, but the one listed about keeps giving me the following error:
Violation of PRIMARY KEY constraint 'PK_approvers'. Cannot insert duplicate key in object 'approvers'.
What is giving me a headache is how am I violating primary key constraints if i am doing an update rather than insert?
Update:
OKay, I discovered a consistancy. The table uses both identifier and approver_identifier as primary keys. If i try to update something with a single instance of identifier, it works (example, identifier 1-1 has 3, 1-1 with approver_identifier of 1, 1-1 with approver_identifier of 2, etc, i get the error. however, if i have an identifier of 4-1 and only an approver_identifier of 1, the update works)
Any ideas?
______________________
Mr Griffin, eleventy billion is not a number...
|
|
|
|