ODBC DSN ....

Hello .
im programing a one application
in Delphi . and my program connected to
sql server successfully . but thats not why
im calling . suppose i exported my program ( .exe )
and sell it . as you know in users pc DSN dosnt
exist in odbc . can they open my program without
DSN in their systems ? or i must create DSN File
and export it by Setup in Users pc ?
Help me please . thanks for your worksYou can use dsn-less connections or you could
programmatically create the needed DSN as part of your
setup/install package. I'm not sure how to code it in Delphi
but the following are VB examples that might help you get
started:
HOWTO: Create and Remove a DSN in Visual Basic
http://support.microsoft.com/defaul...b;EN-US;q171146
HOWTO: Programmatically Create a DSN for SQL Server with VB
http://support.microsoft.com/defaul...b;EN-US;q184608
-Sue
On Thu, 4 Dec 2003 01:39:50 -0800, "Toxi_boy"
<stanboy733@.hotmail.com> wrote:

quote:

---

>Hello .
>im programing a one application
>in Delphi . and my program connected to
>sql server successfully . but thats not why
>im calling . suppose i exported my program ( .exe )
>and sell it . as you know in users pc DSN dosnt
>exist in odbc . can they open my program without
>DSN in their systems ? or i must create DSN File
>and export it by Setup in Users pc ?
>Help me please . thanks for your works

---

sql

ODBC Data Source

I am new to SSIS packages and want to use an ODBC data source connected to an old Btrieve set of data files. I set up the ODBC DSN, and my SQL Server Data Connection, and can browse the tables in the Server Explorer. However with regards to my SSIS package, I'm not sure whether to use an OLE DB Source or Data Reader Source. I have futzed with both of them but haven't had any luck at seeing the tables. Can someone please give me some tips.

Thanks,
Carson

Carson,

Use the OLE DB Source. That's generally regarded as the default option and, I think, will be quicker than datareader source.

-Jamie

|||

Then this is my issue with the OLE DB Source. I go into the OLE DB Source Editor, nothing is listed in my OLE DB Connection Manager dropdown, so I click the "New..." button.

The Configure OLE DB Connection Manager window pops up, but nothing is listed under Data Connections, the listbox is blank. So I click the "New..." button on this popup window. (Keep in mind, in my Server Explorer I have two Data Connections my localhost and the ODBC DSN i explained in my first post. Also, in the bottom of the package, under the tab Connection Managers I also have defined an ODBC DSN connection by right clicking and selecting New Connection and then ODBC.)

Then up comes the Connection Manager popup, yet ODBC is not in the drop-down list of Providers like it was when I created a Connection Manager by right-clicking in the section Connection Manager found underneath the package DataFlow.

I do not have an OLE driver for this old Btrieve data source, only a working ODBC driver.

Please advise.

Thanks!

|||

Carson,

The only way to use ODBC connections in SSIS is by using ADO .NET provider for ODBC. That implies you have to use Data Reader source with it. There is no a custom UI for the Data Reader source component so you would need to type your query (select * from <tableName> or equivalent one) directly into the SQLCommand property. You will not be able to see available tables.

HTH.

|||

Thank you for this explanation, that helps. I'm assuming that before I can set the SQLCommand property, I have to set the Connection Manager in the first tab of the Advanced Editor. When I do, I get the following error: "Error at Data Flow Task [DataReader Sourcer [175]]: Cannot acquire a managed connection from the run-time connection manager." Can someone please explain what to do with this error?

I created the connection manager for my ODBC data source by right-clicking in the area directly under the package data flow UI, and selecting "New Connection", then selecting "ODBC", then I create a new connection manager by setting the system data source name to the ODBC DSN that I created. The same DSN I can browse the tables with in the Server Explorer.

Please advise.

Thanks!!

|||

You have to choose "New ADO .NET Connection..." from the menu, click on the "New..." button of the next dialog, select .NET Providers/Odbc Data Provider in the first drop-down of the following dialog and then choose your DSN.

This way created connection can now be used in the advanced UI of the Data Reader Source.

Thanks.

|||Bob - You 'Da Man!! That worked!|||

Bob, where is the option for new ado .net connection?

Thanks

|||

Right-click in the "Connection Managers" window and then follow my previous post.

HTH.

ODBC Data Source

I am new to SSIS packages and want to use an ODBC data source connected to an old Btrieve set of data files. I set up the ODBC DSN, and my SQL Server Data Connection, and can browse the tables in the Server Explorer. However with regards to my SSIS package, I'm not sure whether to use an OLE DB Source or Data Reader Source. I have futzed with both of them but haven't had any luck at seeing the tables. Can someone please give me some tips.

Thanks,
Carson

Carson,

Use the OLE DB Source. That's generally regarded as the default option and, I think, will be quicker than datareader source.

-Jamie

|||

Then this is my issue with the OLE DB Source. I go into the OLE DB Source Editor, nothing is listed in my OLE DB Connection Manager dropdown, so I click the "New..." button.

The Configure OLE DB Connection Manager window pops up, but nothing is listed under Data Connections, the listbox is blank. So I click the "New..." button on this popup window. (Keep in mind, in my Server Explorer I have two Data Connections my localhost and the ODBC DSN i explained in my first post. Also, in the bottom of the package, under the tab Connection Managers I also have defined an ODBC DSN connection by right clicking and selecting New Connection and then ODBC.)

Then up comes the Connection Manager popup, yet ODBC is not in the drop-down list of Providers like it was when I created a Connection Manager by right-clicking in the section Connection Manager found underneath the package DataFlow.

I do not have an OLE driver for this old Btrieve data source, only a working ODBC driver.

Please advise.

Thanks!

|||

Carson,

The only way to use ODBC connections in SSIS is by using ADO .NET provider for ODBC. That implies you have to use Data Reader source with it. There is no a custom UI for the Data Reader source component so you would need to type your query (select * from <tableName> or equivalent one) directly into the SQLCommand property. You will not be able to see available tables.

HTH.

|||

Thank you for this explanation, that helps. I'm assuming that before I can set the SQLCommand property, I have to set the Connection Manager in the first tab of the Advanced Editor. When I do, I get the following error: "Error at Data Flow Task [DataReader Sourcer [175]]: Cannot acquire a managed connection from the run-time connection manager." Can someone please explain what to do with this error?

I created the connection manager for my ODBC data source by right-clicking in the area directly under the package data flow UI, and selecting "New Connection", then selecting "ODBC", then I create a new connection manager by setting the system data source name to the ODBC DSN that I created. The same DSN I can browse the tables with in the Server Explorer.

Please advise.

Thanks!!

|||

You have to choose "New ADO .NET Connection..." from the menu, click on the "New..." button of the next dialog, select .NET Providers/Odbc Data Provider in the first drop-down of the following dialog and then choose your DSN.

This way created connection can now be used in the advanced UI of the Data Reader Source.

Thanks.

|||Bob - You 'Da Man!! That worked!|||

Bob, where is the option for new ado .net connection?

Thanks

|||

Right-click in the "Connection Managers" window and then follow my previous post.

HTH.

ODBC Access Link to SS2K5-Cannot update new records.

Access 2003 connected via ODBC using
ODBC;Driver={SQL Native
Client};Server=ServerName;Database=DbName;UID=xx;P WD=xxx
Originally the data was imported from Access tables. All imported records
can be edited or updated without a problem but new records created from
access using code or access table views cannot be edited.
The returned error:
The records has been changed by another since you started editing it. ...
If a record is copied from an existing record by cutting and pasting the
complete record in an access table view then it is ok but if the record is
added by going to the new record (*) at the bottom of the table and adding
the one field that does not allow nulls then the autonumber gets updated
properly but none of the other fields can be edited.
It appears the SS2K5 server will not allow the access application to delete
one of the records that cannot be edited either.
The error:
The Microsoft Jet dtabase engine stopped the process because you and another
user are attempting to change the same data at the same time.
If you log into the Server using Management Studio with the same credentials
you can do anything you want.
Looked a differnet connection strings but am not aware of an ODBC
configuration with record locking directives.
Thanks in advance for any help you might offer.
RobGMiller
It's hard to diagnose a problem like this without being able to see
the database schema and the application/form code. One thing that
often helps is to add a timestamp column to the table. This lets
Access know if a row has been altered by another process since it was
fetched.
-Mary
On Fri, 14 Dec 2007 12:43:02 -0800, RobGMiller
<RobGMiller@.discussions.microsoft.com> wrote:

>Access 2003 connected via ODBC using
>ODBC;Driver={SQL Native
>Client};Server=ServerName;Database=DbName;UID=xx; PWD=xxx
>Originally the data was imported from Access tables. All imported records
>can be edited or updated without a problem but new records created from
>access using code or access table views cannot be edited.
>The returned error:
>The records has been changed by another since you started editing it. ...
>If a record is copied from an existing record by cutting and pasting the
>complete record in an access table view then it is ok but if the record is
>added by going to the new record (*) at the bottom of the table and adding
>the one field that does not allow nulls then the autonumber gets updated
>properly but none of the other fields can be edited.
>It appears the SS2K5 server will not allow the access application to delete
>one of the records that cannot be edited either.
>The error:
>The Microsoft Jet dtabase engine stopped the process because you and another
>user are attempting to change the same data at the same time.
>If you log into the Server using Management Studio with the same credentials
>you can do anything you want.
>Looked a differnet connection strings but am not aware of an ODBC
>configuration with record locking directives.
>Thanks in advance for any help you might offer.

ODBC Access Link to SS2K5-Cannot update new records.

Access 2003 connected via ODBC using
ODBC;Driver={SQL Native
Client};Server=ServerName;Database=DbNam
e;UID=xx;PWD=xxx
Originally the data was imported from Access tables. All imported records
can be edited or updated without a problem but new records created from
access using code or access table views cannot be edited.
The returned error:
The records has been changed by another since you started editing it. ...
If a record is copied from an existing record by cutting and pasting the
complete record in an access table view then it is ok but if the record is
added by going to the new record (*) at the bottom of the table and adding
the one field that does not allow nulls then the autonumber gets updated
properly but none of the other fields can be edited.
It appears the SS2K5 server will not allow the access application to delete
one of the records that cannot be edited either.
The error:
The Microsoft Jet dtabase engine stopped the process because you and another
user are attempting to change the same data at the same time.
If you log into the Server using Management Studio with the same credentials
you can do anything you want.
Looked a differnet connection strings but am not aware of an ODBC
configuration with record locking directives.
Thanks in advance for any help you might offer.
RobGMillerIt's hard to diagnose a problem like this without being able to see
the database schema and the application/form code. One thing that
often helps is to add a timestamp column to the table. This lets
Access know if a row has been altered by another process since it was
fetched.
-Mary
On Fri, 14 Dec 2007 12:43:02 -0800, RobGMiller
<RobGMiller@.discussions.microsoft.com> wrote:

>Access 2003 connected via ODBC using
>ODBC;Driver={SQL Native
> Client};Server=ServerName;Database=DbNam
e;UID=xx;PWD=xxx
>Originally the data was imported from Access tables. All imported records
>can be edited or updated without a problem but new records created from
>access using code or access table views cannot be edited.
>The returned error:
>The records has been changed by another since you started editing it. ...
>If a record is copied from an existing record by cutting and pasting the
>complete record in an access table view then it is ok but if the record is
>added by going to the new record (*) at the bottom of the table and adding
>the one field that does not allow nulls then the autonumber gets updated
>properly but none of the other fields can be edited.
>It appears the SS2K5 server will not allow the access application to delete
>one of the records that cannot be edited either.
>The error:
>The Microsoft Jet dtabase engine stopped the process because you and anothe
r
>user are attempting to change the same data at the same time.
>If you log into the Server using Management Studio with the same credential
s
>you can do anything you want.
>Looked a differnet connection strings but am not aware of an ODBC
>configuration with record locking directives.
>Thanks in advance for any help you might offer.

ODBC ACCESS

I have a VIEW SQL connected to an other database. How I can connect
this VIEWS in ACCESS inserting one key in runtime?
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community
Website: http://www.sqlJunkies.com/newsgroups/"domed" <darrigod@.-NOSPAM-tiscali.it> wrote in message
news:eo7FUPK9DHA.2480@.TK2MSFTNGP12.phx.gbl...
> I have a VIEW SQL connected to an other database. How I can connect
> this VIEWS in ACCESS inserting one key in runtime?
>
I'm not sure I understand your question... Any time you update data
programmatically, I'd recommend using a stored procedure, this you could
code to update tables in other database(s) if required.
Steve