connection manager in SQL 2005

I am writing a new Ole DB connection thru connection manager in Visual
Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
specify a database path as d:\temp\database.dbf and set up the extended
proporties in advance tab to dBase 5.0 and when I click "test connection"
button, I gives me an error:
"Test connection failed because of an error in initializing provider.
'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
spelled correctly and that you are connected to the server on which the file
resided. "
I used browser button to get the file and path and therefore I am sure it is
correct. Can anyone please help to fix this problem? Many thanks.
Hi
"00EricClapton" wrote:

> I am writing a new Ole DB connection thru connection manager in Visual
> Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
> specify a database path as d:\temp\database.dbf and set up the extended
> proporties in advance tab to dBase 5.0 and when I click "test connection"
> button, I gives me an error:
> "Test connection failed because of an error in initializing provider.
> 'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
> spelled correctly and that you are connected to the server on which the file
> resided. "
>
> I used browser button to get the file and path and therefore I am sure it is
> correct. Can anyone please help to fix this problem? Many thanks.
>
Are you sure that the file has the correct permissions and is not locked by
another application?
John

connection manager in SQL 2005

I am writing a new Ole DB connection thru connection manager in Visual
Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
specify a database path as d:\temp\database.dbf and set up the extended
proporties in advance tab to dBase 5.0 and when I click "test connection"
button, I gives me an error:
"Test connection failed because of an error in initializing provider.
'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
spelled correctly and that you are connected to the server on which the file
resided. "
I used browser button to get the file and path and therefore I am sure it is
correct. Can anyone please help to fix this problem? Many thanks.Hi
"00EricClapton" wrote:

> I am writing a new Ole DB connection thru connection manager in Visual
> Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
> specify a database path as d:\temp\database.dbf and set up the extended
> proporties in advance tab to dBase 5.0 and when I click "test connection"
> button, I gives me an error:
> "Test connection failed because of an error in initializing provider.
> 'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
> spelled correctly and that you are connected to the server on which the fi
le
> resided. "
>
> I used browser button to get the file and path and therefore I am sure it
is
> correct. Can anyone please help to fix this problem? Many thanks.
>
Are you sure that the file has the correct permissions and is not locked by
another application?
John

connection manager in SQL 2005

I am writing a new Ole DB connection thru connection manager in Visual
Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
specify a database path as d:\temp\database.dbf and set up the extended
proporties in advance tab to dBase 5.0 and when I click "test connection"
button, I gives me an error:
"Test connection failed because of an error in initializing provider.
'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
spelled correctly and that you are connected to the server on which the file
resided. "
I used browser button to get the file and path and therefore I am sure it is
correct. Can anyone please help to fix this problem? Many thanks.Hi
"00EricClapton" wrote:
> I am writing a new Ole DB connection thru connection manager in Visual
> Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
> specify a database path as d:\temp\database.dbf and set up the extended
> proporties in advance tab to dBase 5.0 and when I click "test connection"
> button, I gives me an error:
> "Test connection failed because of an error in initializing provider.
> 'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
> spelled correctly and that you are connected to the server on which the file
> resided. "
>
> I used browser button to get the file and path and therefore I am sure it is
> correct. Can anyone please help to fix this problem? Many thanks.
>
Are you sure that the file has the correct permissions and is not locked by
another application?
John

Connection in transformation component

Hi,

I'm on writing a custom data flow component (transformation). For this I need access to an external datasource. As best practice, it seems that you should use a connectionmanager in the package.

But I don't really know how to access them.

I've overwritten the AquireConnections() to lookup in the RuntimeConnectionCollection for the connection managers. But It seems it doesnt get called. If I call it my own, for example in validate (just for debugging purposes) the collection is empty, although there are two connectionmanagers in the package.

What am I doing wrong or has someone a code snippet for me.

Thanks T.

To make the package connections available within the AcquireConnection or ReleaseConnection method, (make sure you use the latter to close any connection resources), you first have define the component as having one or more connections. You do this in the ProvideComponentProperties method, so just add it and give it a name, description if you feel like it.

IDTSRuntimeConnection90 runtimeConnection = ComponentMetaData.RuntimeConnectionCollection.New();

runtimeConnection.Name = "Reference Data";

This acts as a placeholder, so that if you were to now look at the built-in Advanced UI Editor, on the first page you will see the connection listed, ready for you to choose one of the existing package connections.

connection and getting data from a logfile?

Hi,

i am writing a program that have to get data from a logfile into a database.

Can anyone tell me how to connect and get data from it?

I am working in asp.vb in the Visual Studio 2005 program.

Thanks

There are lots of ways to get data in SQL Server, here are some ideas;

1/ Make sure the file is in a format that Integration Services can read, call it from code.

2/ Use Log Parser

3/ read the data into a datatable/dataset and then use BulkCopy to load that into SQL Server

4/ Lots more

|||

Hi,

thanks for the answer i will shurely try this!

Greetz

Crazydj

connecting to sql server through firewall

SQL server seems to be having problems writing to another
sql server database server behind a firewall. The ip
address is able to be pinged through the firewall but
trying to access sql server gives "server does not exist
or access is denied" message. The firewall has been
setup to allow for this particular ip address. Port 1433
is selected and TCP/IP is selected from Client Network
Utility and Server Network Utility.
Any ideas anyone? TIA!Hi Steve:
Suggest you try these steps:
1.Try to close firewell a moment, at that moment, test if the remote
connect work well.
2. If it does not work well, not the problem of firewall, but the
problem of network
If it work well, enable the firewall can try to ping 1433 port on the
remote machine
After these two steps, we can see what problem it is then we can do
more
Best Wishes
Wei Ci Zhou|||Dear Wei,
I did as you suggested and it was indeed the firewall. There was a rule
allowing port 1433 but another rule above that that barred all ports.
Thank you again for your response and your assistance!
Steve
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Connecting to SQL Server 7.0

Hi,
We are writing a Java stand-alone program and need to connect to a SQL
server 7.0 database.
I can't find any drivers to connect to the database. There are very few
which are in the market with interoperability with MS SQL Server7.0. The res
t
are all pointing to MS SQL 2000 or 2005.
Can you please point me to a driver to access SQL Server 7.0 through Java?
If possible a freeware version.You can find a list of vendors who have JDBC drivers at:
http://www.sqlsummit.com/JDBCVend_I.htm
You may be interested in jTDS as well:
http://jtds.sourceforge.net/
-Sue
On Thu, 10 Aug 2006 13:34:01 -0700, Srini
<Srini@.discussions.microsoft.com> wrote:

>Hi,
>We are writing a Java stand-alone program and need to connect to a SQL
>server 7.0 database.
>I can't find any drivers to connect to the database. There are very few
>which are in the market with interoperability with MS SQL Server7.0. The re
st
>are all pointing to MS SQL 2000 or 2005.
>Can you please point me to a driver to access SQL Server 7.0 through Java?
>If possible a freeware version.