Connectivity Portal (WIKI)

Nov 15, 2006

Hi All,
 
Wouldn€™t it be nice to have a single portal to check the list of data sources SSIS can connect to? Like, if and how SSIS can connect to SAP/Oracle/DB2/SQL Server/etc? along with what to expect from that connection, such as 64-bit support, fast data load option, scalability, etc?
 
The know-how around connectivity in SSIS has particularly been challenging to structure in terms of gathering and reaching all sorts of connectors and data sources out there.
 
The challenge is due to two main reasons:
 


Microsoft does not have central command/control on connector developers, and the connectivity story for SSIS has mainly been the support around ADO.NET, Ole DB and ODBC libraries. Since we don€™t have a certification process, it€™s up to the customer to evaluate a specific third party connector before making a decision on using it.

The extensibility story offered by SSIS inherently promotes development of new/specialized connectors to new/existing data sources. Since any application can talk to any other application given the right connector, the pool of supported connectors keep growing over time.
 
We are working to make this story better, but in the mean time, because of this ever growing nature of connectors and their features, I thought a WIKI portal can help this community in terms of formalizing/structuring/sharing information.
 
And thus, I am launching a new wiki site on connectivity. Well€¦Blogs are kind of not as cool these days anyways J MSDN has a recent wiki initiative, but it is not quite involving the community as I€™d like to have in this one.  
 
We have a great talent pool and a huge base of know-how around connectivity in this forum. Let€™s channel that into sorting out connectivity!
 
I created the initial site framework and provided simple samples here : http://ssis.wik.is/Home
 
I€™ll add more stuff to it in the coming days as well, but I really want this forum to be actively editing/providing content in there.
 
Please take a look at it, and start growing/editing it. -> http://ssis.wik.is/Home
 
Ideas/questions/feedback are all welcome, you can also e-mail me directly at denizerkan@yahoo.com
 
Thanks,
Deniz Erkan
 
PS: this is not in conflict or competition with the forum. Forum interface does not have a way to structure data to build a know-how, and the scope of this initiative is SSIS connectivity-only.

View 3 Replies


ADVERTISEMENT

BIP Portal

Mar 22, 2004

Hi everyone,

I've just installed the BIP portal on an Application Server running Windows 2000 with the latest Service Pack and I choose to install the BIP database on a database Server. I've put my user in the BIP_ADMIN on the Application server's local windows user-group and also in the BIP_USERS role on the database BIP. If I try to browse the URL on the the application server it works well, but when I try to browse from my local machine thorough the network I get the following message: User 'AGFBRASILGAVieira' do not currently have access to the database. Please add the user to 'BIP_USERS' user group on SQL server's machine or contact the system administrator.

Anyone could help me?


Thanks in advance,

Genilson from São Paulo, Brazil.

View 7 Replies View Related

Portal Available?

Jun 10, 2007

Hey, anyone recommend an interface/portal that can connect to MS SQL SERVER? I've seen a couple, but haven't like them at all. It would be much easier if I could do the quick stuff I need to do from my desktop and just connecting in, rather then jumping on the server which I do now. Any good ones out there, that kind of do it all?

Thanks!

View 1 Replies View Related

Designing Database For Jobs Portal

May 27, 2006

Hi...

I am making a online job portal....for dat i need to make a gud database.

wud anybody be kind enuf to provide or tell me how to make a good database design...

thnx..

View 1 Replies View Related

Tables Design And Linking For A Job Portal

Feb 28, 2008



Hi,

Currently i am developing a job portal in ASP 2.0, SQL Server 2005 which involves Job Seeker registration, Searching of resumes, applying for job Posting, Employer Registration, Create Job Posting, Searching for Job Seeker etc.
The Job Seeker is allowed to upload a word document of size up to 500Kb which is stored in Table as varbinary.

Right now I have MemberShip/Roles in seperate database. The Job Portal Tables are in seperate Database. I was told to split the Tables so that Tables of JobSeeker are One database and Employer to another Database so that they speed up the performance.

I have several tables that bridge (thats either store id's of Job Seeker or Employer) like Job Postings applied, Saved Postings Job Seeker, Job Postings of the Employer, Job Posting (Applied ones) alert etc.

Can any give me how to create a good Database design (one or more) with excellent performation. Right now I have one Database for Job Portal related tables excluding membership. The mapping of key fields including the fields that are enabled for Text indexing are given below.

(JobSeekerTable - Stores Personal Details)
JobSeekerId (PK)
...............

(JobSeekerResumeTable - Stores Resume Details)
JobSeekerResumeId (PK)
JobSeekerId (FK)
Job Title (enabled Text Indexing)
........

(JobSeekerDocTable - Stores Resume Details)
JobSeekerDocId (PK)
JobSeekerId (FK)
Resume (as varbinary) (enabled Text Indexing)
Covering Letter (Text)
........

(JobSeekerPostingTable - Stores Job Postings Saved by the Job Seeker)
JobSeekerPostingId(PK)
JobSeekerId (FK)
JobPostingId (FK)
......

(JobSeekerAppliedTable - Stores Job Postings Applied by the Job Seeker)
JobSeekerAppliedId(PK)
JobSeekerId (FK)
JobPostingId (FK)
.....

(CompanyTable - Employer Details)
CompanyId(PK)
.....

(JobPostingTable - Stores the information of the Job Posting created by Employer)
JobPostingId(PK)
CompanyId(FK)
Job Title (enabled Text Indexing)
Job Desc(enabled Text Indexing)
.....

(JobPostingConTable - Stores the information of the Job Posting Location Details )
JobPostingConId(PK)
JobPostingId(FK)
.....

(CompResumeSaved - Job Seeker details saved by Employer)
CompResumeSaved(PK)
CompanyId(FK)
JobSeekerId(FK)
.....

Eventually more tables would be added. Can any one tell me how to speed up the performance (particulary search engine fo Employer for searching resumes & Jobseeker for searching job Postings.) I hope I have mentioned everything clearly.

Thanks,
Uma Ramiya








View 4 Replies View Related

SSRS 2005 && Sharepoint Portal

Apr 30, 2006

how to integrate reporting services 2005 with Sharepoint portal

View 3 Replies View Related

SQL Server 2008 :: How To Give Name Instead Of IP Address To Web Portal

Aug 26, 2015

we have a server (Windows server 2008 R2 Standard) that runs a hyper V manager.The Hyper V manager runs 2 virtual servers.

One of the virtual servers uses the software XAMPP (it’s a web portal). The local IP for the virtual machine is 192.168.0.xxx

I have configured the XAMPP in a way so that any user in our domain can access the portal when the user writes the ip address in the web browser.Instead of the ip address, I want the user to be able to write a specific given name.

How can I create this?

View 3 Replies View Related

Registration Benefit Portal - Page Nopt Found

Jun 8, 2006

Hi, this text is taken from the FAQ and contains the same link the Registration email I received, which don't work (for me!). The link points to http://go.microsoft.com/fwlink/?LinkId=52054. Does anyone else have this problem?

NOTE: You can directly access the Registration Benefit Portal without need of a first or second benefit e-mail€”as long as you have completed the registration process and use the same e-mail to login in to Passport at the benefit porta

View 1 Replies View Related

How To Setup Sharepoint Portal Server 2003 With SQL Sever 2005

Apr 20, 2006

Hello, everyone

I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...??? I wanna know that How to setup it...

Setapong

View 1 Replies View Related

How Do I Video Create A Full-Featured Customer Login Portal - Missing Steps?

Apr 22, 2006

I watched the How do I  video "Create a Full-Featured Customer Login Portal" several times, and have compared my code to the downloaded VB code.  I seem to be missing something.
I am trying to replicate what he does in the video, where he uses the login name to query another database and display the matching data.  In the video he starts by using a querystring (page.aspx?userID=name) before creating a login page..  My program works with this method.  However, later he creates the login page, and the system seems to automatically link the user database with the northwind database and give results without the querystring.  There is no indication of how this is done.  When I examined the downloaded code, he actually uses a session variable in the Page_Load event on the orders page.  There is no explanation of this either, just a quick "I'll paste this from the clipboard." 
I have compared my code line by line, and it matches exactly.  I can only guess that there is a missing step where a relationship is established between the ASPNETDB.mdf file and the northwind.mdf file.  Can anyone explain this to me?  Thank you.
My goal is to have a user log in, and the site automatically query the second database for that users statistics, and display them. 

View 3 Replies View Related

SQL Server 2005 And SharePoint Portal Server 2003

Nov 3, 2005

Hello all,

View 1 Replies View Related

Sql Connectivity

Apr 24, 2008

how should i change my comnnetion string when i host the website in the server. i am having errors? but in local host its working fine?

View 3 Replies View Related

SQL 7 And BDE Connectivity

Sep 3, 2001

Hi,

I am responsible for an application that uses the Borland Database Engine to connect clients to the database server - it's called SalesLogix. I am in the process of upgrading the databases in the working environment to SQL 7 from SQL 6.5 and on the whole it has been (relatively) successful, however I have a majorly inconvenient issue with a few client machines. Occasionally, after upgrading the SQL client and having upgraded the database server I cannot make a connection any longer and instead when I try through the BDE I am presented with the message 'General SQL Error' and the BDE error code for a general SQL error, and nothing more. It has only happened on a couple of machines, but with no apparent pattern. The clients can still connect to SQL 6.5 databases as long as the SQL 6.5 client utilities are still installed so I don't know what to think. Any ideas?

Cheers,

Anthony

View 1 Replies View Related

Connectivity

Sep 8, 2003

Please Help.

I can ping my sql server using the IP address but not using the host name.

I run win XP desktop and SQL 2k sp 3 on WIN 2k SP3 two nodes active/passive cluster configuration.

Urgent

View 1 Replies View Related

Sql Connectivity

Sep 7, 1999

i have a server in US and the other at india iam trying to connect both the sql servers but iam unable to do it. Please tell me how to connect them

regards

aafreen

View 1 Replies View Related

Connectivity

Jul 13, 2006

Hello everybody.
I am connecting my computer to the internet and when i see the ip address of my computer i try:

telnet ipaddress 1433 but it says 'connection failed'.

this happens even when i try to access my sql server from another computer through the internet.

I have installed service pack 4,configured the server connectivity by adding the tcp/ip protocol and checked the port:it is 1433.

Also checked the firewalls ,but no results.

please help

View 4 Replies View Related

DB Connectivity

Nov 22, 2007

We are trying to setup a role based security access within our client software so that users have read only access to the database. Right now we are not able to connect to the database. This is a blocking issue for us on the project right now


Please let us know how to proceed now ?


Thanks in advance


Kishore

View 4 Replies View Related

TCP/IP Connectivity

Jul 20, 2005

Is it possible to approach a MS SQL Server using TCP/IP? I have lookedeverywhere but have not found any documentation about the protocol toconnect to MS SQL Server.I wish to connect to MS SQL Server directly through TCP/IP, without using MSlibraries (since i am not doing this on a windows system).Thanks in advance,Eddie Gieze

View 2 Replies View Related

SQL Connectivity

May 31, 2006

I am building a C# Windows app.  I have a form and have also create a db.  I tested the db connectivity in Server Explorer and the test came back successfully.  According to my manual, I just need to drag the db item from the server explorer to my form designer to creation the connection.  When I do this nothing happens... what am I doing wrong?

If I do the same thing in VS2003 the sqlConnection1 shows up, how do I accomplish the same thing with 2005?

View 1 Replies View Related

Connectivity Sql Ce

Nov 6, 2006

hi friends,

i am developing a dictionary for pocket device



i am using sql ce database .

i have included and copied that file in the project but every time exception occurs saying check the directory . file can not be found.....



may be this a little one but help me......

its urgent..........

View 5 Replies View Related

Database Connectivity

Jan 21, 2008

hi,
how to connect the database for first time
iam working for a website in that i have a form. how to connect the form to the database.
throw enterprice managment
thanks

View 1 Replies View Related

SQL Server Db Connectivity With Asp.net

Dec 27, 2004

Hi:
I m in new in ASP.net and can't connect sql server db with ASP.net.I write exact code.but it give error in connection string and server error some time.I found that error is in web.config file.can any one have running project of asp.net with sqlserver db..
if any one have then mail the project at this mail address..
ray_boby@hotmail.com

View 1 Replies View Related

Database Connectivity

Jul 26, 2005

Hi im new to ASP.NET.. can anyopne pelase tell me how to make database connectivity with sql server 2000.i need to insert data into sqlserver2000 database from an ASP.NET Web form. please provide me with a asample code.thank you

View 1 Replies View Related

SQL Server 7 Connectivity In C# && ASP .NET

Dec 13, 2005

I am using webforms for ASP .NET which has code in C#. My database is running on SQL Server 7. Whats the best way to connect to database. I have tried ODBC connection through myConnection=new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);but it gives me an error that can not connect to the SQL Server 2005 or it does not allow remote connections though it is running SQL Server 7 and not SQL Server 2005.  Thanks in advance.

View 1 Replies View Related

Database Connectivity

Jan 11, 2006

I am using SQL SERVER 2000 and asp.net How shoul i connect using OLEDB provider?.
In connection string, i am giving Provider=SQLOLEDB.1,datasource .
It's giving error in conn.open() that login failed for database. i am also poroving username and password in connection string, so i want code for the same.
awaiting for reply...

View 2 Replies View Related

Connectivity Issue Help

Apr 2, 2001

Hi,
I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.

View 1 Replies View Related

Connectivity Issue Help Again Please

Apr 2, 2001

Here's my post from a few minutes ago, thanks for the answer but that's not a fix, and trying to reconnect doesn't help. it never connects. I'm posting again, as otherwise people wouldn't read the older thread once it's replied too


I have a sql server that I cannot connect to in Enterprise Manager. I can connect no problem with Query Analyzer, but EM always gives me a "timeout expired" error. I am using tcp/ip, and my network card is configured exactly the same as another server that i can connect to fine. Any ideas? I really need to figure this out. this has nothing to do with timeout intervals, or anything like that, as it's all default settings, same as the other database...thanks.

View 1 Replies View Related

ASP Connectivity Change

Jul 2, 2001

I have a few ASPs that were written to pull from an Access 97 database. Now that we have converted the data over to a SQL database, the ASPs have been changed accordingly. My problem is that I have two ASPs which use an Inner Join between three tables where the main field (in this case it is called "INDEX") is what the pull is based on. When I try to run the ASPs I recieve this error .

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INDEX'.

The line that it identifies is where the connection is actually opened.
This is only occuring on the ASPs that use the column INDEX and an inner join. The straight style number pulls (which have the same connection string)
are working fine. Any ideas?

View 1 Replies View Related

SQL Server And Dos Connectivity

Feb 17, 2000

hello , i have a small problem , an associate want to connect to a micrsoft sql server under nt from a pc with only dos! can such a thing be done?

View 1 Replies View Related

Connectivity Problems

Mar 17, 1999

What do I need to do to enable a client PC to See a SQL server database? I keep getting ODBC timeout errors.


Help

View 2 Replies View Related

ASP / SQL 2000 Connectivity

Jan 5, 2003

Hi all,

I'm currently trying to connect my ASP page with an SQL server 2000 DB. I already know, how to connect with Access, through the the cobnnection object...

examlpe:
---------------------------
Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.ConnectionString = "DSN=cb_access_db"
'objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:dbCB_database.mdb"
objConn.Open
---------------------------

Now, i have SQL 2000 running on my local syste, and i'v ecreated a DSN..

How would i connec to it???

any input, or exampkles would help.Thanks!

DAve

View 2 Replies View Related

SQL Connectivity Problem From WIN 98

Aug 6, 2003

Hi,

We have a client machine that has Win98. From that they are running VB app that connects SQL 2000 Server.
Here is the code in the registry under

HKEY_CURRENT_USERSOFTWAREVB and VBA Program SettingsAppname folder

for running that application.

Provider=SQLOLEDB.1;Initial Catalog=dbname;Data Source=xxxx;Integrated Security=SSPI

From ODBC the system can connect to the database.

But from SQLOLEDB

It comes back with error:
-2147467259

Unable to connect.

Any ideas?

Thanks,
Anu

View 4 Replies View Related

Connectivity Problems - HELP!!!

Aug 5, 1999

I cannot (most of the time!!) get ODBC to make a connection to SQL Server 6.5 over the network. I get the following error:

Connection failed:SQLState: '01000' SQL server Error: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen[CreateFile()]. Connection failed:SQLState:'08001' SQLServer Error 1326 [Microsoft][ODBC SQL Server Driver][Client unable to establish connection.

I've looked in the SQL Server log and I've found:

"Error 17826, Severity:18, State:0 Unable to set up ListenOn Connection 'My Server Name'; OS Error: 10047"

I can get ODBC to connect from the same machine as SQL Server so it seems to be a network problem. I've tried using TCP/IP, Named Pipes, Multiprotocol, no joy. The network is ok i.e. I can ping and can otherwise find the server on the network. What's wierd is that on occassion I can get ODBC to connect!

Does anyone know what's going on???

Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved