regarding connection to profile stage
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
regarding connection to profile stage
Hi,
actually iam working on access databases,first step i did was using connection manger connected the repository, used the odbc that was defined while installing profile stage.After that used the load metadata option, the meta data is loading.But couldn't connect to access databases.
my server is sqlserver.i couldn't understand the problem.Iam created odbc for accessdatabases.iam stuck on this problem.Tried several ways but couldn't fix out.Urgent reply is sincerely appreciated.
cheers;
vijay
actually iam working on access databases,first step i did was using connection manger connected the repository, used the odbc that was defined while installing profile stage.After that used the load metadata option, the meta data is loading.But couldn't connect to access databases.
my server is sqlserver.i couldn't understand the problem.Iam created odbc for accessdatabases.iam stuck on this problem.Tried several ways but couldn't fix out.Urgent reply is sincerely appreciated.
cheers;
vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
plz reply urgent
Hi,
iam not able to select the access databases in the connection manager, which iam working on.i created a dsn using access driver and used that dsn to connect.In the psdb i used the dsn which we create while installing the software.but iam not able to select my access databases.
cheers;
vijay
iam not able to select the access databases in the connection manager, which iam working on.i created a dsn using access driver and used that dsn to connect.In the psdb i used the dsn which we create while installing the software.but iam not able to select my access databases.
cheers;
vijay
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
error message
Hi,
it comes up with the message load metadata process is halted.
cheers;
dileep
it comes up with the message load metadata process is halted.
cheers;
dileep
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
i created system dsn. i need to wwwork on access databases.This is what i have given.
IN THE CONNECTION MANAGER.
CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT.
DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER.
IN THE LOAD METADATA I CREATED NEW DSN WHICH I CREATED BY USING ACCESS DATABASES.THE THING IS THAT IAM NOT ABLE TO SELECT ACCESS DATABASES, ANY BODY PLZ HELP ME OUT.
CHEERS;
VIJAY
IN THE CONNECTION MANAGER.
CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT.
DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER.
IN THE LOAD METADATA I CREATED NEW DSN WHICH I CREATED BY USING ACCESS DATABASES.THE THING IS THAT IAM NOT ABLE TO SELECT ACCESS DATABASES, ANY BODY PLZ HELP ME OUT.
CHEERS;
VIJAY
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Etiquette Note
Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. If you would like me to visit your site to diagnose the problem I would be happy to quote to provide this service.
Is the Message Switch running? Is there anything pertinent in its log?
Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. If you would like me to visit your site to diagnose the problem I would be happy to quote to provide this service.
Is the Message Switch running? Is there anything pertinent in its log?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
hi,
i need to work on access databases.my problem is iam not able to intialize them.
IN THE CONNECTION MANAGER.
CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT.
DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER.
IN THE LOAD METADATA I CREATED NEW DSN WHICH I CREATED BY USING ACCESS DATABASES.THE THING IS THAT IAM NOT ABLE TO SELECT ACCESS DATABASES, ANY BODY PLZ HELP ME OUT.
CHEERS;
VIJAY
i need to work on access databases.my problem is iam not able to intialize them.
IN THE CONNECTION MANAGER.
CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT.
DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER.
IN THE LOAD METADATA I CREATED NEW DSN WHICH I CREATED BY USING ACCESS DATABASES.THE THING IS THAT IAM NOT ABLE TO SELECT ACCESS DATABASES, ANY BODY PLZ HELP ME OUT.
CHEERS;
VIJAY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Etiquette Note
Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. Your failure to answer reasonable questions does not help.
Is the Message Switch running? Is there anything pertinent in its log?
This question is asked because all requests to and from the client and to and from the PSDB are passed through the Message Switch.
Further Etiquette Note
If you "shout" one more time I shall cease to respond on this thread.
Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. Your failure to answer reasonable questions does not help.
Is the Message Switch running? Is there anything pertinent in its log?
This question is asked because all requests to and from the client and to and from the PSDB are passed through the Message Switch.
Further Etiquette Note
If you "shout" one more time I shall cease to respond on this thread.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.